Create Runtime SQL Query

[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

 

[Triax]

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

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

http://www.easyobjects.net

 

[Guest]

Thanks Triax

I'm checking it out easyobjects now. I also came across
http://www.reebsoftware.com/. If you take a look at this product please post
your comments

Thanks
Steve

 

[Triax]

Cool. I will check it out!

--
Triax

Thanks Triax

I'm checking it out easyobjects now. I also came across
http://www.reebsoftware.com/. If you take a look at this product please
post
your comments

Thanks
Steve