var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query cannot be updated because the FROM clause is not a single simple table name.
I have a # temp table and want to insert the record thru vb ado control but fail. pls advise how to use recordset.update to update against # temp table.
Dim ars As New ADODB.Recordset
ars.CursorLocation = adUseServer
ars.Open "#email", <connenction>, adOpenKeyset, adLockOptimistic, adCmdTable
==> the following error msg return
"Query cannot be updated because the FROM clause is not a single simple table name."
I'm new to this forum, but I think i can help.
Can you post your update SQL statement you're using in your code? I believe you may have a JOIN statement in there, and the parser is getting confused on which table it should actually be performing the update on.
it's a visual basic coding to using ADO component & this example is only to read a temp table/#email .. no any other table joining ...
In the SELECT statement that builds the dataset, does the query have any query hints, like NOLOCK, ROWLOCK, etc?
Actually, does your ado object have any locks set at all?
According to MS, ado object use adLockOptimistic as lock mode &
adLockOptimistic => Optimistic LockType