Edit a particular element in a data base table

[MikeS81]

Hi kavi,

the uploaded vi works for me and i use your database in this example. Try it with the string from my example.

Mike

[Dennis_Knutson]

Use a single quote (') instead of the double quote (") to indicate a text value. I got the same error on the sample database until I changed to the correct text delimiter. Is there an option in access to use the " ? The only thing that works with SQL Server and Oracle is ' .

[karpaga · Accepted solution]

Thanku all.I can uptate it.I just used single quotation for strings.Thanku mike,rajni and dennis

[karpaga]

 I tried to update kavi as sangeetha and its corresponding Mark value 50 as 100

using this comment 

UPDATE a SET Names='SANGEETHA', Marks='100' WHERE Names='KAVI'

But kavi is uptated as sang and 100 is updated as 10.ie more than the previous size is not updated.

[karpaga]

anyone help me

[MikeS81]

Hi kavi,

i don't understand your problem. Did you change the database settings? With your database file from yesterday i can use your Update query without problems. Maybe you change the length ok the fields.

Mike

[karpaga]

No mike i didnt change any settings.i use tablewrite vi to insert table and update vi to update table.I attached the two vis

[MikeS81]

Hi kavi,

you changed the field sizes and that is the reason of what you see. You allow only 4 signs in the "Name" field and 2 in the "Marks" field. If you need longer names, then you have to change the size.

Mike

[karpaga]

Mike one more doubt is it possible to insert a2D array data without using for loop in database