search function VI

[labviewproject]

Thanks for the sql statement. do you have a simple vi for me to try out the sql statement or can i just use my vi? 

[Dennis_Knutson]

I don't use the toolkit but I would recomend testing the statement with the execute query function.

[smercurio_fc]

You can try just changing the string that you send to the "Select Data" VI, though I think Dennis is right in testing it first.

Message Edited by smercurio_fc on 07-14-2009 10:24 AM

[labviewproject]

Thanks for the reply. I will try it immediately tomorrow when i get to school.

[labviewproject]

Does anyone know what should be connected to the output of the execute query vi(recordset reference)?

[labviewproject]

i found the way to connect the vi here. thanks.

http://forums.ni.com/ni/board/message?board.id=170&message.id=111832&query.id=982467#M111832

[labviewproject]

sorry again. I've remodify my vi but after i run it, no data is displayed in the front panel. is it due to my sql statement or is it some other problem? My database relationship is below too. Many Thanks.

[IMG]http://i93.photobucket.com/albums/l65/vittoire/NewPicture1-1.jpg[/IMG]

[IMG]http://i93.photobucket.com/albums/l65/vittoire/NewPicture3.jpg[/IMG]

[Dennis_Knutson]

'WHERE OVID LIKE'? I thought you wanted to search for unit number. OVID is a key.

Also, please don't link to third-party image hosting sites. Just attach them or click on the 'Upload or Insert an Image' button.

[labviewproject]

sorry i didn't know that i could upload the image here. I have many different tab in the final part in my search functions which can allow user to choose what they want to search. the usercan choose to search by ovid, unit number, or mayb firstname. so now im trying out to see whether i can search by the unit number.

[smercurio_fc]

You can search by whatever you want, as long as the columns exist in the database. But you have to change your WHERE clause. Right now you have it hard-coded to be WHERE OVID LIKE, so whatever you put it it's going to match agains the OVID column. If you want to search for the unit number then the WHERE clause has to be WHERE unit ...  Also, why would you use a LIKE for the OVID column? I don't use Access, but I'm guessing that the bold indicates it's a primary key.