Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006


[]update Help. . . . . . . Return;

Advice
In D2000, the following words :
UPDATE cust_data
SET cust_no = 'aa'
WHERE cust_add = 'tp1'
RETURN nme, tel INTO V_nme_J, V_tel;

UPDATE never seen. . . . . . . . . RETURN. . INTO. . . . Grammar.
Can I ask about greatly, which is the meaning of it?

: : = Update_statement
UPDATE {table_reference | [THE] (subquery1)) [alias]
SET
{sql_expression {column_name = | (Subquery2))
| (Column_name [column_name]. . . ) = (Subquery3))
[{sql_expression {column_name = | (Subquery2))
| (Column_name [column_name]. . . ) = (Subquery3) }]. . .
[WHERE {search_condition | CURRENT_OF cursor_name}] [RETURNING]
[row_expression [Row_expression]. . . INTO
Host_variable_name} {variable_name | :
[{variable_name | : Host_variable_name}]. . . ]

Inform this much - Thank you!



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com