• Welcome, Guest. Please login.
 
September 17, 2019, 10:23:16 am

News:

Welcome to the SQLitening support forums!


SQLitening Error Code -13

Started by Fim, February 11, 2017, 08:51:37 am

Previous topic - Next topic

Fim

CJ,
You inspired me to use other forms of JOIN.
This works ok:
SELECT * FROM VOR;
even this
SELECT * FROM MTR;
But with this, I get -13
SELECT * FROM VOR, MTR;
Is it an error in SQLitening or something else?
/Fim W
Fim W

Fim

* cannot be used with multiple tables, but the columns needed can be listed.
That solv the problem.
Thanks a lot.
/Fim W.
Fim W

cj

February 11, 2017, 12:55:39 pm #2 Last Edit: February 11, 2017, 01:01:45 pm by cj
Duplicate column names can be used.  Had to do some reading about the modchars of slSel.
slSel "SELECT * FROM VOR, MTR",0,"D"


'negative error codes are from SQLitening
'%SQLitening_InvalidColumnNameNumber = -13 - Invalid column name or number


slSel

ModChars: