Hi,
I have an custom program that will move data from SQL Server databaseA.tableA to SQL Server databaseB.tableB using SQL Passthrough. That is situation that, some mandatory fields in databaseB.tableB are not exist in databaseA.tableA.

I am trying to define 0 as logical default value (bit in SQL server) of those tableA mandatory fields in sql when retrieve tableA record. However, I faced problem that, VFP converted the the logical field mentioned above to .F./.T. for tableB which cause "operator/operand mismatch" when comparing them.

Any ideas to resolve it without change the major design?

Thank you