How to find out rowid in Ms-access.

[challa.shankar6]

Hi,

I want to know, how to find out the rowid in one table. Suppose i write as

SELECT EMP_NO, EMP_NAME, ROWID FROM EMP

Then it is giving error as:

SELECT EMP_NO, EMP_NAME, ROWID FROM EMP
^
Error: ACCESS:-3010[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

How to find out rowid in Ms-access.

Thank u..!

Ravi

 

[Uncle Gizmo]

Is "ROWID" a field in your table or is it a variable that you have supplied?

 

[challa.shankar6]

Is "ROWID" a field in your table or is it a variable that you have supplied?

It is not a field or variable. If i enter the duplicate in one table, then i want to delete one row from that duplicate. Then we can use ROWID in Oracle to delete that row. Just like that i want to know in access also.

 

[Uncle Gizmo]

ROWID Isn't valid in MS Access you will have to find some other way of doing it.

 

[challa.shankar6]

ROWID Isn't valid in MS Access you will have to find some other way of doing it.

Ok, Thank u for u r reply.

 

[The_Doc_Man]

All SQL has this same problem whether ORACLE or Access or anyone else.

RowID is a fiction that depends on the order of the sort that governs your returned data. If you define your integrity constraints, you would not have been able to create the duplicates in the first place. If you cannot define integrity constraints in your situation then your database doesn't support your own requirements and is therefore not properly designed.