4gl/Windows problem with temporary tables
After having my hand slapped by Kerry Sainsbury for showing bad "Net Manners"
I would like ask if anyone is having problems with temporary tables in
4GL/Windows.
Software versions are: 4GL/WIN 4.20.WD1, I-NET 5.01 and ONLINE 4.11.UC1.
The following highlights the problem generated by the compiler:
|
|e:\\tmp\\play.err - created from e:\\tmp\\play.4gl by FGLC
|
DATABASE editsys
MAIN
DEFINE p_tmp_report RECORD
test_id SMALLINT END RECORD
CREATE TEMP TABLE tmp_report
(test_id SMALLINT)
SELECT *
INTO p_tmp_report.*
FROM tmp_report
WHERE tmp_report.test_id = 1234
UPDATE tmp_report
SET tmp_report.* = (p_tmp_report.*)
|
| The symbol "tmp_report" is not the name of a table in the
| specified database.
| See error number -4320.
|
| The number of columns must match the number of values
| in the SET clause of an UPDATE statement.
| See error number -4464.
WHERE tmp_report.test_id = p_tmp_report.test_id
END MAIN
I know this does nothing, but it highlights the problem.
Any thoughts would be appreciated.
Thanks
Stu