Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Must specify additional param error 94
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Must specify additional param error 94
Miscellaneous
Thread ID:
00361062
Message ID:
00361062
Views:
71
I am getting error 94 when I use insert sql command. There 80 fields I am trying insert as follows:

do case
case nAnswer = 6
select * from employee where employee.e_id = .d into array a__gen6
If type('a__gen6') # 'U' and type('a__gen6') # 'L' &&if1
insert into archive (ae_id, ae_ssn, ae_fname, ae_lname, ae_mi, ae_inital, ae_sex, ae_div, ae_dept, ae_unit, ae_class, ae_itemno, ae_strcty_dte, ae_strprob_dte, ae_address, ae_city, ae_state, ae_zip, ae_dob, ae_lic, ae_lic_class, ae_licexp, ae_milectrt, ae_physdte, ae_emg, ae_phone, ae_prkper, ae_entryc, ae_empstatus, ae_badgeno, ae_budget, ae_psycdte, ae_cntysnrdte, ae_relinfo, ae_drugdte, ae_degree, ae_rehiredte, ae_agdte, ae_termdte, ae_rehire, ae_kcso, ae_dmv, ae_bpd, ae_comments, ae_phq, ae_employeed, ae_cto, ae_lstrdte, ae_lretdte, ae_sickamt, ae_lieu, ae_lwop, ae_reason, ae_drstmt, ae_dtestamp, ae_flg1, ae_flg2, ae_flg3, ae_flg4, ae_flg5, ae_flg6, ae_flg7, ae_flg8, ae_flg9, ae_flg10, ae_flg11, ae_flg12, ae_flg13, ae_flg14, ae_flg15, ae_flg16, ae_flg17, ae_flg18, ae_flg19, ae_flg20, ae_flg21, ae_flg22, ae_flg23, ae_flg24, ae_flg25, ae_pic) ;
values (a__gen6(1,1), a__gen6(1,2), a__gen6(1,3), a__gen6(1,4), a__gen6(1,5), a__gen6(1,6), a__gen6(1,7), a__gen6(1,8), a__gen6(1,9), a__gen6(1,10), a__gen6(1,11), a__gen6(1,12), a__gen6(1,13), a__gen6(1,14), a__gen6(1,15), a__gen6(1,16), a__gen6(1,17), a__gen6(1,18), a__gen6(1,19), a__gen6(1,20), a__gen6(1,21), a__gen6(1,22), a__gen6(1,23), a__gen6(1,24), a__gen6(1,25), a__gen6(1,26), a__gen6(1,27), a__gen6(1,28), a__gen6(1,29), a__gen6(1,30), a__gen6(1,31), a__gen6(1,32), a__gen6(1,33), a__gen6(1,34), a__gen6(1,35), a__gen6(1,36), a__gen6(1,37), a__gen6(1,38), a__gen6(1,39), a__gen6(1,40),
a__gen6(1,41), a__gen6(1,42), a__gen6(1,43), a__gen6(1,44), a__gen6(1,45), a__gen6(1,46), a__gen6(1,47), a__gen6(1,48), a__gen6(1,49), a__gen6(1,50), a__gen6(1,51), a__gen6(1,52), a__gen6(1,53), a__gen6(1,54), a__gen6(1,55), a__gen6(1,56), a__gen6(1,57), a__gen6(1,58), a__gen6(1,59), a__gen6(1,60), a__gen6(1,61), a__gen6(1,62), a__gen6(1,63), a__gen6(1,64), a__gen6(1,65), a__gen6(1,66), a__gen6(1,67), a__gen6(1,68), a__gen6(1,69), a__gen6(1,70), a__gen6(1,71), a__gen6(1,72), a__gen6(1,73), a__gen6(1,74), a__gen6(1,75), a__gen6(1,76), a__gen6(1,77), a__gen6(1,78), a__gen6(1,79), a__gen6(1,80))
release a__gen6
delete for employee.e_id = .d



Thanks
Nick Patel
Next
Reply
Map
View

Click here to load this message in the networking platform