Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can a current record counter accessed from a query?
Could you please expand on how the counter=counter + 1 is part of a query or procedure that is executed by the server. SQL code can be passed through a ADO connection where, as shown in the Connector/ODBC manual on the MYSQL web site, like the following code: Private Sub myodbc_ado_Click()... -
How can a current record counter accessed from a query?
I really don't know how to get a specific query(s) to accomplish what we need. I would write something like this: 1. Zero a counter. 2. Open a recordset with the desired fields and the requested sorting. 3. Fetch each record out of the recordset. 4. Increment a Counter. 5. Update the... -
How can a current record counter accessed from a query?
The application is a Server with 100 clients on it collecting measurement data. The clients are running a compiled Acess/VB6 app. w/RDO. The Odbc linked tblMaster consists of SampleDateTime, FileName, OperatorCode, Observation,RefNo. When tblMaster is updated-through any of the 100 clients at...
