🚀 go-pugleaf

    Create your sql string is the best way to solve your problem.  Dave
Rowntree is right.  You can then split your SQL in multiple functions, 1 for
eatch part of your sql ... like the Select, join, where, order by ...

    Claude Bissonnette

"Steve Kothenbeutel" <skothenbeutel@consultant.com> wrote in message
news:3cffe0fb_2@dnews...
> Here is my clarification.
>
> Consider the following SQL statement:
>
> select * from table1 where name='steven' and age=25
>
> lets say that the user sends back just the name parameter and does not
wish
> to search using the age parameter... how do I customize the SQL statement
to
> reflect this?
>
> Essentially I would like to dynamically take one SQL statement and be able
> to change it according to the specified parameters sent from a user.  So,
I
> would like to search using any number of parameters with "and" or "or"
> operators in the SQL statement.  How do I set these without having to
> hardcode it into the SQL statement within the program?
>
> Thanks!
>
>
> Steve Kothenbeutel
> skothenbeutel@consultant.com
>
>
> "Steve Kothenbeutel" <skothenbeutel@consultant.com> wrote in message
> news:3cffb4e2_2@dnews...
> > What happens when I have any number of arguments to pass?  This is my
> > problem.  For example... if the user sends 2 arguments back, I want to
be
> > able to change the SQL... and if the user sends just one argument, then
I
> > want to be able to change the SQL... see my point?
> >
> > Thanks for the assitance!
> >
> > "Clay Shannon" <cshannon@amfam.com> wrote in message
> > news:3cff9614$1_1@dnews...
> > > Use the Format function, zB:
> > >
> > > Format('Select %s, %s FROM %s where %s = %s',
> > >   [arg1, arg2, arg3, arg4]);
> > >
> > > "Steve Kothenbeutel" <skothenbeutel@consultant.com> wrote in message
> > > news:3cff342f_2@dnews...
> > > > Hello,
> > > >
> > > > I am trying to create dynamic SQL statements that depend on user
> input.
> > I
> > > > am aware of the Parameters property in TADOQuery for example... but
I
> am
> > > > unsure how to use it in the following scenario:
> > > >
> > > > A user sends a request for information as such:
> > > >
> > > > select :readfields from table1 where :conditions
> > > >
> > >
> > >
> >
> >
>
>