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('<data source name>,'<user>,'<password>') 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