How to see my sql in recorset?

  • Thread starter Thread starter hanski
  • Start date Start date
H

hanski

Hi

I have this kind of recorset:

Dim PUTKI As New ADODB.Connection
Dim maksi As New ADODB.Recordset

Set PUTKI = CurrentProject.Connection

maksi.Open "Select max(field1) from Database", PUTKI, adOpenDynamic,
adLockOptimistic



How can I see the result of maksi? I want to know is it correct!!


Hannu
 
hanski wrote in message
Hi

I have this kind of recorset:

Dim PUTKI As New ADODB.Connection
Dim maksi As New ADODB.Recordset

Set PUTKI = CurrentProject.Connection

maksi.Open "Select max(field1) from Database", PUTKI, adOpenDynamic,
adLockOptimistic



How can I see the result of maksi? I want to know is it correct!!


Hannu
Click to expand...

For debugging purposes (for any recordset), try

debug.print maksi.getstring

Then check it out in the immediate pane (ctrl+g)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format problem in recordset 3
Why my recordset is not working? 2
How can I find the count of fields in vba? 1
How VBA accepts "true" in recordset? 1
How do I tell to recordset that I want all True-fields? 6
value to textbox 1
update 1
Runtime Error 3001 Arguments Are Of The Wrong Type, Are Out Of TheAcceptable Range, or are in confli 4

Back
Top