Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBCs SQLRowCount() - How to use?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00810276
Message ID:
00810328
Vues:
31
This message has been marked as a message which has helped to the initial question of the thread.
SQLRowCount is ODBC API function. It returns the number of rows affected by an UPDATE, INSERT, or DELETE statement.

It is declared as
SQLRETURN SQLRowCount(
     SQLHSTMT     StatementHandle,
     SQLINTEGER *     RowCountPtr);
FoxPro declaration
DECLARE SHORT SQLRowCount IN odbc32;
	INTEGER   StatementHandle,;
	INTEGER @ RowCountPtr
MSDN link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch21jpr_2.asp

Before using this particular function you have to use many other ODBC API function to connect, create statement handle etc.

In most imaginable situations native _TALLY is good enough. I hardly can find a reason of using the SQLRowCount.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform