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