>When I used DST to upsize my FoxPro database to SQL Server, logical fields were changed to binary. Since FoxPro logicals have .t./.f. states and SQL binaries are 1/0, is it possible to write common query code and just change out the cursorAdapter or does every query have to check which source it is querying and produce two select statements?
You do not really need 2 SELECT statements. However, you need to handle the updates manually with the CA. That is provide your own UPDATE, INSERT commands in the CA for VFP to use when sending data back the the DB. There you will have to check if the data is native or SQL.
The best plan is not to use logicals in VFP. Use a N(1) field and only accept values of 0 or 1 just like a SQL DB. That way, upsizing any future apps is much easier and seemless.
Mark McCasland
Midlothian, TX USA