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

The information in this article applies to:

Microsoft Visual FoxPro for Windows 3.0
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.

Modification Type:	Minor	Last Reviewed:	7/1/2004
Keywords:	kbhowto KB130507