General information
Title:
Inserting date into sql or firebird;What is .t. value in SQL
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only