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!
Précédent
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