Sample Business Application

I would like to see, as a sample
code of a typical Business Application
developed in ST,
using an RDBMS for a back end

i.e. Master-Detail Entry screen
updating the database
and Reporting construction methods

Please email me or point me to a
link of any small code samples

Thanks
Sanjay Minni
[hidden email]
Minisoft Pvt Ltd

Hi:

I guess that the screenshots of http://www.tradeperformance.com/ can show
you the type of app that you need to develop.

HTH

---
Germán S. Arduino
http://www.rva.com.ar



"Sanjay Minni" <[hidden email]> escribió en el mensaje
news:[hidden email]...

"Sanjay Minni" <[hidden email]> wrote in message
news:[hidden email]...
> I would like to see, as a sample
> code of a typical Business Application
> developed in ST,
> using an RDBMS for a back end
> i.e. Master-Detail Entry screen
> updating the database

I use ReStore for any database work where I can dictate the layout of the
database.  It allows me to work with objects and not DB records.  There is
very little mapping work overhead, a class side method, and opening and
closing transactions.  Essentially you can do a normal Dolphin MVP UI as the
database is almost transparent.  A free trial version, and an example
application can be downloaded.  See the site for more info (
http://www.solutionsoft.co.uk/restore/index.htm ).

If you look at the Personal Money application included in Dolphin you will
see an example of an MVP UI.  Louis Sumberg has done an extension tutorial
that makes the example more sophisticated (
http://www.mindspring.com/~lsumberg/PersonalMoney/ ).

If I have to interface with an existing database I generally use ADO (a
wrapper is now included in Dolphin).  I used to use ODBC but I find ADO is
better for most tasks.  The objects would have methods to load themselves
from and write themselves to the database.  ADO can be used from Dolphin
much like it can be from VBA.  Once you have the objects the UI would be
like any normal Dolphin MVP UI.  Depending upon the size of the database you
may wish to use a proxy technique to avoid loading too much data all at
once.  This is why I like ReStore, it handles the proxying for me.

> and Reporting construction methods

I have used Crystal Reports, it does not lend itself to easy reporting from
object structures.  I have sent data to a temporary table and reported on
that.  Crystal Reports is probably more trouble than it is worth to use from
Dolphin, unless you really need fancy looking easily customizable reports.

What I have used that seems to work well for my needs is an RTF generating
stream.  I use Ian's ( http://www.iandb.org.uk/ ) RTF printing goodie for
the preview and printing.  One advantage of RTF is that reports can be saved
to files that can be opened in MS Word.  My objects include methods that can
report on a stream.  There are a number of RTF generator goodies out there.
I haven't actually used it, but Steve Waring's looks nice (
http://www.stevewaring.net/blog/home/index.html ).  One disadvantage of RTF
is that it is harder to do tables with vertical lines in a compatible way
that does not require MS Word.

I hope these comments have been of use.

Chris

Yes, exactly,

Can I get some guidelines on the usual methods / practices
of building such apps and code snippets or sort of foundation classes

for master-detail, reporting and Database interface logic

Thanks
Sanjay
www.planage.com/products

"Germán S. Arduino" <[hidden email]> wrote in message
news:b3l0mu$1m1d0c$[hidden email]...

Thanks

Actually I was looking for enough material to assemble a complete
business app (typically 50 screens Mater detail, 200 reports)
sort of Foundation classes for type of apps in the link below

Actually we are used to Powerbuilder where the "Datawindow" and the
Foundation Classes handle all the implementation aspects

Sanjay Minni
www.planage.com/products


"Christopher J. Demers" <[hidden email]> wrote in
message news:b3m3jp$1nkjkh$[hidden email]... the you
> may wish to use a proxy technique to avoid loading too much data all at
> once.  This is why I like ReStore, it handles the proxying for me.
>
> > and Reporting construction methods
>
> I have used Crystal Reports, it does not lend itself to easy reporting
from
> object structures.  I have sent data to a temporary table and reported on
> that.  Crystal Reports is probably more trouble than it is worth to use
from
> Dolphin, unless you really need fancy looking easily customizable reports.
>
> What I have used that seems to work well for my needs is an RTF generating
> stream.  I use Ian's ( http://www.iandb.org.uk/ ) RTF printing goodie for
> the preview and printing.  One advantage of RTF is that reports can be
saved
> to files that can be opened in MS Word.  My objects include methods that
can
> report on a stream.  There are a number of RTF generator goodies out
there.
> I haven't actually used it, but Steve Waring's looks nice (
> http://www.stevewaring.net/blog/home/index.html ).  One disadvantage of
RTF
> is that it is harder to do tables with vertical lines in a compatible way
> that does not require MS Word.
>
> I hope these comments have been of use.
>
> Chris
>
>

Unfortunately I haven't experience using Smalltalk + DBs, and also I'm a
novice smalltalker, but I think that you can mail to tradeperformance or
search in the Dolphin ring or in the tutoriales pointed by Chris, mainly in:
http://www.mindspring.com/~lsumberg/PersonalMoney/

I hope you find your examples!

Regards.


"Sanjay Minni" <[hidden email]> escribió en el mensaje
news:[hidden email]... show