database

[Soundarya]

hi,

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

InAdvance Thanks

Regards

Soundarya

[MikeS81]

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]

You can find a dll that may help here:

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

Greets Christian Riedel

[Soundarya]

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]

Another link with same message

[MikeS81]

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]

hi,

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

InAdvance Thanks

Regards

Soundarya

[Soundarya]

hi,

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

InAdvance Thanks

Regards

Soundarya

[Dennis_Knutson]

If your query does not return any results.