It will disappear if your query is wrong which is the most likely explanation here.
I would recommend using tables and not searching entire sheets. You can create tables in your excel file.
The query you were writing is essentially, Select ALL from Entire Excel Sheet.
It would look something like SELECT * FROM [TABLE NAME HERE]
Although I recommend being more precise as that doesn't really gain you anything since you can just select a table inside datalinq anyway.
A full query would look something like;
SELECT [COLUMN NAME HERE] FROM [TABLE NAME HERE] WHERE [COLUMN YOU WANT TO CHECK NAME HERE] = Value you want to check here.
An example would be;
SELECT [FIRST_NAME] FROM [HOME_ROSTER] WHERE [NUM] = %Jersey%
That would get you the first name from the home roster table where the number colomn equaled the value in the datalinqkey value.
It's in % here because its a datalinq key but you could just as easy write 11 eg;
SELECT [SECOND NAME] FROM [FOOTBALL TABLE] WHERE [JERSEY] = 11
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------
Original Message:
Sent: 07-29-2022 13:11
From: mark kundla
Subject: Xpression and SQL queries in datalinqs
Trying to create a Sequence for sports via the tutorial video. I can't seem to connect my excel after i type in the "Select *from ________ order by points.
In the space i typed in Home Team roster (the name of the excel file and Sheet1$ the name of the table. Both entries make the file disappear. My first thought was age of software. We have not updated in a while. GFX Artist on maternity leave can't find out last update but i'm guessing a year+.
------------------------------
mark kundla
Governors State University
------------------------------