enoying "line return" while concatenating SQL string
Posted: Tue Jan 19, 2021 10:14 am
Hi guys,
Dealing with Sqlite queries...
I'm trying to get rid of some enoying "line return" while concatenating a string of 3 parameters.
Somehow, with the 3rd param adding, the results is sent to the next line, breaking the string...
(I had no such breaking under Manjaro but now testing the function under Zorin pose this problem, dont think its an OS issue though)
Does anyone know how to impeed unwanted line return and keep all the whole data line happy together ?
is there some extra symbol to impeed line returns or another setting to modify ?
* any reliable methods to buid such string is welcomed
*as displayed in the field/content window properties
Expected results : (for tcriterm to be passed to tSQL)
Dealing with Sqlite queries...
I'm trying to get rid of some enoying "line return" while concatenating a string of 3 parameters.
Somehow, with the 3rd param adding, the results is sent to the next line, breaking the string...
(I had no such breaking under Manjaro but now testing the function under Zorin pose this problem, dont think its an OS issue though)
Does anyone know how to impeed unwanted line return and keep all the whole data line happy together ?
Code: Select all
put "'" into tcritera
put field fcritex after tcritera # (fcritex input : 66)
put "%'" into tcriterb
put tcriterb after tcritera
put tcritera into tcriterm
* any reliable methods to buid such string is welcomed
Code: Select all
SELECT * FROM users WHERE userID LIKE '66
%';
*as displayed in the field/content window properties
Expected results : (for tcriterm to be passed to tSQL)
Code: Select all
SELECT * FROM users WHERE userID LIKE '66%';