Newbie Question regarding XML and Datasets

[John Wildes]

Hello everyone, I will try to keep this as brief as possible.

I have 1 data connection and 1 data adapter in my project. The connection
is to a dBase file directory using the Microsoft dbase VFP driver (it's
light years faster than the dbase only driver). I have three separate
commands dsSelectCustomerInfo, dsSelectCustomerBalance,
dsSelectTransactions. I have used the SQL command builder in the IDE to
generate the Select statements I need, and have verified that the data I
need returned is correct, for now.

I have generated the datasets using the Generate Dataset command on the data
adapter. I have three datasets dsCustomerInfo, dsCustomerBalance,
dsTransactions. The main element in the dataset schema is "Table" as this
was generated by the data adapter. I would like to make it CustomerInfo,
Balance, Transactions, etc for each of the respective datasets. How do I do
this, since it appears to be done at the select time? I have tried making
the SQL statments "Make Table" statements but that bombs out the SQL
verifier.

Like I said, I am really new at this, so if futher explanation is needed
please reply to the group, or email john_wildes(AT)ars.aon.com

Thanks
john

 

[Miha Markic]

Hi John,

If I understand correctly, you should change the names in dataset editor
(just edit the name in table header).
The automatically generated name is based on source select.
To make sure you fill the right tables (once you change name) you just call
Fill method and pass a table (instead of just dataset).