how to update a record in oracle(sql) using frontend as visualbasic6.0

avenkatesh

i used RDO connection to connect oracle as backend and visualbasic as frontend.
i prepared inventory system. For updating a record of item 'sales' i need a command. it should not add new record,but it has to update(modify) the old record

vb5prgrmr

Look at the update method of SQL syntax. (Found in Visual Studio 6.0 help files for Fox Pro, Access, SQL Server help files, and many places on the web)...

Expand|Select|Wrap|Line Numbers

 
strSQL = "UPDATE tablename SET fieldname1 = newvalue1, fieldname2=newvalue2 WHERE somefield=somevalue"

Good Luck

how to update a record in oracle(sql) using frontend as visualbasic6.0

re: how to update a record in oracle(sql) using frontend as visualbasic6.0

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about