Edit a particular element in a data base table

[karpaga]

Hi I use database toolkits .I created  tadle as shown below with DB Tools Insert data vi.

a

a

Name	Marks
kav	88
ani	56
ayy	90
sug	89
jey	97

 

I want to edit the name ayy and the mark corresponding to the name .can anyone give me a solution for this

[Ranji]

May be you have to use update command with a criteria to update the name.

Message Edited by Ranji on 06-25-2009 02:11 AM

[MikeS81]

Hi karpaga,

you should use the update command.

Mike

Message Edited by MikeS81 on 06-25-2009 09:13 AM

[karpaga]

Thanku all

i will try and come back to u

[karpaga]

I couldn't find a update vi in db tools

[MikeS81]

Hi kavi,

use the "DB Tools Execute Query" function with this SQL query:

UPDATE <tablename> SET name="new" WHERE ID=50

You have to close the recordset refnum with the "DB Tools Free object" function.

Mike

Message Edited by MikeS81 on 06-25-2009 09:41 AM

[MikeS81]

Hi kavi,

in your case the Update command should be like this:

UPDATE a SET Name="kavi",Marks=101 WHERE Name="ayy"

Mike

[karpaga]

Hi Mike,

-2147217904

NI_Database_API.lvlib:Conn Execute.vi->Example to Update PhoneNumber Labview MDB (8.6).vi<ERR>.  Invalid string: specified field does not exist or contains an unsupported character

I attached the program and the access i used.

[karpaga]

HI mike,

Im waiting for ur reply

[MikeS81]

Hi kavi,

the Marks value has to be in quotation marks, because it's also a text.

See the attached example.

Mike