How to parse a SQL string?
C#
1
Posts
1
Posters
0
Views
1
Watching
-
My project is now to parse the Select SQL String typed by the user to visualize the table, the relation ship, the type of JOIN, the Critical etc... in a form. Would you please give me some hints or some algorithms or tell me if there would an OCX solved this problem? I tried my best to solve this problem but it's too complicated. In MS SQL Server, the SQL string is parsed that is different from the SQL string parsed in MS Access. Thank you. PS: Actually, there are too many keywords in one SQL string, especially after FROM in the SQL string. And I don't care 'bout what databse is.