How do I use Access in Lookout

[michael@lendell.com]

I am trying to store either 'changed' data or 'polled' data into an Access DB.. I cannot figure out how to do either.

I have the correct statement and have been able to use SQLExec.Execute to poll data manually, but I cannot figure out the relationship to it and a Pulse timer.

Nor can I see how I can .Execute on change..

Thanks!

[Khalid]

Hello Michael,

I am assuming you have already taken a look at the following KB article on using SQLExec object to insert data into Access:

http://digital.ni.com/public.nsf/3efedde4322fef19862567740067f3cc/4adeea04cd24ae0b862565e20002a16f?OpenDocument

To do this periodically, you will connect a Timer to the .execute datamember. First create a Pulse timer object. Then go to Edit Connections from the Object menu. Select your SQLExec object. And make the connection to the .execute member as follows:

Sql1.Execute = Timer1

To execute on change, basically you will have to come up with some logic where you end up with a logical high (trigger) when the data you're interested in has changed. You would use this logical high (instead of the Puls
e timer) to execute the SQLExec.Execute.

Hope this helps.

Regards,

Khalid