Caché SQL Reference
WHERE CURRENT OF
|
|
WHERE CURRENT OFcursor
Specifies that the operation is done at the current position of |
NEW %ROWCOUNT,%ROWID &sql(DECLARE WPCursor CURSOR FOR SELECT Lang FROM SQLUser.WordPairs WHERE Lang='Sp') &sql(OPEN WPCursor) QUIT:(SQLCODE'=0) FOR { &sql(FETCH WPCursor) QUIT:SQLCODE &sql(UPDATE SQLUser.WordPairs SET Lang='Es' WHERE CURRENT OF WPCursor) IF SQLCODE=0 { WRITE !,"Update succeeded" WRITE !,"Row count=",%ROWCOUNT," RowID=",%ROWID } ELSE { WRITE !,"Update failed, SQLCODE=",SQLCODE } } &sql(CLOSE WPCursor)
NEW %ROWCOUNT,%ROWID &sql(DECLARE WPCursor CURSOR FOR SELECT Lang FROM SQLUser.WordPairs WHERE Lang='En') &sql(OPEN WPCursor) QUIT:(SQLCODE'=0) FOR { &sql(FETCH WPCursor) QUIT:SQLCODE &sql(DELETE FROM SQLUser.WordPairs WHERE CURRENT OF WPCursor) IF SQLCODE=0 { WRITE !,"Delete succeeded" WRITE !,"Row count=",%ROWCOUNT," RowID=",%ROWID } ELSE { WRITE !,"Delete failed, SQLCODE=",SQLCODE } } &sql(CLOSE WPCursor)
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
|
Content for this page loaded from RSQL_wherecurrentof.xml on 2019-02-22 02:07:25
|