Read data from a Database using a PDA

[TDSquare]

Hi

I want to match the data in a string control in the Front Panel to a row in an Access data. For example, if the types "88002222", then the information that goes with the String will be displayed using indicators.

I don't know if it is better to use a spreadsheet.

Just to clarify things again, I've about 500 of the "88000000" types strings that has other information of that row like Site name, Location, Date and so on. If the user types that String, then the rest of the information should be retrieve from the database.

Any ideas?

Cheers

[tst]

I assume your database is located on a computer and not on the PDA.

I don't know if there is any way for you to directly interact with the DB from the PDA (the PDA module doesn't have any support for ActiveX, which is what most LV DB access tools use), but you can write an application on the PC which will read the data and communicate with your PDA application.

To talk to the DB you can either use NI's DB connectivity toolset or some other implementation which can be found on the web (try searching the LAVA forums).

To communicate between your two applications you will need to create a protocol. Search the example finder for "TCP" or the site for "messaging protocol" to see examples of this.

If you convert the data to a csv file, you can read it directly from your PDA application.