I am fairly new so please excuse any mistakes I make in posting my question.
Our company runs a debt collection software that has a foxpro 6 backend.
We run a telephone dialer that I am trying to report multiple contact attempts into the data base. Her is how I do it if I want to import one line of data:
Destination table = coldbtr Destination Memo Field = dbtrref Record ID = dbtrno
Import dbf = data ( there are 5 fields included the first being my unique id field which = dbtrno I will refer to them as 1, 2, 3, 4, 5 (1 being the record id))
- use data
- index on 1 to data
- select 0
- use coldbtr
- set relation to dbtrno into data
- set filter to data.1 = dbtrno
- replace all dbtrref with "DIALER RESULTS:"+chr(13)+data.2+" "+data.3+" "+data.4+" "+data.5+chr(13)+dbtrref
This gives me the results I need for one line of imported data. The problem I have is I don't know how to set it up to import multiple entries from one data file into my data base.
For example record # 999 in coldbtr has 5 entries from data. The way I am doing it above only imports the first line of data.
Thank you in advance for any and all help you can offer.