Store and Forward a prep-statement?

Ignition
1

If my database connection faulted would a prep-statement query be stored in cache till my connection is reestablished? I’, running this code on a global shared script if that makes any difference.

2

You would have to use runSFPrepUpdate(), and then it would be “yes”.

3

is it ok to assume that the store and forward will write into my database in the order my queries have been sent to SF?, because my sql table is set for auto increment.

4

Normally, I would say yes, but I don’t know what might happen with temporary error conditions. Consider including a timestamp in your row data so that there is no ambiguity no matter how long the delay might be.

1 Like