You are not logged in.
Pages: 1
!ab,
Thank you very much for the detailed explanation.
Actually I did try my hands on FPC/Lazarus but for compiling a project for Linux one has to install fpcupDelux but could not wrap my head around it so I dropped it.
I also tried my hands on CodeTyphoon.
Yogi Yang
Hello,
I have tried FireDAC as well as Zeoslib to access SQLite database. I am able to do this in both but only when I compile my 64bit FMX application for windows platform.
But both of these need SQLite.dll so I take it that I cannot compile my application for Linux.
Are there any possibilities of using mORMot for building FMX app for Windows and Linux Desktop applications that will be accessing SQLite database (both plain and encrypted)?
Please guide me here.
Yogi Yang
Hello,
Thanks for the tip. I will give it a close look.
Hello,
I have plethora of databases created in PostgreSQL, MySql and SQLite. And some of the databases are very large having 280 tables with average 30 fields per table.
Hand coding such large database structures in Mormot is proving to be a nightmare at best.
Is there any utility that can reverse engineer an existing database and build required classes for Mormot?
TIA
Yogi Yang
I am also a newbie with this but from what I have experimented I think this functionality is still not implemented.
DrawBMP(Bmp,maxInt,50,'Some bitmap in the report');
In this line why do you use maxInt?
If I try to use any other value the image just does not print. Why?
TIA
Yogi Yang
Hello again,
I have got around 1000 images in one single folder.
I am trying to get their thumbnails to print like http://s3.postimg.org/dj4witwk3/2015_11_23_213907.jpg
But I am getting only image per line instead of multiple images on the same line.
Here is the main code that I am using for inserting image in PDF
LL := Col * 2500;
Bmp.Assign(ieTemp.Bitmap);
DrawBMP(Bmp,LL,50,FileName)
Col := Col +1;
What mistake am I making here?
TIA
Yogi Yang
Sorry folks, I forgot to mention that I am using SQLite3Pages for generating PDF.
TIA
Yogi Yang
I have got around 1000 images in one single folder.
I am trying to get their thumbnails to print like http://s3.postimg.org/dj4witwk3/2015_11_23_213907.jpg
But I am getting only image per line instead of multiple images on the same line.
Here is the main code that I am using for inserting image in PDF
LL := Col * 2500;
Bmp.Assign(ieTemp.Bitmap);
DrawBMP(Bmp,LL,50,FileName)
Col := Col +1;
What mistake am I making here?
TIA
Yogi Yang
Ok thanks.
Thanks,
I have managed to solve my problem.
I had to update the file SynCommons.pas
with these lines:
{$elseif defined(VER250)} 'Delphi XE4'
{$elseif defined(VER260)} 'Delphi XE5'
{$elseif defined(VER270)} 'Delphi XE6'
Hello,
I am trying to use the code in Post #8 in Delphi XE6 and am getting errors like DrawBMP not found.
Am I missing something here?
TIA
Yogi Yang
Hello,
I don't know as to where I should post this so I am posing here. If it is in wrong section please do correct it.
In a software that I have developed now there is a need to automate it using some kind of application programming interface.
I am planning to add DWScript to it but from what little I know about DWScript and have studied it I feel it is more suitable for building Web Apps instead of proving application level programming interface. So I think I will have to modify it to work in my application.
But to be able to modify it I need some kind of documentation which I can study to understand the coding style and know as to where I may have to make modification to get it to work in my application.
I am trying to wrap my head around studying the code but I have not been able make any headway in this direction in last 1 week.
Can someone please help here.
TIA
Yogi Yang
In a project that I am developing I just need to handle three master tables and show the contents of these 3 tables in combo box and base on users selection process a list of photos/images.
Using Mormot for such simple task is like calling service of an "Elephant" to pickup a few "twigs".
Is there any possibilities of using SQLite simply without any over work (from programming point of view)?
TIA
Yogi Yang
Actually I hope to get away with a "stupid" parser that would leverage the full SQL parser of SQLite, something like:
start "parsing" sql when encountering "select"
grab everything up to the end of the statement, noting variable references and expression in passing (maybe prefixed with a '@'), and replace them with parameters
feed the SQL to SQLite, have it prepare the query, report errors
assume sqlite3_column_decltype is meaningful enough to be used for strong typing
Eric,
I don't know but this ready to use SQL parser probably help you. http://jansfreeware.com/jansql.zip
HTH
Yogi Yang
Thanks for your reply.
I will give it a try and if I do run into any problems I will surely contact you.
Regards,
Yogi Yang
I have a legacy app (that was developed by someone before I came to this particular company) that is originally written in VB6.
I want to rewrite it in Delphi using SQLite3 Framework.
But I am having a tough time trying to convert it. The software is very small but the data structure is giving me fits.
It is basically related to Catering industry.
This software will allow a user to create menus for a function order and then based on the menu it will print a list of all the raw material that will be required to cook food items as selected by user as Menu Items.
My question is as to how to convert this whole thing to classes in Delphi?
Is there something which will automatically generate all required classes from existing DB?
Here is the data structure.
-------------
CREATE TABLE [RawMaterialMaster] (
[rm_id] integer NOT NULL PRIMARY KEY,
[rm_name] TEXT);
CREATE TABLE [OrderMaster] (
[OM_id] INTEGER NOT NULL PRIMARY KEY,
[OM_order_date] DATE NOT NULL,
[OM_party_name] TEXT NOT NULL,
[OM_party_address] TEXT NOT NULL,
[OM_party_contect_no] NUMBER,
[OM_hall_name] TEXT,
[OM_hall_address] TEXT,
[OM_function_date] DATE,
[OM_members_morning] NUMBER,
[OM_members_afternoon] NUMBER,
[OM_members_evening] NUMBER,
[OM_price_m] MONEY,
[OM_price_a] MONEY,
[OM_price_e] MONEY,
[OM_notes] MONEY);
CREATE TABLE [RecipeMaster] (
[Recipe_ID] INTEGER NOT NULL PRIMARY KEY,
[Recipe_name] TEXT);
CREATE TABLE [RecipeDetails] (
[RecipeDetails_ID] INTEGER NOT NULL PRIMARY KEY,
[RecipeDetails_recepi_id] INTEGER,
[RecipeDetails_item_id] INTEGER,
[RecipeDetails_wt_kg] INTEGER,
[RecipeDetails_wt_gram] INTEGER);
CREATE TABLE [OrderDetails] (
[OD_id] INTEGER NOT NULL PRIMARY KEY,
[OD_om_id] INTEGER,
[OD_recipe_id] INTEGER,
[OD_menu_for] INTEGER);
There are many third party options available for this but unfortunately most of them are commercial offerings.
I still use SoftLox SME where needed. I still find it effective. But unfortunately executables processed in it do not work under Win7 32/64.
I am currently evaluating Enigma Protector, a software locking tool which seem to be good and it also Obfuscates code so it would not be easily possible for someone to extract data from compiled EXE.
There is a very good Open Source tool called Yoda Protector. Find it on Source Forge. It is a bit dated and is targeted especially for C/C++ coders so may not be that useful for you.
Hope this helps.
I have tried and used Delphi since version 2.
In all versions I have always hated the code editing part of the IDE.
The code editor seems to behave in a non-standard way. When I say non-standard way I mean that the editor's behavior is not as per what an average windows user will expect. Let me give an example to explain this:
Start Delphi's IDE
Open an existing project (so that you do not have to type anything in it to test steps give below)
Open code window if not already open
Click on a line of code
Now select some text/code. To use keyboard for selection keep shift key pressed while pressing Left of Right arrow key
Once something is selected press either Left Arrow Key or Right Arrow Key
If you have made selection to the right of text cursor (insertion point) pressing Left Arrow Key will remove selection but the Text Cursor will not be at the place where selection started but instead it will be one character to the left of the point where selection ended
In the same way if you have made selection to the left of text cursor (insertion point) pressing Right Arrow Key will remove selection but the Text Cursor will not be at the place where selection ended but instead it will be one character to the right of the point where selection ended
Try these steps in Visual Studio 2003 to 2010. The behavior of insertion point is as expected. One will find this behavior in MS Office Apps also.
There are many such annoyances in the code editor. What I have illustrated above is just one of them.
HTH
Pages: 1