movenext in labSQL

[netee]

Hi,

I'm using LabSql to connect to a Ms Access database. I successful created the database and i was able to connect to the database. i was able to insert, delete and select from the database. My problem is i want to be able to move to the next data in my database using the movenext in my recordset functions. This is how i tried it below but it gives me errors. how do i go about this? 

Thanks! 

[Deepu]

Let me tell you frankly that I did not use LabSQL before so I am not sure what ever functions you have there.

However, if you have a function to move to the first, try that and then a move next. Also before the move next see if there is any function to check if it the EOF or something similar ? Do a move next only if it is not EOF (may be it is called by another name).

Actually what is the error that you are getting. Some body here might be familiar with these and be able to help you if you could provide the actual error that you are getting.

Regards,

Deepu.

[netee]

Hi,

Thank you for your reply. I tried to substitute the movenext recordset function above with the movefirst recordset function and i got the error shown below.

[Deepu]

You captured the error and that was helpful.

Look at the error. The problem is with the Recordset Opening. I guess you have missed out some command string input for that vi. Check it out.

Another thing that I want to suggest, when you download the LabSQL, did you get an example named "One Record at a Time.vi". Check it out, that might be useful. In that example, there are no Recordset Open, Create or Close vi used.

The Reference is same as ADO Conenction Open vi's out put.

Hope this helps !