Calling Postgres function from tDBRow

[EMeany]

Hello, 

I am having trouble calling a Postgres function from tDBRow.

I can call it successfully from SQL Builder (verified using DBeaver), but the generated query fails to work when used within the tDBRow component.

By 'fails' I mean that the expected results are not observed within my DB (I observe no change). However, the Job itself executes without error.

Any ideas?

Thanks

E

[fdenis]

what is your query.
did you check your db connection? is it the same?

[EMeany · Accepted solution]

Thank you for the response fdenis.

It appears that the SQL Builder defaults to auto-commit, whereas the tDBRow's connection (tDBConnection) does not.  

After selecting the auto-commit checkbox in tDBConnection's advanced tab, the function call works without issue.

Thanks again for your time.

E