Discussion Locked

Serial Number generation vb6 datareport

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to get the serial number along with the query I use in the datareport. I do not store the serial number in any of my tables. The serial number should be a generated field used in the dataenvironment1, command1, sql option. The serial numbershould be listed for every record displayed in the detailed section of the data report.

1 reply

by jasrai

Here is your solution:

SELECT st.*, (select count(*) from tblSomeTable where someID<=st.someID)
FROM tblSomeTable st

This discussion is closed to new replies.