Logo SQLinForm

 

Line numbers

Line numbers
July 07, 2016 08:13PM
I am using Pascal String output. How can I remove the line numbers that is embedded in the output?

INPUT:
Select *
from test_table
where column_a ='Active'


Current OUTPUT:
SQL := ''
+'001 SELECT * '
+'002 FROM test_table '
+'003 WHERE column_a ='Active'';


Desired OUTPUT:
SQL := ''
+'SELECT * '
+'FROM test_table '
+'WHERE column_a ='Active'';
Re: Line numbers
July 07, 2016 11:47PM
Hi FIDO,
thanks for your feedback.

Could you please check in the "SQL Output" section if the "Show Line Number" option is not checked.

Regards
Guido
Re: Line numbers
July 08, 2016 11:14PM
I do not see "Show Line Number" anywhere in the "output SQL" section. I am on SQLFormPro_Desktop_2014September.jar version.
Re: Line numbers
July 09, 2016 05:55PM
In the SQLFormPro_Desktop_2014September.jar version the option is here
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 2 plus 5?
Message: