Graphics

Hello,

I am looking for a comand that can force the text object or scene to gather the latest datalinq fields. I expected it to work by using the Self.RefreshDatalinqs() in the OnBeforeOnline or OnOnline, but I do not see it working the way I expect.

Anyone know if there is another way to go about this? Also, what is the refreshDatalinqs meant to do? In the API it is blank.

Regards,
Mike

Text objects automatically refresh their datalinq values when the scene is going online anyway; so adding that function to OnOnline or OnBeforeOnline will be redundant.
#XPression

Thanks Brian, but when I test this I do not see it using the newest text when I take the scene live. To test this I have datalinq set up to update every 30 seconds. Then I update the field and take the scene online. It is shows the previous text at first and then text updates while scene is online, at its defined interval. Is it for newer versions that it always refreshes datalinq ononline? We are 6.1 build 3437
Also still curious what does refreshdatalinq do?

The problem I am trying to solve is we have a SQL table row that will update as soon as the scene gets put online. I need to make sure it grabs that new text, not showing the old and then switching to the new while on air.

Thanks for your help.
Mike
#XPression

To better answer your question can you provide screenshots of all the tabs in datalinq configuration. Depending on which datalinq type (ADODB, etc) you are using and whether it is set for "fixed table" and "asynchronous refresh" the answer can be different.

Normally however as soon as the scene enters the "preparing" stage it will request updated datalinq values. If you are using recent software; there is an option in the ADODB datalinq to log the queries, so you could see in the datalinq server log window when it is performing the SQL queries.

RefreshDatalinqs api call will simply tell the text object to asynchronously query the datalinq server for it's most recent data. It will NOT tell the datalinq server to go a re-query the database.

#XPression

Thanks Brian, that last point was what I was missing. The text object was refreshing data from datalinq which was correct. It was datalinq that hadnt gotten latest data from the SQL DB.
I will find another way to go about this.

Thank you for your help.
#XPression

Confirm you don't have the "fixed table" option turned on in the datalinq config?
#XPression

On a similar note, here is my question. If I set the refresh interval on a RSS datalinq to 0, (reason is I don't want to be rate limited by the provider), will datalinq query the server for new data when I call the message up in sequencer? Or do I HAVE to set some query interval to poll the server?
#XPression

You must set a polling interval for the RSS linq.
#XPression

I'm not sure I see a solution to my problem here; if we already have a template online and want it to live update (data from a spreadsheet, not RSS feed - the operator enters new values and saves it), how can we make that happen? I see we can tell it to update every "X" seconds, but that seems wasteful if we'll only need to do it once just before going on air. The idea was to have a hot-key configured to run a script to do the work we wanted, if we could precede it with an api call to force an update, that would work great, but we need to know the update is finished before proceeding.

#XPression