REV_SQL broken in ver 3.6.1 & 3.7 (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 16 FEB 1999 03:25:46PM Steven Ickman wrote:

OpenInsight Specific

The following SQL select statement passed to the REV_SQL routine works fine in OI ver 3.3 & 3.5 but returns an error code -302 after upgrading to ver 3.6.1 or 3.7:

SELECT * FROM STOCK

(Selects all the records from the EXAMPLES applications STOCK table)

Error code -302 translates to SQL_TABLE_MISSING_ERR$ * General File Open Failure

Looking at the readme for 3.6.1 states that there were changes made to the OPEN statement. Could this be the cause? If so are there any SYSOBJ files I can safely pull from ver 3.5 and install in 3.6.1 & 3.7 to fix this problem?

Steven Ickman

sickman@com2001.com

At 16 FEB 1999 04:50PM Cameron Revelation wrote:

Hi Steven,

This was a regression that has been fixed for 3.8. I do not know whether there will be a patch before then.

Cameron Purdy

Revelation Software

View this thread on the forum...