Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL PT problem - can't update #TempTable
Message
De
08/05/2006 07:21:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SQL PT problem - can't update #TempTable
Divers
Thread ID:
01119994
Message ID:
01119994
Vues:
63
* 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)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform