Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL: Statement too long (Error 1812) ????????
I am trying to update my view with following code after editting
do case
case nAnswer = 6
.edit_entry
r1 = cursorsetprop('sendupdates', .t.,'lv_employee')
r3 = tableupdate(.t., .t., 'employee')
lc_eid = .d
requery('lv_employee')
.refresh()
The view is defined as follows:
* employee table view
SELECT Employee.e_id, Employee.e_ssn, Employee.e_fname, Employee.e_lname, Employee.e_mi, Employee.e_inital, Employee.e_sex, Employee.e_div, Employee.e_dept, Employee.e_unit, Employee.e_class, Employee.e_itemno, Employee.e_strcty_dte, Employee.e_strprob_dte, Employee.e_address, Employee.e_city, Employee.e_state, Employee.e_zip, Employee.e_dob,;
Employee.e_lic, Employee.e_lic_class, Employee.e_licexp,;
Employee.e_milectrt, Employee.e_physdte, Employee.e_emg,;
Employee.e_phone, Employee.e_prkper, Employee.e_entryc,;
Employee.e_empstatus, Employee.e_badgeno, Employee.e_budget,;
Employee.e_psycdte, Employee.e_cntysnrdte, Employee.e_relinfo,;
Employee.e_drugdte, Employee.e_degree, Employee.e_rehiredte,;
Employee.e_agdte, Employee.e_termdte, Employee.e_rehire, Employee.e_kcso,;
Employee.e_dmv, Employee.e_bpd, Employee.e_comments, Employee.e_phq,;
Employee.e_employeed, Employee.e_cto, Employee.e_lstrdte,;
Employee.e_lretdte, Employee.e_sickamt, Employee.e_lieu, Employee.e_lwop,;
Employee.e_reason, Employee.e_drstmt, Employee.e_dtestamp,;
Employee.e_flg1;
FROM employee!employee;
WHERE Employee.e_id = ?lc_eid
When I requery in the init procedure to display the results on the screen everything is fine
lparameters b, d && b=secuity level d=employee id
with thisform
.b = b
.d = d
lc_eid = .d
requery('lv_employee')
.refresh()
.allowedit = .f. && .f. = do not allow editing, .t. = allow editting
.edit_entry
.refresh()
endwith
the right record shows up for me to edit. The fields are linked to lv_employee view. After I edit however and then requery, I get the following error
SQL: Statement too Long (error 1812). What is going on here? help appreciated
Nick Patel
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement