I've got a macro that contains the following:
Dim oRowSet as Object
oRowSet = createUnoService( "com.sun.star.sdb.RowSet" )
oRowSet.DataSourceName = "Time"
oRowSet.CommandType = com.sun.star.sdb.CommandType.COMMAND
oRowSet.Command = "SELECT MAX( `RowNum` ) FROM Work"
Dim oInteractionHandler as Object
oInteractionHandler = createUnoService(
"com.sun.star.sdb.InteractionHandler" )
oRowSet.execute( oInteractionHandler )
oRowSet.next ' now _on_ the first record
dim iLB as integer
iLB = oRowSet.getInt( 1 )
iAddOne = iLB + 1
This works perfectly under 1.1 but I've just isolated under 108 and it
fails. iLB = 0 which is no good. Can anyone correct this so it will
work under Base/2.0? [The Datasource Time is loaded and the table Work
appears fine under the Data Source Browser]
Thanks in advance,
P h i l l
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
