J
I am using SQL V6.5. My v.b. script failed and caused identical records to be inserted into a table, however other code requires that there only be one record in the table. I have since solved the problem by modifying the table and attached a random id field so that each time the insert is done there is something unique in each record. Is there a system/internal variable in SQL that would allow me to distinguish between identical records? Say you have 3 rows of data in a table, how in version 6.5 do you only look at the second or any row in the middle (not first or last)? I know with version 7.0 you can look at specific rows..but I have not yet located info to do this in v6.5
Thanks in advance.
J.B.
Thanks in advance.
J.B.