Jump to content

labview & ms access


Recommended Posts

Hi,

I've connect my access database with labview by uising the activeX connection (DAOEngine)

This work correctly,but now i need create a sql select...innerjoin query between two table of my DB.

I see the problem is the count byte property of recordset, get one record (reality is more records).

The attached ExtractTable is in LV6.1 :headbang:

Thanks for HelpMe

Bytelab

Download File:post-395-1094465031.llb

Link to comment
  • 1 month later...
Hi,

I've connect my access database with labview by uising the activeX connection (DAOEngine)

This work correctly,but now i need create a sql select...innerjoin query between two table of my DB.

I see the problem is the count byte property of recordset, get one record (reality is more records).

The attached ExtractTable is in LV6.1 :headbang:

Thanks for HelpMe

Bytelab

1654[/snapback]

To get the record count or any count using ADO in combination with a recordset you need to have exclusive access rights to the recordset. Try opening your recordset using "lock optimistic" functionality.

Also have a look at a new database toolkit at www.tm-solutions.nl\eng\

Greetz

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.