Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement