Returning a SQL table query with pymssql

Anvil Q&A
6

Okay, I managed to print the results for my server uplink using a variable.

varGet = anvil.server.call(‘get_sql_data’)
print(varGet)

Here’s what it’s returning with no errors:

image
image462×599 13.6 KB

It’s a simple table I made with ID (int), User_Name (nvarchar(50)), Date_Of_Birth (datetime), and Score (int) columns.

I also read in the documentation you linked that a repeating panels item property needs to be set to an iterable. However, when I select the component I see an item property but it says Set at runtime and cannot be interacted with.