Mark,
Your first problem is easy to solve. There's no need to open a view shared. The view is created on each user's computer dynamically. Just because you have a view opened exclusively doesn't mean someone else can't open the same view.
I'm not sure what the second problem is. You may want to see if TABLEUPDATE() returns .F. If so, use AERROR() to see what error is returned. Double-check your key field list to make sure it's the primary key of the underlying table.
>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