Import Records -
01-26-2007
, 03:40 PM
I have a small collection of records that I imported from an Excel
spreadsheet using FM8.5. Each record contains an Order Number which I
then run another Import Records using and ODBC connection to pull more
detailed information about the specific Order from the the external DB.
My issue arises when I noticed a behavior of Import Reocrds I did not
foresee. Lets say I have 7 records that I loop through and using the
Order Number from each of those records to pull a single row of data
from the DB. It grabs everything accordingly but places all the files
on the first record. Import Records doesn't seem to care which record
I am currently on. I know it is cycling through my records correctly
because my first record always has my last record's order number's
information.
Any help would be greatly appreciated. |