#1 Re: mORMot 1 » Use SQLite for FireMonkey applications targeted for Windows and Linux » 2021-08-09 11:00:58

!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

#2 mORMot 1 » Use SQLite for FireMonkey applications targeted for Windows and Linux » 2021-08-09 07:05:32

yogiyang
Replies: 3

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

#3 Re: mORMot 1 » Reverse engineer existing database » 2019-03-16 12:17:31

Hello,

Thanks for the tip. I will give it a close look.

#4 mORMot 1 » Reverse engineer existing database » 2019-03-13 07:20:33

yogiyang
Replies: 2

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

#5 Re: PDF Engine » How to align text in columns with SynPdf » 2015-11-28 07:56:25

I am also a newbie with this but from what I have experimented I think this functionality is still not implemented.

#6 Re: mORMot 1 » Using SQLite3Pages as a stand-alone report maker » 2015-11-24 14:32:13

ab wrote:

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

#7 Re: mORMot 1 » Using SQLite3Pages as a stand-alone report maker » 2015-11-24 04:27:13

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

#8 Re: PDF Engine » How to render many images in provided sample format » 2015-11-23 16:31:45

Sorry folks, I forgot to mention that I am using SQLite3Pages for generating PDF.

TIA

Yogi Yang

#9 PDF Engine » How to render many images in provided sample format » 2015-11-23 16:15:18

yogiyang
Replies: 1

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

#11 Re: mORMot 1 » Using SQLite3Pages as a stand-alone report maker » 2015-11-20 13:49:46

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'

#12 Re: mORMot 1 » Using SQLite3Pages as a stand-alone report maker » 2015-11-20 12:18:37

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

#13 Language » Documentation explaining the coding style used in DWScript » 2015-09-21 05:16:31

yogiyang
Replies: 1

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

#14 mORMot 1 » Embed SQLite only without other overheads » 2015-04-21 05:43:15

yogiyang
Replies: 1

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

#15 Re: mORMot 1 » HTTP Server / DWScript » 2012-12-21 06:56:19

Eric wrote:

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

#16 Re: mORMot 1 » How would it be possible to manage such a structure of DB » 2010-10-01 05:12:21

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

#17 mORMot 1 » How would it be possible to manage such a structure of DB » 2010-09-30 13:44:13

yogiyang
Replies: 2

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. sad

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);

#18 Re: Delphi » Delphi Application Protection » 2010-08-24 10:35:38

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. sad

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.

#19 Delphi » I hate Delphi IDE's Code Editor » 2010-08-18 13:05:44

yogiyang
Replies: 2

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

Board footer

Powered by FluxBB