• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 939
  • Last Modified:

Sql Query Parser

hi all
first of all sorry for my English!

 i want code for query parser wriiten in any higher level lang.
the thing is that code should support normal select ,where ,having and group by
and everything that is needed to write an query.

actually the thing is
fieldnames and tablenames, which user gives in input query, are different from those of actual database
so i want mapp the fieldnames and tablenames with some different names and then want to form a new query which database can execute and then want to give output in users format.

so plz guide me how to do this also if there is some query parser kind of thing with code then that can be also useful or else any other advice is most wel-come.
thanks in advance
bye
 
0
rashmitodkar
Asked:
rashmitodkar
  • 2
1 Solution
 
SNilssonCommented:
Here is some source code to get you started:

http://www.allfreetech.com/ShowMain.asp?MainID=133

On the bottom of that page you can view or download source.

The parser is implemented as a server-side JavaScript object, but should also be usable from Visual Basic or could be converted into Visual Basic without too much effort.
0
 
arbertCommented:
If you have Visual Basic, you can add a reference to the Microsoft SQL Parser and call it like any other com object....
0
 
rashmitodkarAuthor Commented:
hi arbert,
  Thank you very much for the answer!


0
 
rashmitodkarAuthor Commented:
hi arbert
 
 i want some documentation for this Microsoft SQL Parser,
can you tell me where could i get this documentation.

thanks in adv.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now