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:42:50
John Baird
Coatesville, Pennsylvanie, États-Unis
 
 
À
08/05/2006 07:21:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01119994
Message ID:
01119998
Vues:
23
This message has been marked as a message which has helped to the initial question of the thread.
Don't you need to specify the updatefieldlist?




>
>* 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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform