APPEON: Datawindow Error "success"

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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?

😎 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