Dynamic 4gl question.
Environment: Dynamic 4gl V 2.1 S.O. Solaris 2.6 IDS 7.31.UC-1 When i use DEFINE record_variable_name RECORD LIKE TABLE_NAME.* i recive an error at compilation time. | fglcomp: The symbol "table-name" is not the name of a table in the specified database. How i can solve this? Thanks. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------
I am not sure if the code in your posting is the actual code you are trying to compile, but: 1. Of course, TABLE_NAME has to be the name of a table which actually exists in the database (cannot use a "dynamic" name). 2. If TABLE_NAME actually does exist in the database but you are still getting this error, then you probably do not have an updated schema file. Run fglschema on the database and make sure the schema file is in your directory or otherwise accessible. Hal Maner M Systems International, Inc. www.msystemsintl.com Isidre PONS ROCA <ipons@dtgna.altanet.org> wrote in message news:8fblmj$bge$1@news.xmission.com... > > Environment: > Dynamic 4gl V 2.1 > S.O. Solaris 2.6 > IDS 7.31.UC-1 > > When i use DEFINE record_variable_name RECORD LIKE TABLE_NAME.* i recive an error at compilation time. > | fglcomp: The symbol "table-name" is not the name of a table in the > specified database. > > How i can solve this? > > Thanks. > > > --------------------------------------- > Isidre PONS ROCA > BASE - Gesti' d'Ingressos Locals > (Diputacio de Tarragona) > Servei de Sistemes de Informacio > Av President Lluis Companys 12-C > 43005 - Tarragona > SPAIN > Tel # +34 977 236731 > Fax # +34 977 227302 > http://www.altanet.org > ipons@dtgna.altanet.org > ---------------------------------------
On Wed, 10 May 2000 14:20:08 +0200, Isidre PONS ROCA Wrote: > > Environment: > Dynamic 4gl V 2.1 > S.O. Solaris 2.6 > IDS 7.31.UC-1 > > When i use DEFINE record_variable_name RECORD LIKE TABLE_NAME.* i recive an error at compilation time. > | fglcomp: The symbol "table-name" is not the name of a table in the > specified database. > Have you specified the database at the top of the program with : DATABASE whatever At the top of the program ? /J\\
Isidre PONS ROCA wrote: > > Environment: > Dynamic 4gl V 2.1 > S.O. Solaris 2.6 > IDS 7.31.UC-1 > > When i use DEFINE record_variable_name RECORD LIKE TABLE_NAME.* i recive an error at compilation time. > | fglcomp: The symbol "table-name" is not the name of a table in the > specified database. > > How i can solve this? > > Thanks. > > --------------------------------------- > Isidre PONS ROCA > BASE - Gestió d'Ingressos Locals > (Diputacio de Tarragona) > Servei de Sistemes de Informacio > Av President Lluis Companys 12-C > 43005 - Tarragona > SPAIN > Tel # +34 977 236731 > Fax # +34 977 227302 > http://www.altanet.org > ipons@dtgna.altanet.org > --------------------------------------- Beside the possible problems already mentioned, it is possible that the D4GL-runner You use is not the one needed for Your Informix-Environment. When I installed 4js (which is the same as D4GL) it created a runner, for a 7.1x Informix-Environment, although I use SE 7.24 on my Linux-Box. Wolfgang
Isidre PONS ROCA wrote: > Environment: > Dynamic 4gl V 2.1 > S.O. Solaris 2.6 > IDS 7.31.UC-1 > > When i use DEFINE record_variable_name RECORD LIKE TABLE_NAME.* i recive an error at compilation time. > | fglcomp: The symbol "table-name" is not the name of a table in the > specified database. > > How i can solve this? > > Thanks. > > --------------------------------------- > Isidre PONS ROCA > BASE - Gestió d'Ingressos Locals > (Diputacio de Tarragona) > Servei de Sistemes de Informacio > Av President Lluis Companys 12-C > 43005 - Tarragona > SPAIN > Tel # +34 977 236731 > Fax # +34 977 227302 > http://www.altanet.org > ipons@dtgna.altanet.org > --------------------------------------- Assuming that your code was working with a previous version, then check the following. 1) Does the database you refer to exist. 2) If it exists does the table referred to exist on that database. 3) If so what are the access permissions for the database and the table in question, make sure that the user compiling the code has at least a read access permisions. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------
Jonathan Stowe <gellyfish@gellyfish.com> wrote > On Wed, 10 May 2000 14:20:08 +0200, Isidre PONS ROCA Wrote: > > > > Environment: > > Dynamic 4gl V 2.1 > > S.O. Solaris 2.6 > > IDS 7.31.UC-1 > > > > When i use DEFINE record_variable_name RECORD LIKE TABLE_NAME.* i recive an error at > > compilation time. > > | fglcomp: The symbol "table-name" is not the name of a table in the > > specified database. > > > > Have you specified the database at the top of the program with : > > DATABASE whatever > > At the top of the program ? > You also have to make sure that your environment is set up correctly so that you can see the database while you are compiling. I sometimes forget this, and try to compile when the relevant database is not visible (because my environment is pointing at some other server), or when I don't have permissions on the database. These result in the "...not the name of a table..." error. -- Andrew Pearson "exactly what the web needs less of".