Create Runtime SQL Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to create an SQL statement at run time based on the items the user
selects on a report menu. The SQL statement gets quite complex if you have
13 menu items each having associated WHERE cretria. I'm using StringBuider to
build the statement

Is there a simple way to create an SQL statement?. Is there a procedural
methodology I should follow when developing the statement? Is there
something free on the web I can maybe pass parameters and it returns a SQL
string? I've already broken the statement into parts. The table,
table.field, AND's and the OR's get real confusing real fast.

Thanks
Steve
 
Steve B. said:
I have to create an SQL statement at run time based on the items the user
selects on a report menu. The SQL statement gets quite complex if you
have
13 menu items each having associated WHERE cretria. I'm using StringBuider
to
build the statement

Is there a simple way to create an SQL statement?. Is there a procedural
methodology I should follow when developing the statement? Is there
something free on the web I can maybe pass parameters and it returns a SQL
string? I've already broken the statement into parts. The table,
table.field, AND's and the OR's get real confusing real fast.

Thanks
Steve
Click to expand...

Yes. EasyObjects lets you build dynamic SELECT statements on the fly, for
both SQL Server and Oracle.

http://www.easyobjects.net
 
Back
Top