Graphics

Hi everyone, Can I associate in a ODBC line to specific take ID? I have 20 lines of information in my ODBC file but they are not necessarily in an order of 1 to 20. Exemple: If I have 20 numbered jersey (7-12-30-45-etc ...) and I want that in my Xpression group, I want the take ID to be the same. These numbers can change quickly in my ODBC, so I do not want to change them manualy/constantly in Xpression. I have a column in my ODBC (let's call it Jersey) and I need to Xpression to link it to the same Take ID number.

For exemple, https://www.rossvideo.com/gallery/setting-up-xpression-datalinq/

But I want the take ID to be the jersey number, and not 1 to 20.
#XPression

No, you can't have the take id derived from the field in the ODBC.. You could create take ID's 0 to 100 in the sequencer, and each one would automatically select the correct row from the ODBC based on whatever the jersey number in the ODBC had. If you are using Fast Recall you could then just type in jersey numbers to recall the correct graphic. Since the rows in the ODBC aren't necessarily in order, the take item would need to be built with an SQL query to fetch the row that matches the take ID. Something like "SELECT * FROM ROSTER WHERE Jersey=%takeid%".
#XPression

Hi, this is a great idea. But I have already a SQL Query like this : SELECT * FROM vue_regie where Regie = 'E' order by Regie,Relid

How can I had your's to mine?
#XPression

I've try with and Excel file and it's not working... In my excel file, I've made a Jersey column, a Player name column. I've made a Table call ROSTER.

Like in this video. https://www.youtube.com/watch?time_continue=95&v=jFkx67taFmg

I've Datalink my excel. Test connect ok, Browse it. In my SQL query, I enter "SELECT * FROM ROSTER WHERE Jersey=%takeid%" and I cannot browse anything.

I've did something wrong?
#XPression

It's impossible to tell what you did wrong without seeing what you did.
Can you send a dropbox or google link to your scene and excel sheet, and your datalinq .dsc config file.

#XPression

Hi Brian, I've send u a private message with MFT info with all the files u ask. Thx!
#XPression