1.1.1

ID |NAME
------------------------
40 |FORTY
--scroll insensitive cursor
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor
as 'select * from firsttable';
--another connection performs the following operation.
sqlf> update firsttable set name='Forty' where id=40;
1 row inserted/updated/deleted
--the insensitive cursor does not reflect the update
sqlf(PEERCLIENT)> next scrollCursor;
ID |NAME
------------------------
40 |FORTY
GetCurrentRowNumber
Returns the row number for the current position of the named scroll cursor.
Syntax
GETCURRENTROWNUMBER Identifier
Description
After the cursor is created with the get scroll insensitive cursor on page 446, returns the row number for the
current position of the named scroll cursor. Zero (0) is returned if the cursor is not positioned on a row.
Example
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor as 'select * from firsttable order by id';
sqlf(PEERCLIENT)> absolute 3 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
sqlf(PEERCLIENT)> before first scrollCursor;
No current row
sqlf(PEERCLIENT)> GETCURRENTROWNUMBER scrollCursor;
0
sqlf(PEERCLIENT)> relative 2 scrollCursor;
ID |NAME
------------------------
20 |TWENTY
sqlf(PEERCLIENT)> GETCURRENTROWNUMBER scrollCursor;
2
help
Prints a list of the sqlf commands.
vFabric SQLFire User's Guide448
vFabric SQLFire Reference