General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
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