Skip to Content (Press Enter)
2023-02-10 19-42-59
João Melo
 
MVP
5Views
2Comments
How to convert Advanced Query to Ansi SQL?
Question
SQL
API
Is it possible to usa some API to validate and convert an Advanced Query statement to Ansi?

Why? I1m working on an App that enables the user to create his own Advanced Queries in Runtime. Só I would like to validate sintaxe, giving him some feedback when errors are found, and to run the statement aggainst database to export the result set as a CSV file.
0
0
10 Dec 2014
Copy Link
2012-10-08 11-59-27
Guilherme Pereira
Staff
Hi João,

Have you looked the component SQLMap.

By your description this one seems to be what you want or at least provide you with a quick start.

Cheers
1
0
11 Dec 2014
Copy Link
2023-02-10 19-42-59
João Melo
 
MVP
Yes, I have already tested it. But it doesn't work in some cases. Unfortunately I couldn't map all these cases, and I would like to use something error proof. But thank you for the tip.
0
0
11 Dec 2014
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.