HomeActive Query BuilderSQL Parser

SQL Parser


Hi there! I've been trying your component, but only the free version, and I wanna compare it with General SQL Parser component in order to decide who is better and purchase that. Let me explain my needs:
* I need a visual query interface, and your component have it.
* I need to parse sql querys, unions, joins, subqueries, etc. and I need to know table names, table alias, field names, field aliases and all stuff related with the parsed query. Your component can do that?.

Thanks in advance, I wait for your answer soon, is very important to take my decision and so important for my project.
Daniel Ulises | email
April 9 2008, 01:06 PM
I suppose you should have a look the Non-visual usage sample to see that all the information that you need could be easily extracted in several ways:
- by querying internal query structure objects;
- using the QueryStatistics property;
- by exporting to XML (QueryBuilder.QueryStatistics.QueryStructureXML) and using XPath to extract the information you need (sub-queries, derived tables, etc.)

Sergey
Sergey Smagin | email
15 hours, 5 mins since original post
This topic is closed