I know this topic has been covered in General before but there are some things I am not sure about and i seem to be having a problem.
I want to get the details of a host structure in a COMPILED component. ARRAY LONGINT($tableNums;0) ARRAY TEXT($tableNames;0) Begin SQL SELECT TABLE_ID FROM _USER_TABLES INTO :$tableNums; SELECT TABLE_NAME FROM _USER_TABLES INTO :$tableNames; End SQL I know that code works inside the host database uncompiled and my reading suggested this is how i should be getting the structure in the component. However i am getting an error(just after this SQL. (error 1430) the variable does not exist. I was wondering if anyone could enlighten me where I am going wrong here. Thanks. Nigel Greenlee ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
