------------------------------------------------------------------------------------------
Split from Can't run SQL query from script.

Hello could it be that serial is a integer field in your columns and not a varchar field?

Do you see the record on sql server management studio? Sorry i dont speak italian so i used automatic page translation to understand your question.

Gdim93

Hello could it be that serial is a integer field in your columns and not a varchar field?

Do you see the record on sql server management studio? Sorry i dont speak italian so i used automatic page translation to understand your question.

WSTRING#'SQL READ Error = -2147217900 Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Il nome di colonna $'AAA3333333333$' non è valido.'

Hi,
From your post, it looks like you are using MS SQL.

In your script, you look for the serial number with the "LIKE" expression.
If you look in the Microsoft help:
https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver16

then it shows that you must use single quotes like this:

SELECT * FROM table WHERE seriale Like '%AAA3333333333%'

The above will find all serial numbers containing the text "AAA3333333333".
You can change it to 'AAA3333333333%' if you want it to search for serial numbers starting with this text.

So change your "SELECT ..." linie to look like this:
 

Comm_Ricer_seriale = "SELECT * FROM " & Tabella & " WHERE seriale Like '%" & Seriale_da_Cercare & "%'"

I hope this helps