Something like a dataset

forum.wishlist (1998-2005) & forum.gupta.wishlist (2005-2010)
lmorales
Chile
Posts: 81
Joined: 31 Aug 2018, 17:05
Location: Santiago Chile

Something like a dataset

Post by lmorales » 23 Mar 2007, 01:31

 Posted by:  Leonardo Morales 

Hi,

ResultSet => DataSet (like MS VB)....why not?....we don´t have a non visual
object to manipulate data. We could read a database table or flat file and
write to xml or another kind of file.

It will be easy to send and receive data between a com server and
consumer...or between web services (next year).

Leonardo.

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2168
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Something like a dataset

Post by Jeff Luther » 23 Mar 2007, 01:48

 Posted by:  Jeff Luther 

Is your DataSet 'wishful thinking' or are you really missing that feature? I
ask because I'm not so sure that it isn't (sort of) available already. Click
on my link below, click on Samples and go to the XML DEMOS area. I show:

- a dynamic table window (TW) populated by a query.
- an XML file generated from those data.

(You could also write a TW class that would be able to build itself dynamically,
based on the tokens defined in the first row of a CSV file, too. And once
defined, pop. the TW with all the CSV data. Just a SMOP (Small Matter Of
Programming) is all it would take.)

And hey, you want it 'non visual'? Just SalHideWindow() on SAM_Create! And
with a dynamic TW you don't have to know the result set beforehand, you can
use the SalTbl functions to access each column and get title, pull data from
each row, etc. Look at my demo -- all the source is there for doing that.

Now passing the hWnd of your populated TW in your 2nd paragraph might not be
so straight-forward, depending, if you redefine your TW data into something
that could be passed on -- a flat file, memory data structure, XML file --
then that might work too.

I just found this page: http://support.microsoft.com/kb/319180
titled: "How to transform a DataSet to spreadsheet XML for Excel...
and see that that's basically what my XML demo does, code complete and it's
even Free of Charge!

Best Regards,
Jeff @ PC Design
info: www.JeffLuther.net/gupta/

Sergei Poskriakov

Something like a dataset

Post by Sergei Poskriakov » 23 Mar 2007, 10:36

 Posted by:  Sergei Poskriakov 

... Good thing the guys at Sun weren't using this kind of logic, Jeff, when
developping Java, or else we'd still be stuck with static arrays instead of
a whole range of dynamic storage structures ;-) after all, all it takes to
code an associative array is a SMOP! Or does it?

Cheers and thanks for the samples!

--
Sergei Poskriakov
Analyst-Programmer
http://www.dfi.ch

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2168
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Something like a dataset

Post by Jeff Luther » 23 Mar 2007, 16:15

 Posted by:  Jeff Luther 

;-)) Right back at you ;-))

"all it takes to code an associative array is a SMOP! Or does it?" - Well,
you won't need to find out, since you get to use my samples without much
SMOP on your part!

Cheers back - Jeff

lmorales
Chile
Posts: 81
Joined: 31 Aug 2018, 17:05
Location: Santiago Chile

Something like a dataset

Post by lmorales » 24 Mar 2007, 06:51

 Posted by:  Leonardo Morales 

Hi,

ok, understood. Good and nice example...but TD Com Servers doesn´t support
TW...that´s my problem.

thanks for your reply
Leonardo

Return to “gupta.wishlist”

Who is online

Users browsing this forum: [Ccbot], Dave Rabelink and 1 guest