How to Wrtie Time to Database Using SQLExecute

Hello radoft

Assuming your Time() is a TDateTime how do you get this variable ?

Did you try something like :

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
var
    timeNow : Extended;
begin
    timeNow := Time; //Time is system time and should respect your systems settings regarding the format
    SQLExecute('INSERT INTO TestData(DataDate) VALUES("'+TimeToStr(timeNow)+'")');
end;

If you get the Time variable directly you can even simplify like this:

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
    SQLExecute('INSERT INTO TestData(DataDate) VALUES("'+TimeToStr(Time)+'")');
end;

Let me known if this helps.

Cheers

Mathias

Hello Mathias,
In reality, my project involves various types of data such as Data, Time, Text, and numbers. There is hardware that forms the entire string and I receive the data through the serial port. The string is comma delimited and I get the various fields out of the string. The date and time is not part of the string received in the PC.
I wish to write the received data into a table using SQLExecute. The data and time part of it are just the local date and time on the computer and I would like to write this local date and time into the database for each record. The data is received in close to real real time so that is fine.
I attached an example so I could practice writing various data types into the file but it all went wrong and aren't sure where so I removed most of my SQLExecute and would appreciate it if you could complete that line for me.
In the test project attached, there are boxes to write a text and enter a integer and real number and these should all be written into the data file just one record at a time as the Add button is pressed.
I hope that makes sense.
Also, the SQLExecute lines become quite long so could you tell me the best way to spread a SQL command over multiple lines please.
No pressure at all, I am only progressing as I can and as others are able to help.
Thanks and regards,
David

Hello Math.
Thank you. I have so far dabbled with it but now I am being asked to do so much more so it's essential I start learning this.
I break up the data string with SplitString which seems to work ok. I will look at the file in the morning that you sent.
Thank you for the help.
Regards, David

Hi David,
It's not really a question of 'date' OR 'text'.  'Date' is just a data type, not a storage class (valid storage classes are 'text', 'real', 'integer', 'blob' and 'null'). 
So before your 'date' data type is saved, it first needs to be converted into one of these storage classes - in this case, to 'text', which is why Mathias has to do the conversion.  And the same holds for the 'time' data type.
I hope this helps to clarify it a bit.
Derek.