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

ID: Q130507

3.00 WINDOWS kbinterop

The information in this article applies to:

Microsoft Visual FoxPro for Windows, version 3.0

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 reference words: 3.00 VFoxWin ODBC KBCategory: kbinterop KBSubcategory: FxinteropOdbc

Keywords          : FxinteropOdbc 
Version           : 3.00
Platform          : WINDOWS