Knowledge Base

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

Article ID: 130507

Article Last Modified on 7/1/2004

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