Basic SQL statement

[darthy]

I am trying to locate a single record from a table by using the statement



ado.recordsource = SELECT FROM ClientDetails WHERE ClientID =temp



Because ClientID is the primary key (and the variable temp contains the required ClientID number), I would expect the recordset to only return one record - except it doesn't. When searching through the result in debug, it seems to go through every record in the table.

What Am I doing wrong?

[kirankumar]

Is "ado" a datacontrol or what? n where are you assigning the value for variable temp? can you post your piece of code.

[James Stanich]

ado.recordsource = SELECT * FROM ClientDetails WHERE ClientID = '" & temp & "'"

[darthy]

When I use the code mentioned above I get Error - Expected Expression

Ado.RecordSource = SELECT * FROM Client WHERE ClientID = '" & temp & "'""

But when I put extra quotes ie

Ado.RecordSource = "SELECT * FROM Client WHERE ClientID = '" & temp & "'"""

The Expected expression goes away but then I get a Error in FROM Clause

Any Ideas?

[James Stanich]

ado.recordsource = "SELECT * FROM ClientDetails WHERE 
ClientID = '" & temp & "'"

he quote needs to be in front of SELECT

[darthy]

Quote is in front of select NOW (my mistake when entering code inside tags)

But still getting the same error

In debug it is when I use the refresh method when the error occurs. Could that be something to with it.

It comes up with Method refresh of ADO failed


Any ideas?