General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I'm using ADODB recordsets with "oRs.AddNew()" syntax. It won't accept anything I'd normally use as a logical value. As long as the field list and value lists have no logicals, everything works properly.
I get an OLE Dispatch exception Code 0 from MS OLEDB Provider for ODBC drivers. Multple step.... etc.
>If you're talking about SPT, than 0/1 should work. Can you provide more details?
>
>>Ok, I give up. How do I send a logical VFP value to a MSSql 2005 bit field.
>>
>>.T. and .F. don't work, 1 and 0 don't work, and even though SQL Server says it will take the string values of 'True' and 'False' (and it will in Management Studio), they don't work from VFP either.
Previous
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