Re: error copy_statement_with_parameters from select

Thank you, I wasn't aware of that.
The A4GL_SQLTYPE was unixodbc. I've changed it in the aubitrc to pg8. 
This works well.

Thanks a lot,
Odo

On 25.01.22 16:31, Mike Aubury wrote:
> If you're using Postgres - you shouldnt be using ODBC.
>
> Whats your A4GL_SQLTYPE set to ?
>
> $ aubit-config A4GL_SQLTYPE
>
> should give what Aubit4GL thinks you are using...
>
> On Mon, 24 Jan 2022 at 10:24, Odo Benda <[email protected] 
> <mailto:[email protected]>> wrote:
>
>     Hello!
>
>     I'm struggling with simple select test case that produces an
>     copy_statement_with_parameters error.
>
>     Err:Program ./test_case_benu2 stopped at 'test_case_benu2.4gl', line
>     number 12.
>     Error status number -1.
>     Query buffer allocate error in copy_statement_with_parameters.
>
>     4gl function call stack :
>          MAIN
>
>
>     The code producing the error is:
>
>     DATABASE kfa
>
>
>     MAIN
>
>         DEFINE res RECORD LIKE benutzer.*
>
>         DEFINE u CHAR(8)
>
>         LET  u = "kfa"
>
>         SELECT * INTO res.*
>           FROM benutzer
>         WHERE username LIKE u
>
>         DISPLAY "code ", res.usercode
>         DISPLAY "DONE!"
>     END MAIN
>
>
>     The installation is unixodbc / postgres on centos 8.5
>
>
>     best regards, Odo
>
>
>
>     _______________________________________________
>     Aubit4gl-discuss mailing list
>     [email protected]
>     <mailto:[email protected]>
>     https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

-- 
Odo Benda
Fon: +43 316 835359 76, E-mail: [email protected]
AIT Forschungsgesellschaft mbH
Klosterwiesgasse 32/II, A-8010 Graz

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