unidatetimepicker error when use as an editor in dbgrid.

[devya]

Dear Supports

I have DBgrid connect with FireDac Query to SQL server, one of the field type is Datetime from SQL Server.

And i link Unidatetimepicker as editor for this field inside the UniDBGrid.

But when we edit / insert the data and save the data we facing error  Could not parse SQL TimeStamp string

this how we link the datetime picker

 

Can help me to fix this error ?

I am using Unigui 1.90.0.1547

 

 

[Sherzod]

Hello,

How do you insert data into a database. Are the date formats the same?

[devya]

27 minutes ago, Sherzod said:

Hello,

How do you insert data into a database. Are the date formats the same?

I just use button to do Querry.append;

And i load all the field direct from the FDQuery

I am using DBGrid to edit/insert the data with Row editor

[x11]

2 hours ago, devya said:

Datetime from SQL Server.

Use parameters in SQL-query

Query1.ParamByName('DateTimeField1').AsDateTime := uniDateTime1.Date;

 

[devya]

46 minutes ago, x11 said:

Use parameters in SQL-query

Query1.ParamByName('DateTimeField1').AsDateTime := uniDateTime1.Date;

 

Hi, @x11

Thanks for your advice, but i am edit directly to the query itself. I am not doing parse update query.

All the field are okey, except this datetime field with the unidatetimepicker.

 

[devya]

19 hours ago, Sherzod said:

Hello,

How do you insert data into a database. Are the date formats the same?

Hi @Sherzod,

Any updates for my case ?