07-15-2010 07:57 AM
Hi Ladies and Gentleman,
I've been playing around using Labview 2009 and ADO objects for a upcoming project I will be working on. I have a test database set up to where I want to add records to my test database, just to see how the flow works. I have successfully referenced the database and opened the recordset, but when I get to the AddNew Method, I'm stuck. I'm not sure what to wire to the FieldList or Values sections.
I've read the ADO 2.5 documentation, but I'm still lost.
Any info is greatly appreciated.
07-15-2010 08:16 AM
Hi DadAzzS10
I don't know if this is the same definition you have in the ADO 2.5 documentation, but I find this pretty clear. Please post back if anything is still unclear.
Best Regards
David
NISW
07-15-2010 08:33 AM
Whenever I have an ADO related issue, I start at devguru.com
See this link:
http://www.devguru.com/technologies/ado/quickref/ado_index.html
07-15-2010 01:54 PM
Phillip,
Thanks for the link, I'll have to save that site.
I'm thinking that a string array is the best way to go, since I have two columns with two values, but when I set up my 1D array for each array, I can't enter any information. It appers grayed out.
07-15-2010 02:57 PM - edited 07-15-2010 02:59 PM
OK, got a little farther, but I still can't understand why I'm getting a error. It looks correct to me.
Error: -2146825023 - Item cannot be found in the collection corresponding to the requested name or ordinal.
07-15-2010 04:09 PM
If you do not want to use the NI Database Connectivity Toolkit (ADO based) I would suggest you look at the free LabSQL (also ADO based). It sounds like you might be trying to reinvent the wheel.
07-16-2010 01:33 AM
Hi again
It's like Dennis says, using the toolkit would save you a lot of time and effort. It's the route I would recommend.
The error you are getting is documented in this KB.
Best Regards
David