Sergey,
I fixed the problem with respect to the error message I was getting but I'm still having trouble getting the view to update properly. The code below defines how the view is setup. The trouble is incidentsview.employeeid does not want to update to the base table even though it's setup to be. The other fields are setup the same way and update just fine.
I'm using optimistic row buffering although I want to use pessimistic table buffering. Pessimistic buffering causes an error. Why?
After the incidentsview created I get the following error in the view designer: 'query parse error - try rebuilding in query wizard or by using view designer join tab'. The view seems to run fine but why does this error popup?
create sql view incidentsview ;
as select incidents.*, ;
employees.claimantfirstname, employees.claimantmiddleinitial, employees.claimantlastname, ;
jobtitles.jobtitle, injuryclassifications.classification, ;
injuryparts.part, injurypositions.position ;
from data1!incidents ;
left outer join data1!employees ;
on incidents.employeeid = employees.employeeid ;
left outer join data1!jobtitles ;
on incidents.jobtitleid = jobtitles.jobtitleid ;
left outer join data1!injuryclassifications ;
on incidents.classificationid = injuryclassifications.classificationid ;
left outer join data1!injuryparts ;
on incidents.partid = injuryparts.partid ;
left outer join data1!injurypositions ;
on incidents.positionid = injurypositions.positionid
dbsetprop('incidentsview','view','tables','data1!incidents')
dbsetprop('incidentsview.incidentid', 'field', 'keyfield', .t.)
dbsetprop('incidentsview.incidentid', 'field', 'updatable', .t.)
dbsetprop('incidentsview.employeeid', 'field', 'updatable', .t.)
dbsetprop('incidentsview.jobtitleid', 'field', 'updatable', .t.)
dbsetprop('incidentsview.partid', 'field', 'updatable', .t.)
dbsetprop('incidentsview.positionid', 'field', 'updatable', .t.)
dbsetprop('incidentsview.medicalid', 'field', 'updatable', .t.)
dbsetprop('incidentsview', 'view', 'wheretype', 3)
dbsetprop('incidentsview', 'view', 'sendupdates', .t.)
Thanks for your help!
Previous
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