cancel
Showing results for 
Search instead for 
Did you mean: 

database

Soundarya
Member

database

hi,

 

How can i compare the fields in ms-access table with the fornt panel control values.

 

InAdvance Thanks

 

Regards

Soundarya

8 REPLIES 8
MikeS81
Proven Zealot

Re: database

Hi Soundarya,

can you explain a bit more please? Why do you need it? You can use a SELECT query to get all rows with specified values, no need to compare something.

 

Mike

CtheR
Member

Re: database

Message contains a hyperlink

You can find a dll that may help here:

http://zone.ni.com/devzone/cda/epd/p/id/3409

 

Greets Christian Riedel

Soundarya
Member

Re: database

hi,

 

i have some values in the database as: uname=ate and password=ate.

 

and i have two string controls in the front panel.

 

so i want to compare the fields in the database such as uname and password with the string controls in the front panel.

 

how can i do this?

 

InAdvance Thanks

 

Regards

Soundarya

muks
Proven Zealot

Re: database

Message contains a hyperlink
MikeS81
Proven Zealot

Re: database

Hi Soundarya,

as mentioned before, you can use a SELECT query.

SELECT password FROM yourtablename WHERE uname='ate'

It's only an example, you should change the "ate" with the value from your control. The result contains the password which you can compare with the value from the other control.

 

Mike

Soundarya
Member

Re: database

hi,

 

how can i know whether a particular record in the database(ms-access) exists or not?

 

InAdvance Thanks

 

Regards

Soundarya

Soundarya
Member

Re: database

hi,

 

how can i know whether a particular record in the database(ms-access) exists or not?

 

InAdvance Thanks

 

Regards

Soundarya

Dennis_Knutson
Knight of NI

Re: database

If your query does not return any results. Smiley Very Happy