Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL PT problem - can't update #TempTable
Message
From
08/05/2006 07:21:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL PT problem - can't update #TempTable
Miscellaneous
Thread ID:
01119994
Message ID:
01119994
Views:
65
* cSql is defined as a "Select .... from SomeTable ...Join... into #TempTable"
* the selection works ok, buffering is 5

nSql = SQLConnect('FleetSystem')       && 1

? SQLExec(nSql,cSql)                   && 1

? SQLExec(nSql,[Select * From #TempTable],'Test')    && 1

Delete                                 && That's all the users can do here                             

? CursorSetProp("Tables",'#TempTable') && .T.

? CursorSetProp('SendUpdates',.T.,'Sqlresult')  && .T.

? CursorGetProp("Tables")              && #TempTable

? TableUpdate(.t.,.t.)                 && .F.

? AError(errors)                       && No update tables are specified. Use the Tables property of the cursor.
TIA & BR
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Next
Reply
Map
View

Click here to load this message in the networking platform