Subject | RE: [IBO] Is it possible to only create selects when a form is requested? |
---|---|
Author | Jason Wharton |
Post date | 2006-01-24T23:01:41Z |
> My database possesses many fields in several forms. IsThis sounds to me like you are wondering if you can change your SQL
> it possible to only create selects when a form is
> requested?
> I would like to only make that through the
> application. (I use IBO)
> How can I make that?
statement during your programs execution instead of just setting it once at
design-time. The answer is you can change the SQL property of your dataset
at run-time and send a new query to the server.
An example could look like this:
MyQuery.SQL.Text := 'SELECT * FROM MYTABLE';
There are also propertis that help you parse the SELECT statement some. If
you only want to change the WHERE clause then you can do this:
MyQuery.SQLFrom.Text := 'FROM MYTABLE'
MyQuery.SQLWhere.Text := 'WHERE MYTABLE.ID = 100';
Then, when you look at your SQL property those chunks of SQL are parsed into
it where they belong.
Hope this helps,
Jason