Problem with MsSql connected by ODBC and record type DATE
lazarus / 16-Databases

----------------------------------------------------------------------
lublinkermi · 2011-01-09 13:45

Hi, I build aplication using components:
ODBC to connect MS SQL database
DBGRID  to view dataset....

I have a two fields in MsSql -
1 type char - tdbedit
2 type datetime - DBcalendar

If I insert or update tables  I see messages:

Parametr 2 is of DateTime, which not supported yet

How I can insert or update Field Date?

----------------------------------------------------------------------
Lacak2 · 2011-01-10 07:43

Which version of Lacarus/FPC do you use ?
This error is already fixed months ago.
Try upgrade Lazarus/FPC.

----------------------------------------------------------------------
lublinkermi · 2011-01-11 05:35

Hi, I use Lazaurs version 0.9.28.2

----------------------------------------------------------------------
Lacak2 · 2011-01-11 06:51

Try some newest buid from http://www.hu.freepascal.org/lazarus/

----------------------------------------------------------------------
lublinkermi · 2011-01-15 03:46

I try update lazarus, but after this I cannot update any fields
including varchar, which works correctly with older lazarus

----------------------------------------------------------------------
Lacak2 · 2011-01-17 06:30

Some error message ?
Which version of MS SQL ?
Upda]"]>Blockedde of SQLQuery ? (upWhereKeyOnly?)
Is primary key defined on table ?