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