Sql manipulation ...

[MaxZeta]

Hi Guys,

I realized a Dll to use with Vb / Delphi to manipulate SQL to improve
the performance and convert the SQL language!!

-Conversion :
Actually the conversion is from Ms Access to Oracle in real time!!
so You can write the query in MsAcc Ide and execute with Mdb or
with Oracle!

-Parameter:
You can write a query like this:

Select [FirstField|F] from [Tablename|F] where (Param1 =
[UserParam1|S] and where ParamNumeric = [UserParamNumeric|N]) Or
FieldName = [UserfieldName|F]

then pass these parameters:

FirstField = "UserName"
Tablename = "UserTable"
UserParam1 = "*NF*" : No Filter
UserParamNumeric = "*NF*" : No Filter
UserfieldName = "MyFieldName"

and the Dll remove unused where-part :

Select UserName from UserTable where FieldName = MyFieldName

You can store all the queries U wrote in a fast binary file to use in
your application!

You can use subQuery ,

and You can use an Ide to test the queries!!

The .Dll (280kb) and the Ide are free ...

I'll post the url to download if someone is interesting !!

Bye Bye ;-)

[Tom van Stiphout]

On 6 May 2004 09:44:32 -0700, Ma*******@yahoo.com (MaxZeta) wrote:

While I appreciate your efforts, without source code I wouldn't touch
it.

-Tom.

Hi Guys,

I realized a Dll to use with Vb / Delphi to manipulate SQL to improve
the performance and convert the SQL language!!

-Conversion :
Actually the conversion is from Ms Access to Oracle in real time!!
so You can write the query in MsAcc Ide and execute with Mdb or
with Oracle!

-Parameter:
You can write a query like this:

Select [FirstField|F] from [Tablename|F] where (Param1 =
[UserParam1|S] and where ParamNumeric = [UserParamNumeric|N]) Or
FieldName = [UserfieldName|F]

then pass these parameters:

FirstField = "UserName"
Tablename = "UserTable"
UserParam1 = "*NF*" : No Filter
UserParamNumeric = "*NF*" : No Filter
UserfieldName = "MyFieldName"

and the Dll remove unused where-part :

Select UserName from UserTable where FieldName = MyFieldName

You can store all the queries U wrote in a fast binary file to use in
your application!

You can use subQuery ,

and You can use an Ide to test the queries!!

The .Dll (280kb) and the Ide are free ...

I'll post the url to download if someone is interesting !!

Bye Bye ;-)

[MaxZeta]

Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<q1********************************@4ax.com>. ..

On 6 May 2004 09:44:32 -0700, Ma*******@yahoo.com (MaxZeta) wrote:

While I appreciate your efforts, without source code I wouldn't touch
it.

-Tom.

Hi Tom , I understand your "fear" , but currently I would not want to
post the source!!
perhaps in future.. ;)
Url: http://www.realtimeinformatica.it/Stany/