Hello radsoft,
A quick and "dirty" modification of your project just to give you something. I'll try to improve that tonight.
Query is written on multiple lines to show you how to spread it over multiple lines (beware of spaces between some instructions : if you forget them, the query will fail).
Also, I changed the Date format of your date field to text : the date format was not showing up in the dbgrid even with data in database. I will investigate tonight too.
Last thing : you talk about a comma separated list you receive through COM port right ?
Do you know how to handle those strings and turn them into "smaller bits" to save them in database ? Have you ever used StringLists ?
Anyway, back to work now
Cheers
Math
Post's attachments SQLInsert.zip 335.15 kb, 428 downloads since 2018-01-18
I'm a very good housekeeper !
Each time I get a divorce, I keep the house
Zaza Gabor