User Profile
Collapse
-
ok thanks, but what happens when you delete a register? you have to arrange the autonumeric field again? it's very annoying -
Nobody knows how to return a especific row?¿¿?
how to return a especific row whitout specifying fields only by it's position?¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿ -
Using The Select Top ... Offset In Access ?????
ok how can i get the register nº 10 whithout finding in all the registers of the table.?
In mySQL would be: SELECT * FROM mytable LIMIT 1 OFFSET 10
In ORACLE: SELECT * FROM mytable ROWNUM 10
In ACCESS : ........
I can't find by the id because it's not correlative -
ok how can i get the register nº 10 whithout finding in all the registers of the table.?
In mySQL would be: SELECT * FROM mytable LIMIT 1 OFFSET 10
In ORACLE: SELECT * FROM mytable ROWNUM 10
In ACCESS : ........
I can't find by the id because it's not correlativeLeave a comment:
-
I need to get a row of a table by it's position
I need to get a row of a table by it's position i mean the id it's not in order and if i have 30 fields and i want the field number i don't know 13 what it's the sql sentence for that or working in . net thanks. sorry for the english i'm from uruguay
No activity results to display
Show More
Leave a comment: