Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Can you give me an example, I am not sure how to use it.
>
nConn = SQLCOnnect( 'MyDataBase' )
SQLExec( nConn, [UPDATE MyTable SET MyField = 'NewValue' WHERE ID='1'] )
SQLExec( nConn, [Select @@ROWCOUNT as nCount], 'curResult' )
Wait Window curResult.nCount + " Records Updated!"
***********
something like that, I may have a syntax above wrong.
BOb
>Thanks Chris
>
>
>No... @@ROWCOUNT contains the number of records affected by the last command sent on that connection. You can also use @@ROWCOUNT to see if a record was updated too.
>
>>Bob,
>>
>>So, what your saying is count the number of records prior to the insert, then count them after? Do you know anything about sqlcommit()? At first glance, this looks like it is what I need.
>>
>>Thanks, Chris
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement