RE: Filling a muti-table typed dataset using a stored procedure

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

Hi Jeronimo,

The name of the first table in the result set is Table. The second one is
Table1. The third one is Table2 and so on.

Now, if you change you table names into tblEvent and tblEventType, you can
add the following table mappings.

sda.TableMappings.Add("Table", "tblEvent");
sda.TableMappings.Add("Table1", "tblEventType");

I tried this on my machine, and it works fine. HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

.

Relevant Pages

  • Dynamic Variables?
    ... I want to make both of the entries at the same ... to be sent with the rest of the data to table2. ... INSERT INTO table1 ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Update/Append AND Delete combination?
    ... common field from Table1 must be updated FROM ... Table2 for a particular column?? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: VFP9 Multiple table Report Question
    ... > TABLE1 TITLE ... > TABLE2 TITLE ... > How can I print the records of two tables in a single VFP9 Report? ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • not in query
    ... I need a query to show records in table1 that are not in table2. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Tricky Visual Basic Code help...
    ... moves the current record into a new record in table2. ... this with a little VBA code and a couple custom queries. ... Set a "pushFlag" column in the record in table1 to a specific ... If a duplicate is not found, ...
    (microsoft.public.access.formscoding)