I'm on a bleeding edge mission here. I have many older FPD apps that get data from Oracle on a nightly basis. We have found that an occasional oracle job(s) are failing, and we are being proactive in doing the same data construction from a SQL Server 2000 Data Warehouse.

Question is :
How do you post .NULL. dates into a FPD type 2.6 dbf where the dates are EMPTY(), {}, ' / / ' ?

I am currently running the Agent to a VFP 6 table / DBC copy of the production 2.6 system. That accepts null. I then scan through and change the 6 date fields on the fly and insert them into the 2.6 version of the table.

Has anyone done this in SQL Server with out an VFP.EXE to clean the data?


I have a very large case statement that I won't post here for bandwidth reasons. Below is the substitution attempts that bomb.

THEN {}
THEN [{}]
THEN ' / / '
THEN {' / / ']
THEN ctod(' / / ')
THEN [ctod(' / / ')]

Any other ideas out there?


__Stephen