Hi Kerwan,
Try this..
?sqlexec(nHandle,"INSERT INTO X (date) values ({d '2005-01-01'})")
?sqlexec(nHandle,'INSERT INTO X (Boolfield) values (0=0)')
MartinJ
>when inserting date or logical value using SQL Passthrough, these generate error:
>?sqlexec(nHandle,'INSERT INTO X (date) values ({01/01/2005})')
>?sqlexec(nHandle,'INSERT INTO X (Boolfield) values (.t.)')
>
>what are the equivalent date representation such as:
>VFP: {01/01/2005}
>MSSQL: '01/01/2005' ?
>FIREBIRD: ?
>or logical 'true' representation such as
>VFP: .t.
>MSSQL: ?
>FIREBIRD:?
>
>?sqlexec(nHandle,'SELECT * from X where boolfied=.t.') &&error
>?sqlexec(nHandle,'SELECT * from X where .f.') &&to just get the structure