DataSets

[Beringer]

Is there a way to use SQL like terminology but instead of accessing a
database use DataSets?

I ask because in the current project I am doing there is need to create
tables dynamically as results of queries. These tables are then used
proceed to the next step.

In a server environement I can see where if several people were doing the
same task and creating the same table there would be conflicts. So I
thought, what if I could generate DataSets and then manipulate them in
memory without creating temporary tables in the database to do the work.
However, outside of setting up simple parent-child relationships(joins) for
DataSets I don't see many options in manipulating relations between
datasets.

For instance, I would need to create joins between DataSet and tables in a
database. I also need to create Cross Joins between datasets.

Thank you in advance,

Eric

 

[Mahesh Devjibhai Dhola]

Eric,
First, DataSet is independent of the database. After you have filled DataSet
you can do anything with it without any single program through programming
(you do not need to use sql queries etc as it is with Database).
You can use relationships (joins) also and you can also cache those DataSet
objects for further use.

So, i think there will not be any problem in your case.
If anything else, then please specify exact ur need.

Regards,
Mahesh Devjibhai Dhola
"Empower yourself...."

 

[Beringer]

The problem that I am facing is that some data is in one database and some
is in another.
I guess the issue that I am having is how do you efficently use datasets to
do common SQL operations?

Thank you for your response.

Eric

 

[Mahesh Devjibhai Dhola]

Dear Beringer,
DataSet is independent of database. You can use it in the way like, you can
feel the DataSet with one table is from Oracle and one table from SQL Server
2k. And then play with the dataset.

Regards,
Mahesh Devjibhai Dhola
"Empower yourself...."

 

[Beringer]

Ah!
Thank you for your assistance on this matter.
Eric