Re: aace and Views

Hello,

After some tests, the issue was not the view, is the use of the "_" at the
beginning of the view or table name:

1. Create table
   create table _test (a integer);

2. Program test.ace:
   database dbtest end
   select a from _test
   end

3. Compile:
   aace test.ace

4. Error file test.err:
   database dbtest end
   select a from _test
   |________________^
   | Error at line 1, character 18
   | from does not exist in the database (test)
   end

5. Problem?:
   The "_" doesn't seem to be recognized.
   The error was avoided by creating a synonym for the _test table called
ttest

6. Versions used:
   Database: Informix 14
   OS: Linux UBUNTU 18
   AACE: 1.5


Thanks!

Elier


On Thu, Aug 18, 2022 at 4:50 PM Mike Aubury <[email protected]> wrote:

> Can you create a fully worked example for me to test with ?
>
> On Thu, 18 Aug 2022 at 15:48, Peter Schubert SACO GmbH <[email protected]>
> wrote:
>
>>
>> Hi,
>>
>> i get an error if i select from views.
>>
>> | , does not exist in the database
>>
>> i use Informix,
>> Looks like "A4GLSQL_get_columns" can not process views ?
>>
>> Thanks
>>
>> Peter
>>
>>
>> SACO Software and Consulting GmbH, Mühlgasse 5, D-97840 Hafenlohr
>> Tel.: ++49 9391 90890-0, E-Mail: [email protected]
>> Amtsgericht Würzburg HRB 5410, Geschäftsführer: Peter Schubert,
>> Dipl.-Wirt.ing.(FH) Thorsten Beck
>>
>>
>>
>> _______________________________________________
>> Aubit4gl-discuss mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>>
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss