SELECT Studio and Acess

Help Robot
,
1

In the studio, I’m trying to perform a SELECT on a specific field in a table. I need to retrieve the value of this field to then increment it and perform an UPDATE on the database with the number of business and systems. However, every time I run the SELECT, it returns 0. When I run the same query directly in Access, it works correctly and returns the expected value.

The image shows a SQL query string being constructed dynamically using variables in a code editor, with the query selecting columns from the ProcessingRequests table based on a specific IDOrder. (Captioned by AI)
The image shows a SQL query string being constructed dynamically using variables in a code editor, with the query selecting columns from the ProcessingRequests table based on a specific IDOrder. (Captioned by AI)807×296 3.78 KB

2

@marcella

Can you try to using this in log message and check how the query looks…

May be it is not same as what you are usinng on access directly

Cheers

2 Likes
3

Hello

Use breakpoints and Locals panel to check if your variables have the desired (correct) value.

Regards
Soren

2 Likes
4

I was using the wrong activity; I used ExecuteNonQuery (Run command) but should have used ExecuteQuery (Run query). It works correctly with ExecuteQuery (Run query).

This image displays a sequence workflow with steps to run a query and a command, both requiring connection configuration and containing error indicators. (Captioned by AI)

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.