Die Holländer

public Constructor Create(aOwner: TComponent; aQty:Integer; aFileName:string; aQuery:String; aTitle:string);reintroduce; end; procedure TStatsGridForm.Create(aOwner:TComponent; aQty:Integer ;aFileName:string; aQuery:String; aTitle:string); begin FsQuery:=aQuery; FiQty:=aQty; FsFileName:=aFileName; FsTitle:=aTitl; Caption := FsTitle + ' - Total records..' + IntToStr(FiQty); JobTickets.SQL.Clear; JobTickets.SQL.Add(FsQuery); JobTickets.Prepare; JobTickets.Open; ... end;

In this situation I would pass the parameters to the onFormCreate procedure. procedure TStatsGridForm.FormCreate(Sender: TObject,..,..,aQuery); begin fQuery:=aQuery .... JobTickets.SQL.Clear; JobTickets.SQL.Add(fQuery); JobTickets.Prepare; JobTickets.Open; ... end;

Always take care to put things in onShow. That can be called more often than you wish, unlike onCreate.

I like this one very much : All comments must be written in haiku format

Yes, must be. Just look how much time it takes on the server a 10+GB file (movie or such) is copying from one directory to another.. Here a few GB database backup costs about 20 seconds.

Instead of COBOL, I highly recommend to GExperts the IBM RPG Programming Language RPG is a high-level programming language for business applications, introduced in 1959 for the IBM 1401. It was one of my first professional programming language before using Delphi and it was a delight to program in columns.

So, if the message is because of a Windows update does that mean Rad studio has always asked for your location without the notification of Windows beforte the update?

Maybe you can read the clipboard with a timer and everytime the clipboard has a new "https://www.youtube.com" string you parse, add (see Remy) and start the video.

Which version of Comment-AI are you using?

No, you can start the implementation.

and now you want to Create Delphi Azure functions with Azure SQL database (Delphi webbroker app) Getting Started with Azure Cloud Development with Delphi But I didn't find the proper solution (configuration..)

Deploy Azure SQL Database for free We access the database with a limit number of users (3-5) and I don't know if this is limited.

I use Azure cloud with MSSQL (free edition), FireDac and works great. I pay about 5 Euro per month. Very nice is it's Database Management Studio.

I always drop a Jedi's JvFormStorage on my form and that's it.. and the position and state..

Is it me or are there others that have problems by highlighting a line of text by clicking LMB and dragging the mouse along that line and at the same time use the scroll wheel to scroll vertically downwards. Somehow my fingers can't handle this process very well. Should I buy another mouse?

Youtube Embarcadero: Best practices and top tips when developing mobile apps.

Which MSSQL database version and driver are you using?

Maybe such is possible..

"Bulk insert" is another term. Maybe you know it...

The Batchmove is mostly used when you have to dump a large dataset into an table once. I think what you want is to sync tables, so when something is changed in the one table there will be the same change in the other table automatically. First you make the tables the same with the data and then the trigger does the rest. The trigger must also work for two databases, especially when they are on the same database server. I'm also not familiar with SQLite but do a Goolge search on like "SQLite INSERT, UPDATE, DELETE trigger two tables" I can DM you an example of a MSSQL trigger that does this if you wish.

Is it not possible in sqlite to create a INSERT, UPDATE, DELETE trigger on the source table to sync it to the destination table?

ah, FMX

Using Windows? You can take a look to it's "Credentialmanager". The Credential data is read/writeable (easy with Delphi) when logged in the machine and encrypted when outside the OS.

Some databases support JSON tables where you can insert JSON strings and query them with normal SQL and is VERY fast. Google for example "MSSQL database JSON" >>Additionally, how can I extract only the needed data from a large JSON response without parsing the entire object? You can exactly do this with the database, because you have to create a kind of mapping to use the SQL and you can map only the fields that you need..