Re: 4gl/Windows problem with temporary tables
In article <3k21co$1n1@cssun.mathcs.emory.edu>,
alan@po.den.mmc.com (Alan Popiel) wrote:
> }
> } 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:
<snip>
> } 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.
Is this valid syntax (sorry, I'm at home so am manual-less)? Maybe it's
an ANSI-ism?
Isn't the tablename kinda redundant (you can't update two tables at once).
Shouldn't you:
UPDATE tmp_report SET * = p_tmp_report.*
Actually, that's a *REALLY* ugly construction. Use of the asterisk will
come back to haunt you!
Use: UPDATE tmp_report SET test_id = p_tmp_report.test_id
Regards,
Kerry S
--------------------------------------,-------------------------------------
Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ
Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/*
| mathcs.emory.edu:/pub/informix/faq/*
+64 9 377-4473 (work) 266-6011 (home) | http://www.garpac.com/informix.html