🚀 go-pugleaf

That'll work, but you can also instantiate an instance of the app. server dispatch
interface in your client.  You can then create app. server methods to have the app.
server perform any tasks you want, including modifying the SQL properties of your
TQuery objects.  You call these methods from your client through the dispatch
interface passing any required parameters.

The dispatch interface is instantiated as follows:

 SMSrvrDisp = new ISysManSrvrDisp();

If you're using a Socket connection bind it like this:
  SMSrvrDisp->Bind(WideString(SysManSocket->ServerName));

If you're using a DCOM Connection, bind it like this:
  SMSrvrDisp->Bind(DCOMConnection->GetServer());

Use the IsBound() method of the dispatch interface to make sure binding worked.

For example, SQL statements can be passed to an app. server method as a WideString
type using the WideString's Copy() method like this:

WideString  wsXfrHistSQL;

 // add the XfrHistQry SQL statement to the WideString
wsXfrHistSQL = "SELECT XFR.Time, XFR.Server, XFR.ClientCode, XFR.Action, "
"XFR.FileName, XFR.FileSize, XFR.FileDate "
"FROM XfrHistory AS XFR (NOLOCK) "
"WHERE  XFR.ClientCode = :ActCode "
"ORDER BY XFR.Time";

 // transmit the SQL statement up the pipe
SMSrvrDisp->SetXfrHistQrySql(wsXfrHistSQL.Copy());

App. server methods are easy to set up using the Type Library.  For the above
example, the parameter type for app. server method "SetXfrHistQrySql()" is BSTR.

The dispatch interface is descended from the TAutoDriver class.  Also see the AdHoc
example in your BCB Examples\Midas Folder.

Regards,
John

"mykle hoban (borland)" wrote:

> The component is called TDatasetProvider. You can use the CommandText property
> of your ClientDataset to dynamically set the SQL property. Note: you'll have to
> set the poAllowCommandText = true in the DatasetProvider options.
>
> Hope this helps,
>
> _mykle
>
> Will Hunt wrote:
>
> > I want to let the client to dynamically generate the SQL command. I know in
> > the c/s
> > environment ,it's not difficult to realize it.But,now i adapted the midas
> > mode ,and the system has been used for some time. I want to how to resolve
> > it .I've seen some books,takling about BCB3.0 or4.0 , have introduce to
> > resolve it through TProvider,but in BCB5 this component has seems to
> > disappeared.
> > Can anyone help me! THX
> >
> >                                 Willy