search function VI

[labviewproject]

Thanks for pointing out that i should use ovid = instead of the where clause. but i would like to ask why no data was displayed in my front panel? is it due to the where clause? also, the ovid is my primary key. 

[smercurio_fc]

Enter your SQL statement directly in MS Access. What do you get? If your SQL statement is not correct then that's why you're not getting data.

[labviewproject]

Thanks alot. I managed to get the data from the database after inserting the select query which i got from access. however, the data is displayed in column instead of the usual row. How do i change them into displaying in row instead of column & also displaying their table name? Many Thanks. 

[RavensFan]

Try to transpose the array before writing it to the table.

[labviewproject]

Hi, may i know where should i place the transpose 2d array? because i added it before the index array & my data display becomes numbers & it still display in column view.

[RavensFan]

I don't know what your code looks like.  But if you have a 2-D array going into the table, and you want to turn rows into columns and columns into rows, then doesn't it make sense to put the Transpose array in the wire right before it goes into the table?

[labviewproject]

Thanks alot. i didn't notice that i should place it before writing to the table. 2 more question. how can i display my column name at the top of the table control? & there seems to be something wrong with my variant to data vi. everytime i change some component in my vi, i would have to reset the data type input of the 'variant to data vi' to numeric constant before changing it back to string constant. is there a way to solve this?

[RavensFan]

You can right click on the control and make the Column headers visible.  You can set their values by writing to the Column Header Strings[] property node.

I have no idea about your variant datatype problem.  You'd have to post the latest copy of your VI along with a description of steps on how to reproduce the problem.

[labviewproject]

Hi. Thanks for the tip about column header. i cant seem to find the build table express vi which i found in http://forums.ni.com/ni/board/message?board.id=170&message.id=337154 following smercurio_fc method. Do you mind helping me to modify the column table? also, maybe you could take a look at my variant to data vi. Many Thanks.

[RavensFan]

For some reason, I don't have all of the database VI's.  Since I don't have them, nor your database to give any results, I can't take a look at the database variant VI to know if it is working right.

The inner For loop that runs once isn't necessary.  Using a build array function gives the same result as a For Loop that runs once with autoindexing  However, my gut feel is that you should be doing something different here to get the different fields that are in a single string parsed out into different columns

See attached.