viewing results of query problem

[Darksbane]

Hi,

I am trying to view the results of a query. Some snippets of my code:

SQL = "SELECT * FROM "& ptype &" WHERE pallet_no = 'US337+" & pal &"'

RS = DBconn.Execute(SQL)"

Now when I try to say something like RS.EOF, or RS. anything it gives me the error:

"Object doesn't support this property or method: 'EOF' "

Is there something I am missing?

Any help would be appreciated

Darksbane

[Darksbane]

Figured it out should have had

SET RS = DBconn.Execute(SQL)

[Roy Sinclair]

Did you create RS as a recordset object? If not then it's still just an ordinary variant.

set RS = System.CreateObject("ADODB.Recordset")