kyle Posted March 26, 2002 Posted March 26, 2002 hi, i need a help with import script. let's say i have file A and file B , file A - got name , qty repeat of 3 field. file B - got name & qty field no repeat in file B , i made a import script in file B. IMPORT [ RESTORE, NO DIALOG, FILEA.FP5 ] HOW IMPORT WORK ? 1 record of file A , will produce maximum 3 records in file B. because file A's qty field got 3 repetition. if all 3 repetition field is filled , it will import each repetiton qty as one record in file B. so it will be 3 records in file B. the problem --- let's say i'm importing first record of file A with 3 repetiton qty field and let's say there are 4 records in file A. < importing option was update matching records & add remain records. > the thing is that when i import first time , it show all 3 records in file B. but from second time around , it clears the last record which was imported previously. for example, there are 3 records 1,2,3 from previous import. now i want to import another record of file A. so i import. then i have 6 records. 1,2,3,4,5,6. but record 3's field text is cleared [ no datas in it ]. so i did another import , now it happens in record 6. which i noticed it happes to the last record of each import. so now i have record 3,6's name field empty. and this happens everytime i import with same sequence. is this a known problem ? is there any way to avoid this problem ? TIA .. KYLE [ March 26, 2002, 01:40 PM: Message edited by: kyle ]
kyle Posted March 27, 2002 Author Posted March 27, 2002 nevermind you guys . i solved the problem. a little stupid mistake cost me 5 hours. gee... thanks, kyle
Recommended Posts
This topic is 8279 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now