is this correct?

[Ruslan Zasukhin]

on 2/10/03 4:50 PM, Pedro fp at lists at pedro.net.au wrote:

Hi Pedro,

> To maintain a couple of persistent values I'm using a table in my
> database with 1 record. Three of those values are for the ID numbering
> of records. One is a line number which must be sequential & not have
> numbers re-used when records are deleted [so RecID isn't suitable]. The
> other 2 contribute to the construction of an ID code with only one
> being used in any batch of data being imported.
> 
> In the following code nc is a vCursor & nfName holds the name of field
> being used for the ID codes. Although I believe I'm following the V4RB
> manual closely I'm not sure that I've got it right because no
> autocomplete happens for UMediumField on the 2 lines just before b =
> nc.update(). Any tips?
> 
> 
>      ' Get next record numbers.
>      qs = "SELECT nextRec, " + nfName + " FROM prefsGlobal"
>      nc = gxbSDB.SqlSelect( qs )
>      nextLine = nc.UMediumField( "nextRec" ).value
>      nextID = nc.UMediumField( nfName ).value
> 
>      ' Perform import
>      ' a whole lot of stuff is done here updating
>      ' nextLine & nextID along the way.
> 
>      ' Update next record numbers
>      nc.UMediumField( "nextRec" ).value = nextLine
>      nc.UMediumField( nfName ).value = nextID
>      b = nc.update()

But if it can compile this code?
IF yes, then simply ignore that glitch of autocomplete

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------