Greetings,

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 this view:

Create SQL View vLABS As ;
Select * ;
From LABS ;
Where LABS.SERVICE >= ?gdVSDATE;
And LABS.SERVICE <= ?gdVEDATE;
Order By LABS.ID

Use vLABS In 0 Alias vLABS Shared

Select vLABS
= CursorSetProp ("SendUpdates", .T., "vLABS") = CursorSetProp ("Buffering", 5, "vLABS")
= 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...

Can you provide any suggestions. I have to break down the original table (LABS) by a certain date range (LABS.SERVICE) since the table is growing immensely...

Thanks again!

Regards,

Mark Pelea -- Manatee County Health Department, MIS