Another way is to do all your business objects as COM objects and use ADO
for database access (Delphi Professional will work just fine for this). Your
Windows GUI takes the form of *thin* Delphi TForms using the underlying COM
objects and when you need to do the web app, all you need to do is write a
set of ASP pages talking to the already existing COM objects.
This is a proven architecture that works quite well - you could even move
all database related stuff into a separate datalayer-type COM object to make
it even better. This will allow you to write Delphi code like so:
var
oCustomer: ICustomer;
oDataLayer: IDataLayer;
oRS: _Recordset;
begin
oCustomer := ICustomer.CoCreate;
oDataLayer := IDataLayer.CoCreate;
oDataLayer.Connectionstring := '...some ADO connection string...'
oCustomer.ID = ...some ID...
oDataLayer.LoadObject(oCustomer);
...do some work on Customer...
oDataLayer.SaveObject(oCustomer);
// get list of customers
oRS := oDataLayer.GetRS('select * from Customers');
... and so on...
The point of this code... very similar to the code you would write in your
ASP pages later on.
HTH
Xander
>From: Steve Aish <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
>Subject: [DUG]: Lan base vs WAN/Web based Databases
>Date: Thu, 26 Jul 2001 17:51:23 +1200
>
>I have a customer based in the US who wants a database which to start with
>will be LAN based. 18 months from now he wants to make it a web based app
>so that reps can access it from anywhere in the US.
>
>Is there any point in designing the LAN based version and then porting it
>to
>web based or is it a major shift?
>
>The reason I ask this is that in order to set up a web based app we need to
>invest lots of money and upgrade to Delphi 6 Enterprise (I currently use
>Delphi 5 Professional). This means that the customer will also be
>investing
>a lot more money up front in order to make purchasing Enterprise affordable
>for us and the project worth doing.
>
>Also is there any point in looking at other packages that allow an app to
>be
>web based (apart from Delphi Enterprise) that is cheaper?
>
>As an aside - the reason they are asking for a NZ based company is the
>exchange rate. i.e. $120 an hour here is a lot better than $120 an hour
>over
>there... Maybe we're not charging enough :)
>
>Thanks in advance,
>
>Steve Aish
>OCOM
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>To UnSub, send email to: [EMAIL PROTECTED]
>with body of "unsubscribe delphi"
>Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
