two problems when importing MSSQL to filePro

[Richard Hane]

Hopefully, there are others our there who have imported data from MSSQL to filePro odbc.
 
If you remember I posted a couple of the fpodbc processes I wrote to import data from our ERP system (written in MSSQL).  This has now grown to over 15 processes that run each night as a scheduled task.
 
Today I have found a couple of problems that I need help on.
 
1. I do not seem to be able to get a date mm/dd/yyyy to come over.  It leaves the field blank.  Problem may be that the varaible I use is set to 10,mdyy/.  I don't recall the MSSQL date format to try and work around this problem.
 
2. This one is a little harder.  I am importing our Bill of Materials (BOM) file.  No problem with any of the data except in the qty used  field. From what I can see by looking at the raw SQL data, the factors I have a problem with would look like 6.2499999999999 E-2.  If the factor is .0624999999999 with out the E-2 then no problem.  It appears the E-2 means move the decimal left two places.  When you do an odbc import in to Excel the value are correct.  Obviously Excel knows how to handle this.  Do we have anything that can handle this.
 
One other small problem.  When testing a process I sometimes have to run it twice as the first time processing says it can not make the ODBC connection.  Start it again and all is fine.  I see no reason why.
 
Thank you in advance
Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
http://www.deluxestitcher.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130508/b8a850db/attachment.html