Reading 1 Full Record All Fields From MS Access

[DL84]

Hi All -

We bought the DB connectivity toolset awhile back, and I've pretty well gotten the Write functions down.  I'm working on an application now that has to read 1 full record - and send 1 cluster of all those fields values back into my main VI.

Looking at the examples in the manual they show how to load ALL the data from an entire database into a 2D array into your application, and specific data (1 record, 1 field) output.  The first condition isn't viable, the DB is too big.  And the second is a problem because there are a LOT of fields.  I'd say about 80 fields defining upper and lower limits.  This is probably bad db design, but thats out of my hands.

I could use that second example, and just use a For loop incrementing the field to collect it all but that seems a bit too much.  Has anyone had luck with a simple subvi where you submit a string - it searches 1 column, finds the string, then returns all of the field values?

[Deepu]

Hi

I am not sure if this will be helpful, but let me show you what I am doing whenever using the access database.

I am using the tools from http://jeffreytravis.com/lost/

With this you can use the sql query such as:

select * from <table name> where <field name> = '<value>';

It will return all the fields of the records which matches the data as in value.

Hope it helps...

Regards