Re: DataSet from Stored Procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi M,

I successfully use the EL in various versions now (old and new). Gregory is
right to make a judgment on the compexity of adding it to everything - some
apps don't really benefit from it - but I've become comfortable with it and
find many of the routines very useful in keeping my code easier to read and
maintain.

I think you're issue has been related to mixing up usage of the commands a
bit.

Try this:

Dim db As Database = DatabaseFactory.CreateDatabase("VideoClub")
Dim ds As DataSet = New DataSet
Dim dbc As DBCommandWrapper


dim myTables() as string
'Add your table names for your various lists to the string array

dbc = db.GetStoredProcCommand("udpLists")
db.LoadDataSet(dbc, ds, myTables)


Return ds


The third parameter of LoadDataSet can be either one table name, or a list
of table names supplied as a string array.

Hope that helps.

Alec


.

Relevant Pages

  • Re: how to read an ini file
    ... Dim saKeyValuePairs ' as string array (key/value pairs) ...
    (microsoft.public.scripting.vbscript)
  • Re: Reading INI file in VBScript
    ... Dim saKeyValuePairs ' as string array (key/value pairs) ...
    (microsoft.public.scripting.vbscript)
  • Re: Code to list Objects in DB lists deleted SQL
    ... Tom (that they're temporary queries). ... lists the queries it lists some which look like they are the statements ... Dim MyQueries() As String ...
    (microsoft.public.access.formscoding)
  • Re: Reading INI file in VBScript
    ... Dim saKeyValuePairs ' as string array (key/value pairs) ... Dim cItems ' as integer ...
    (microsoft.public.scripting.vbscript)
  • RE: query not working right
    ... Dim fld As String ... Dim varAvailableAs Variant 'Init the arrays ... Dim selecRecordCount As Integer ... ' Fill in the arrays necessary for the two lists ...
    (microsoft.public.access.modulesdaovba)