Converting SQL Explorer to 3 Tier

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Rob Truban Mon, 25 Jan 1999 00:00

#1845

Author: Rob Truban
Date: Mon, 25 Jan 1999 00:00

15 lines
1130 bytes

Hi all,

I have an (2 tier) application I built that is very similiar to the SQL
Explorer application that comes with BCB.  I just started the process of
remaking it as a 3 tier application.  In my original app I use a
'Session->GetAliasName(myComboBox->Text)' to populate a combo box with
the availbale DB's for the user to choose from at run time.  What whould
be the easiest way to implement the same functionality via a TProvider
and ClientDataset?  In other words, populate a ComboBox on the Client
App with DataBases the AppServer has to its disposal.  Hopefully that
makes sense....

Thanks in advance,

Rob

Re: Converting SQL Explorer to 3 Tier

#1846

Author: Harold Howe (TeamB)
Date: Mon, 25 Jan 1999 00:00

25 lines
1788 bytes

>I have an (2 tier) application I built that is very similiar to the SQL
>Explorer application that comes with BCB.  I just started the process of
>remaking it as a 3 tier application.  In my original app I use a
>'Session->GetAliasName(myComboBox->Text)' to populate a combo box with
>the availbale DB's for the user to choose from at run time.  What whould
>be the easiest way to implement the same functionality via a TProvider
>and ClientDataset?  In other words, populate a ComboBox on the Client
>App with DataBases the AppServer has to its disposal.  Hopefully that
>makes sense....


In multi-tier apps, typically you can survive by only installing the BDE on
the server machine. When you do this, TSession components on the client
don't have a BDE DLL that they can call to fetch this information. However,
there will be a session control on your remote data module that can assess
the alias information.

You could add a method to your remote datamodule that fills in an array of
strings. The client side could call this method, and then take the resultant
strings and add them to the listbox. On the server side, the remote
datamodule would call the same session methods that you are used to.

Harold Howe [TeamB]
http://www.bcbdev.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads