Unanswered

Error ejecutar instruccion SQL

(0) Share

Report

Posted on by Power24

Tengo un problema a la hora de ejecutar una instrucción de SQL.

ESCOGER Peticionarios.Peticionario, Peticionarios.Tipo, Peticionarios.ID
FROM Peticionarios
WHERE (Peticionarios.ID=%NIF%);

Es bastante sencilla, pero el error que aparece es esto:

"Error en la instrucción SQL. No se han especificado valores para algunos de los parámetros requeridos".

No sé por qué sale este error, alguien me podría decir dónde está el error?. Gracias

Un saludo

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Power24

Could you please share some screenshot of execute sql statement action?

And also confirm %NIF% is your variable or its a like query?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Power24 4 on at

Like (0)

Report
Copy link

Link copied!

Hola

es una Variable

Was this reply helpful? Yes No
Power24 4 on at

Like (0)

Report
Copy link

Link copied!

Hola,

Te envío el mensaje se excepción que aparece:

Id. de correlación: d924b8a6-f596-454a-add1-0115161eebb5
No se han especificado valores para algunos de los parámetros requeridos.: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Error en la instrucción SQL No se han especificado valores para algunos de los parámetros requeridos. ---> System.Data.OleDb.OleDbException: No se han especificado valores para algunos de los parámetros requeridos.
en System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
en System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
en System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
en System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
en System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
en Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.DatabaseActions.ExecuteSQLStatement(Variant connectionString, Variant sqlConnectionVariable, Variant sqlCommand, Variant& result, Int32 timeout, Int32 getConnection)
--- Fin del seguimiento de la pila de la excepción interna ---
en Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.ExecuteSqlStatement.Execute(ActionContext context)
en Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Gracias

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Power24

Please follow the below syntax for variables:
SELECT Peticionarios.Peticionario, Peticionarios.Tipo, Peticionarios.ID
FROM Peticionarios
WHERE (Peticionarios.ID='%NIF%');

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Power24

Could you please run your same query in sql and share the results pls(remove NIF variable and apply some value directly)?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No