Hello,
The following piece of code goes thru RDS without any problems, but when
trying to compile with i4gl "c4gl", it treats the table names as records !!
Any clue why?
Thanks in advance
if flag = "u" then
declare c_colauth cursor for
select
syscolumns.colname,
|
| The variable "syscolumns" is not a record. It cannot reference
| record elements.
| See error number -4347.
syscolauth.colauth
from syscolauth, syscolumns, systables
where syscolauth.grantee = p_sysusers.username
and systables.tabname = pa_systabauth[idx].tabname
|
| The variable "systables" is not a record. It cannot reference
| record elements.
| See error number -4347.
the rest of the where clause snipped.
INFORMIX-4GL Version 4.12.UE1
INFORMIX-4GL Development System Version 4.12.UE1
INFORMIX-SQL Version 4.12.UE1
INFORMIX-OnLine Version 5.02.UC7
Ahmed.khafagy@washingtondc.attgis.com