Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL: Statement too long (Error 1812) ????????
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL: Statement too long (Error 1812) ????????
Miscellaneous
Thread ID:
00357536
Message ID:
00357536
Views:
77
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
Map
View

Click here to load this message in the networking platform