CODEWITHSUNDEEP
vb.net
Harish
Harish

Reputation: 169

vb.net access query for updating

is d query rite ? q = "update FIRSTBBA WHERE FBBANAME<>"" ORDER BY FBBANAME" Need to update a table in ascending order

Upvotes: 0

Views: 217

Answers (2)

PradeepGB
PradeepGB

Reputation: 314

This query is not complete. You can use inner SQL statement based on your requirement and update the table based on that.

Upvotes: 1

clyc
clyc

Reputation: 2450

You're not assigning a value to FIRSTBBA. Also, not sure what database you're using but I don't think SQL server allows an order by clause in an update statement. you would have to refer to a post like this one: How to update and order by using ms-sql

Upvotes: 0

Related Questions