Why is the image in the query not synchronized with the record?


I’m currently testing the possibility of replacing the image of a record using SQL script. Here’s my test:

  • Copy error.png and warn.png into <TRIRIGA_HOME>\userfiles\Company-1
  • Run the following SQL script:
    • update t_organization set TRIIMAGEIM = ‘//Company-1/error.png’ where triidtx = ‘1000568’;
    • commit;
  • Image of record has been changed to error.png in the form.
  • Run another SQL script:
    • update t_organization set TRIIMAGEIM = ‘//Company-1/warn.png’ where triidtx = ‘1000568’;
    • commit;
  • Image of record has been changed to warn.png in the form.

But in the query, nothing happened. Is the query component based on some kind of cache mechanism? Why is the query result not synchronized with the record in the database?

Try this and let me know if it works. Just rename your file to begin with “file_”. For example, rename the file to “file_warn.jpg”

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s