ADODB recordset not opening!!!!!

[MaximusArcher]

using the below:

SQL = "SELECT * FROM Criteria_Scheme CS WHERE CS.Value<>0 And CS.Position<>0"

.ActiveConnection = p_CurrDBConn
.CursorType = adOpenKeyset
.Open SQL, p_CurrDBConn

getting Method 'Open' of object '_recordset' failed.

However if I paste the sql into a query and run it returns a record fine.

Any ideas? Have I supplied enough info?

Cheers,
Matt.

 

[MaximusArcher]

Never mind - have found it out.

Was using SQL-92 reserved word in sql string.

compiling the sql as...

SQL = "SELECT * FROM Criteria_Scheme CS WHERE CS.[Value]<>0 And CS.[Position]<>0"

...works just fine.