accessing recordset field values using labview Active X

[shridharjosh]

dear friends,
i have opened recordset using labview active X Refenum opening dbengine,workspace ,opendatabase,openrecordset

i need to access the field value from the record
but labview doesnot show any propery or methods that r related to fields ,except count.
in short i am looking for a code statemant in labview which is equivalent to VB
Recordset.Fields("Name").Value or Recordset.Fields(Index).Value

can anybody help
thanks in advance

regards
shridhar joshi

[Ben Schulte]

Hi Shridhar -

LabView is an Active X container, like Visual Basic, and in a similar manner does not dictate what functionality a Control allows users to access - this is not the Container's role in the architecture!!! Whoever created the database Active X control that you are using decided to export methods for accessing a Recordset, it is their design decision how to let the user to do this. All Active X clients will access the same properties and values with the same methods (even in different environments) - this is what makes ActiveX work!!
Can you access this control in another ActiveX container with methods/properties that are not available in LabView? I do not think so. If so, (I am not sure how this would happen), please describe more - I would be interest
ed in what is going on. Is their a supplemental dll or other code module that goes along with the control? These could be interface specific, but I have never seen this arrangment, it defeats the purpose of ActiveX.
Also, what database are you using and where did this control come from? Who makes this control?

good luck-
Ben Schulte
National Instruments

[shridharjosh]

dear Ben Schulte
i am using MS Access Database and i opened
Acitve X class and necessary database connection parameters

thing is Fields is a collection in VB and
has a two default properties 1-Count 2-Index

I am Able to get count property but un succesfull in accessing index this is important inorder to acces the value of a individual field in a recordset
i am attaching data vi with this please ahve a look at it

thanks in advance

[Leo]

try something like this .


"shridharjosh" wrote in message
news:506500000005000000912C0000-991728092000@quiq.com...
> dear Ben Schulte
> i am using MS Access Database and i opened
> Acitve X class and necessary database connection parameters
>
> thing is Fields is a collection in VB and
> has a two default properties 1-Count 2-Index
>
> I am Able to get count property but un succesfull in accessing index
> this is important inorder to acces the value of a individual field in
> a recordset
> i am attaching data vi with this please ahve a look at it
>
> thanks in advance



[Attachment Fields.PDF, see below]

[PeggyC]

Hi Leo,
Can I ask which version of LabView you are using? Because I am also trying to access field value, but under the field property, I have only 'count'. Under method, I have only 'Append', 'Delete', and 'Refresh'. How do you get the 'Item' method?
Thanks.