setnumber

[Richard]

In the functions often one encounters 'setnumber'.
When calling this function I get errorcode  -14  = invalid setnumber

Can someone explain what this setnumber is and what it is used for?

Thanks
Richard

example

;========================<[ Get Column Name ]>=========================
;Declare Sub      sluGetColumnName lib "SQLiteningU.Dll" alias "sluGetColumnName" ( _
;                                byval ColumnNumber As Long, _
  ;                               byval ColumnName As Long, _
   ;                              byref SizeOfColumnName As Long, _
    ;                             byval SetNumber As Long)
;   ColumnName is a pointer to the memory which will receive the column
;              name(s).  Will return all column names if the passed column
;              number is zero. If all column names are returned then it is
;              a delimited text string which is $NUL seperated.  A Null
;              (hex '00') will be added to end (meaningless if all column
;              names are returned).
;   SizeOfColumnName is both passed and returned. Pass the size of ColumnName.
;                    It must be at least the size of the returning column name + 1.
;                    The actual length of the returing column name(s) is returned.
;                    If the passed size is too small then returning length will be
;                    set to -1.

[Rolf Brandt]

You can open more than one dataset at the same time, for example with the slSel statement.

If you create a dataset with slSel and omit the SetNumber then SetNumber will always be 0. If you create the set with a specific number than you have to reference this SetNumber in other functions.