Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBCs SQLRowCount() - How to use?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00810276
Message ID:
00810328
Views:
30
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform