B4J + Access: query INSERT

LucaMs · Wednesday at 3:04 PM

Simple project, simple INSERT query. Works in Debug mode, doesn't work in Release mode and doesn't report any errors (I tried ExecNonQuery inside a try-block, both with and without a transaction).

Why in the Chit Chat forum? Because I guess the description above isn't enough for you to help me, so it's just to vent my nerves a little.

josejad · Wednesday at 3:52 PM

What about removing the try-catch block to see if it throws some error?

OliverA · Wednesday at 4:25 PM

If you are using UCanAccess, then do a ExecNonQuery("COMMIT;") after any INSERT/UPDATE and see if that resolves your problem.

LucaMs · Wednesday at 4:38 PM

josejad said:
What about removing the try-catch block to see if it throws some error?

No errors were and are not reported (neither with nor without Try-Catch block)

LucaMs · Wednesday at 4:39 PM

OliverA said:
If you are using UCanAccess, then do a ExecNonQuery("COMMIT;") after any INSERT/UPDATE and see if that resolves your problem.

I will try (very soon), thank you.

LucaMs · Wednesday at 4:46 PM

OliverA said:
If you are using UCanAccess, then do a ExecNonQuery("COMMIT;") after any INSERT/UPDATE and see if that resolves your problem.

Perfect, it worked (although I don't understand why it's only needed in Release mode; I wonder if a Sleep would have been enough, I haven't tried, since the query execution is a single synchronous statement).

rabbitBUSH · 2024-09-26T09:00:13+0100

OliverA said:
If you are using UCanAccess, then do a ExecNonQuery("COMMIT;")

MMMM that might solve a similar issue I have experienced recently - where it meant doing the SQL DB change twice to effect an update.

LucaMs said:
Why in the Chit Chat forum?

ChitChat solves some problems. Its like AI for B4X . . . .

aeric · 2024-09-26T09:14:00+0100

rabbitBUSH said:
ChitChat solves some problems. Its like AI for B4X . . . .

If your intention is to hide from the members search. This is not good for sharing great information to help anyone.

rabbitBUSH · 2024-09-26T17:29:47+0100

aeric said:
If your intention is to hide from the members search. This is not good for sharing great information to help anyone.

ah all in jest @aeric all in jest.....

B4J + Access: query INSERT

LucaMs

Expert

josejad

Expert

OliverA

Expert

LucaMs

Expert

LucaMs

Expert

LucaMs

Expert

rabbitBUSH

Well-Known Member

aeric

Expert

rabbitBUSH

Well-Known Member

B4J + Access: query INSERT

Expert

Expert

Expert

Expert

Expert

Expert

Well-Known Member

Expert

Well-Known Member

Privacy & Transparency

Privacy & Transparency