I have a question regarding updating a view. I have a simple view created
as such. My two problems are the following:
1) I haven't been able to make this view (when used in a form tied to
various objects' controlsource) shareable. It always comes up "EXCLUSIVE".
2) I haven't been able to update the Table linked to the view. Since it is
a single table, this should be straightforward.
Here is my CREATE SQL statement from the "Init" method of the form using
Create SQL View vLABS As ;
Select * ;
From LABS ;
Where LABS.SERVICE >= ?gdSDATE;
And LABS.SERVICE <= ?gdEDATE;
Order By LABS.ID
Use vLABS In 0 Alias vLABS Shared
= CursorSetProp ("SendUpdates", .T., "vLABS") = CursorSetProp ("Buffering",
= CursorSetProp ("KeyFieldList", "TABLEID", "vLABS")
= CursorSetProp ("UpdatableFieldList", "LAST_NAME, MI, FIRST_NAME, ID,
SERVICE, DOB, SEX, RACE", "vLABS")
The two problems occur when the form shows and I'm editing the fields.
Issuing a = TableUpdate (.T., .T., "vLABS") does no good...
Anybody provide any suggestions? I have to break down the original table
(LABS) by a certain date range (LABS.SERVICE) since the table is growing
Mark Pelea -- Manatee County Health Department, MIS