to whom it may concern:
I keep getting a error that reads as the following:
Script:PullTracking Sort line:72
import.file=filename3
field types don't match
Heres my script:
'*******************************************************************************************
'****Create file "PullTrackingMod.txt" with only needed lines****
filename3="C:Program FilesA5V4_RuntimePullTrackingPullTrackingMod.txt"
filepntr3=file.create(filename3,FILE_RW_EXCLUSIVE)
FOR i=1 TO m
IF Check_Rec[i]=" S "
filepntr3.write_line(Good_Rec[i])
END IF
NEXT
filepntr3.close()
'*******************************************************************************************
'****Import "PullTrackingMod.txt" into DBF file****
import.type = 0
import.names = "none"
import.file = filename3
import.db = "C:Program FilesA5V4_RuntimePullTrackingPullTracking.dbf"
import.skip_lines = 0
import.skip_bytes = 0
import.field_sep = ""
import.record_sep = ""
import.record_len = 80
import.rem_blanks = .T.
import.text_qualifier = ""
import.fields = 10
import.field1 = "Case Number,c,6,9,0"
import.field2 = "LEA,c,16,3,0"
import.field3 = "Case Type,c,20,2,0"
import.field4 = "Name,c,23,22,0"
import.field5 = "Hearing Type,c,46,3,0"
import.field6 = "SubHearing,c,50,5,0"
import.field7 = "Time,c,56,4,0"
import.field8 = "AmPm,c,61,1,0"
import.field9 = "Room,c,63,3,0"
import.field10 = "Judge,c,67,3,0"
Table.import()
END
Any suggestions? Thanks!
Sincerely,
NATE
I keep getting a error that reads as the following:
Script:PullTracking Sort line:72
import.file=filename3
field types don't match
Heres my script:
'*******************************************************************************************
'****Create file "PullTrackingMod.txt" with only needed lines****
filename3="C:Program FilesA5V4_RuntimePullTrackingPullTrackingMod.txt"
filepntr3=file.create(filename3,FILE_RW_EXCLUSIVE)
FOR i=1 TO m
IF Check_Rec[i]=" S "
filepntr3.write_line(Good_Rec[i])
END IF
NEXT
filepntr3.close()
'*******************************************************************************************
'****Import "PullTrackingMod.txt" into DBF file****
import.type = 0
import.names = "none"
import.file = filename3
import.db = "C:Program FilesA5V4_RuntimePullTrackingPullTracking.dbf"
import.skip_lines = 0
import.skip_bytes = 0
import.field_sep = ""
import.record_sep = ""
import.record_len = 80
import.rem_blanks = .T.
import.text_qualifier = ""
import.fields = 10
import.field1 = "Case Number,c,6,9,0"
import.field2 = "LEA,c,16,3,0"
import.field3 = "Case Type,c,20,2,0"
import.field4 = "Name,c,23,22,0"
import.field5 = "Hearing Type,c,46,3,0"
import.field6 = "SubHearing,c,50,5,0"
import.field7 = "Time,c,56,4,0"
import.field8 = "AmPm,c,61,1,0"
import.field9 = "Room,c,63,3,0"
import.field10 = "Judge,c,67,3,0"
Table.import()
END
Any suggestions? Thanks!
Sincerely,
NATE
Comment