Implementing a data base

[tmaxial]

Hi.

I want to implement with CVI a personal data base (name, ocupation... anything).
First of all I have to visualize this data base and than to access any data from it.

What can you tell me about this subject?
Wich are my best choses?
Can I use a specialized program for data bases (ODBC) like mysql to work with CVI?

Thanks.

[RobertoBozzolo]

It depends on wether you need to interface with an exsisting database or not. NI distributes a sql toolkit for CVI with wich you can connect and use several type of popular databases: I have used it to work with Acces databases and it works good, but I don't know if mysql is implemented in the toolkit.

If you don't have to connect and use an exsisting database and/or interface with other applications, you could even consider developing your own application for it:
. define a structure with all the fields you need. Consider having extra space allocated for adding new fields in the future without need to convert the file
. allocate an array in memory with the elements you need
. sort the array with qsort and perform searches with BinSearch functions
. display using a table control
. write/read to a file with fread/fwrite
For relatively small files (say less than 1000 records) it could perform well and it can be customised to your needs.

[Wendy L]

Hello Tmaxial,

The LabWindows/CVI SQL Toolkit:
• Works with any provider that adheres to the ADO standard.
• Works with any database driver that complies with Open Database Connectivity
(ODBC).


In particular, you can use mySQL with CVI. In particular, the following document describes how to do this:
http://digital.ni.com/public.nsf/websearch/6257BDDBE5DC9BE886256D3A005697E3?OpenDocument

Also, you can obtain the SQL toolkit for LabWindows/CVI from www.ni.com. Here is a link to the SQL toolkit reference manual, if you decide to get it, or already have it.
http://digital.ni.com/manuals.nsf/websearch/D3DF4019471D3A9386256B3C006CDC78?OpenDocument&node=132100_US


Thanks.