using LabSQL

[netee]

Hi,

I am new to using labview in database access. I'm using MS access database and LabSQL. I did examples that are given within labSQL(e.g Fetch into Table, and Insert onto Table) and successfully compiled. I want to know if it is possible to insert into the table without using sql command. Like if i have a VI front panel as shown below so that when i click the button the infomation displayed on the fields are inserted into the table.

Thanks!!

[Dennis_Knutson]

Why don't you want to use the Insert command? You just have to do something similar to the example you mentioned.

[netee]

Hi,

my problem is i have to build this for users who does not have any clue or background of using access commands, so they just want to put values and click inoder for them to insert into the database or access the database.

thanks!!

[Dennis_Knutson]

They don't have to know any SQL. You, as the programmer, do. You would use something like the Format Into String function to create the SQL statement. Your three front panel controls would be inputs into the function.

Message Edited by Dennis Knutson on 07-01-2008 08:00 AM

[Wiebe@CARYA]

(Dennis, I think he means he doesn't want the insert query on the front
panel, like in the examples...)

Netee, you have to program that yourself.

So I'd use an event structure. If some event occurs (like pressing a
button), use the insert statement (as constant on your diagram) to trigger
the database action.

Regards,

Wiebe.