Auto Increment field -- What TYPE?

[oraclec]

Hi,

My SQL query from an ASP page:

query = "UPDATE Loan SET DateOut = '"&Date&"', TimeOut = '"&Time&"', CheckedOut = Yes WHERE LID = '"&lid&"'"

resulted in a data type mismatch error.

My column LID is an auto increment field. I set it to be the primary key.

What is the data type of an auto increment field? I tried casting lid with CInt instead of a string, but had the same error.

Can anyone help?

Thanks!

|*Oraclec*|

"Information is not knowledge, not can it grant wisdom or be put to use until it is properly applied."

 

[DrSimon]

Assuming you mean an 'Autonumber' field: they can be Long Integer or Replication ID. Help explains the difference if you don;t know.
Simon Rouse