Skip to Content
avatar image
Former Member

APPEON: Datawindow Error "success"

Hi,

I get this error with appeon mobile:

I use a SQLite Datbase.

The datawindow has a dddw with a retrieval argument.

The error accurse when I retrieve the dddw in the constructor event.

An other dddw with retrieval argument in the same datawindow works.

The datawindow runs fine as PowerBuilder App but it fails with Appeon mobile.

Has anyone experienced this too?

Any suggestion?

TIA Ludwin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 02, 2015 at 01:20 PM

    Hello,

    It seems like there is a problem with PB generated SQL syntax.

    What we have done:

    In the database painter switch to syntax and removed all the qoutes on tables and attributes ("test"."test" = test.test) and we removed all brackets from the where clause too.

    That solved the problem for us 😊

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Valetin;

        Sounds like you did not let the DW handle the SQL but  hard coded it by selecting the "Convert to Syntax" mode in the DW's SQL painter. Once you do that - yes, you are "on your own" as far as SQL compatibility. The DWO will no longer try to align the SQL syntax for you - even when you move to newer versions of SQLite.

      Regards ... Chris

  • avatar image
    Former Member
    Oct 26, 2015 at 04:22 PM

    Hi Ludwin;

      Can you tell us ...

    1) Appeon version & build

    2) Mobile device & O/S being used

    3) SQLite version?

    4) Are you testing the native PB application using SQLite?

    5) What version of PB & build are you using?

    6) Your error dialog is very vague. Can you tell us the DBError Code encountered?

    7) What SQLite DBMS connectivity mechanism are you using?

    8) Anything suspicious in the Appeon logs?

    Suggestions:

    a) Have you tried the DDDW retrieve in a "Post Constructor" event instead?

    FWIW: I have never encountered this situation.

    Regards ... Chris

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 06:46 AM

    Hi Ludwin,

    Please help to provide us the information listed above by Chris (especially the first one: 1) Appeon version & build) and a simple PB case (including the SQLite DB file) to reproduce this issue. Please send the test case to support@appeon.com. Thanks

    .

    Regards,

    Appeon Support Team

    Add comment
    10|10000 characters needed characters exceeded