Re: aace and Views

I've also updated the aace.lex to accommodate the leading "_"

On Mon, 22 Aug 2022, 07:35 Elier Tiapa, <[email protected]> wrote:

> 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
>

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