General information
Category:
Coding, syntax & commands
Title:
Must specify additional param error 94
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only