I am trying to validate a text area widget
for example I type text in this format into the text area and it worked fine
Working format
SELECT * FROM Products WHERE Price BETWEEN 10 AND 20;
But I want to achieve this line break structure
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;
I tried using 2 separate text field like this
Text field 1: SELECT * FROM Products
Text field 2: WHERE Price BETWEEN 10 AND 20;
This works (But I don’t want this) as I will be using tab and its not natural way of typing an SQL Query
I want to be able to type in all the SQL Query in the text area as separate line like this even if it is 20 lines
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;
Basically I want to achieve this type of structure using only the text area
A Basic Query Structure Looks Like This
SELECT field1 [,“field2”,etc]
FROM table
[WHERE “condition”]
[GROUP BY “field”]
[ORDER BY “field”]
Extra if possible on text change I want to Set text colour of the following( "SELECT, FROM, WHERE, GROUP BY, ORDER BY etc)