Microsoft KB Archive/130507

= How To Logical Values Must Be Sent to SQL Server as 1 or 0 =

Article ID: 130507

Article Last Modified on 7/1/2004

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q130507



SUMMARY
When you send logical data to SQL Server via the SQLEXEC function, true (.T.) and false (.F.) values must be sent as 1 and 0.



MORE INFORMATION
The following example shows how to use the Insert command to add a record that has a logical field: nHandle = SQLCONNECT(' ,' ,' ') nSuccess = SQLEXEC(handle,'insert into tablename (logicalfield)     values (1)') This puts a logical true value into the table on SQL Server.

Additional query words: VFoxWin ODBC

Keywords: kbhowto KB130507

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.