Client Data Sets ...

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

3 messages

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

3 total messages Started by Nick Rambarransingh Fri, 21 Jul 2000 00:00

#1055

Author: Nick Rambarransingh
Date: Fri, 21 Jul 2000 00:00

11 lines
884 bytes

Good Day All,

  I think I am starting o get that uneasy feeling about ClientDataSets.
After reading up on it some more, I am starting to realize that I can
NOT dynamically change the SQL statement in the RemoteDataModule->Query
?  TRUE/FALSE.

  That being said, how do I make the query retrieve the records I want ?

Thanks, Nick
Borland Forever ...

Re: Client Data Sets ...

#966

Author: Steve Pietrykoski
Date: Fri, 21 Jul 2000 00:00

20 lines
1208 bytes

What version are you using?  BCB5 introduces the CommandText property. 
Before that you have to extend the server interface yourself to pass
back a new SQL.

Steve Pietrykoski


Nick Rambarransingh wrote:
> 
> Good Day All,
> 
>   I think I am starting o get that uneasy feeling about ClientDataSets.
> After reading up on it some more, I am starting to realize that I can
> NOT dynamically change the SQL statement in the RemoteDataModule->Query
> ?  TRUE/FALSE.
> 
>   That being said, how do I make the query retrieve the records I want ?
> 
> Thanks, Nick
> Borland Forever ...

Re: Client Data Sets ...

#981

Author: Harold Howe (TeamB)
Date: Thu, 27 Jul 2000 00:00

15 lines
1220 bytes

Nick Rambarransingh wrote:
> 
>   I think I am starting o get that uneasy feeling about ClientDataSets.
> After reading up on it some more, I am starting to realize that I can
> NOT dynamically change the SQL statement in the RemoteDataModule->Query
> ?  TRUE/FALSE.

In what way do you need to change it? If you only need to alter a parameter, then
look at the param features of the client dataset.
You can change the SQL. If you need to change it drastically from the client, such as
selecting from a totatly different field, then you might want to consider what
benefit the app server is really bringing to the table.

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