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." <(E-Mail Removed)> wrote in message
news:90BDE0C7-5831-4A8A-9DDC-(E-Mail Removed)...
>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

--
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


"Triax" wrote:

> "Steve B." <(E-Mail Removed)> wrote in message
> news:90BDE0C7-5831-4A8A-9DDC-(E-Mail Removed)...
> >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
>
> --
> Triax
>
>
>

Cool. I will check it out!

--
Triax


"Steve B." <(E-Mail Removed)> wrote in message
news:5BD37AFF-F2B6-4D35-BB53-(E-Mail Removed)...
> 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" wrote:
>
>> "Steve B." <(E-Mail Removed)> wrote in message
>> news:90BDE0C7-5831-4A8A-9DDC-(E-Mail Removed)...
>> >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
>>
>> --
>> Triax
>>
>>
>>