I am using VFPODBC.exe to try to get ready for an anticipated move to SQL server. I have my VFP database and tables, and have set up a separate VFP database with views to access that original database.
My problem is this: part of the app is to take data created by our FPW 2.6 app out in the field and import it to the aggregate table. I am using APPEND FROM and then TABLEUPDATE. The TABLEUPDATE fails, with an ODBC error telling me that there are incompatible data formats or somthing like that. I have found that the ODBC view rejects empty date fields - if I scatter that record to memvars and change the empty date to .null., I can do it (the original table allows nulls in that field). So, my original approach
use udc_odbc!annualv
append from xfer\xama0020
=tableupdate(.t.,.f.,'AnnualV'
fails, and
scatter memvar
insert into AnnualV from memvar
=TableUpdate(.f.,.f.,'AnnualV')
fails, but
scatter memvar
m.intc_dt = .null.
insert into AnnualV from memvar
=TableUpdate(.f.,.f.,'AnnualV')
works.
Anyone seen this, is there a solution, or do I need to go the long way around the horn and scatter, fix and insert each record?
TIA.