• Welcome, Guest. Please login.
 
August 04, 2020, 12:44:29 am

News:

Welcome to the SQLitening support forums!


Error -14 Invalid set number

Started by Marty Francom, July 07, 2011, 05:01:24 pm

Previous topic - Next topic

Marty Francom

I am getting a error  -14  that I am having trouble tracking down.  Occurs only occassionally.

What would be the most likely cause? 

What might be the best way track this error down?

Fred Meier

July 07, 2011, 08:12:39 pm #1 Last Edit: July 07, 2011, 08:21:16 pm by Fred Meier
Non zero set numbers must be closed or never have been used before it can be used in a slSel statement. A set number is automatically closed when you NextRow through all the rows or when your program ends.  You may explicitly close a set number by calling slCloseSet.  Set number zero is always automatically closed before each use.

If, for example, you are using set number 6 in the slSel statement that
fails then go backward in your code path and locate the previous slSel
that is also using set number 6 and check if the set closed.