In using Flex2SQL for record transfer, it stops without any apparent errors before completion. The problem was due to the DATE_ACQ field, more specifically the value of a leap year (for example, 2-29-1900). DataFlex does not care about leap years, but other databases do. The problem is solved by modifying the errant dates.
Archive for the ‘Flex2SQL’ Category
Flex2SQL Conversion Stops
Tuesday, February 19th, 2008Calling a Stored Procedure Passing and Receiving a Date
Monday, February 18th, 2008The DataFlex date format isn’t compatible with MS SQL. You must to change the way as argument is passed and/or is received.
Take a look at this sample program. You may see that the variable is declared as a string, but should be date. I’m changing the date format before call stored procedure: