select() function, query

11 次查看（过去 30 天）

Roman 2020-11-23

编辑： Walter Roberson 2023-2-7

Hello together,

for the following select query statement I get an error:

"select Algo_ID from egs_pn_algos where Algo_Version like '%1.0%' and Algo_hyperparameter like '%th:32;min_p_s:0.12;w_s:250%'"

The error is:

Error using database.jdbc.connection/select (line 78)

Invalid SQL statement. Expected a single SQL SELECT statement.

Error in DatabaseHandler/select_query (line 162)

data = select(obj.connection, query_str);

This query worked for me in sql developer.

What am I doing wrong

Roman 2020-11-23

Hello Rik.

you were right. I tried to avoid ';' and it worked perfectly.

Thanks for your quick help.

I encountered the same error message. I had sections of query commented with /* ... */ and by removing those it worked again.

Thanks for the tips.

MATLAB Language Fundamentals Data Types Numeric Types Logical

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

R2019b

Find the treasures in MATLAB Central and discover how the community can help you!

Translated by