data base

[elyan]

Hi all : Issue is data base  Please attach see file , copy this file to desktop ,, then run create table  vi ,,, as you see its will save the data in access . Please see  I took the this example from national instrument example directory C:\Program Files\National Instruments\LabVIEW 8.5\examples\database  but I add some objects My problems are : 1-       Every one can insert to epos.mdb and do changes 2-       I want if I insert same number in  column 1 , massage appeared that say this number is in data base , and don't saved it , if this number doesn't exist then application will saved it   How can I do that?  thanks       

[jjcimon]

first you find the value in table colum 1

and you put a condition if norecord found   connect to a case T/F

and if tru save the record and if not  message box..... 

[elyan]

I know the concept ,, but how can i found the value , i need appliaction to run on all colunm 1 , how can i do that

[jjcimon]

are you familiar with sql or database query and table etc...

where did you get the database exemple, they should refer to a reference  

[elyan]

if you have labview 8.5 installed , see C:\Program Files\National Instruments\LabVIEW 8.5\examples\database

[jjcimon]

the exemple just cover the creation of a table, but not the insert record.

I do not have the database add on but I am using a database not connected yet to Labview.

To answer your question you should first use create table with the database app(like access: simpler)

                next find the function vi to (findRecord(like query)  and Numberof record  and insert record.