Parametrs error execute query

Learn Academy Feedback
, , ,
1

Hello! I did this:
Build DT
0
Set this DT in parametrs for execute query

2
2700×205 2.85 KB

Use this parametr
1
1866×358 4.53 KB

But I have error: “Execute Query: The table type parameter ‘table’ must have a valid type name.”

What’s wrong?

2

@RPA3

Your table name @table is going as string and not variable/

3

I don’t understand. What change?
Help me, pleaseee

4

You are referencing a @table as string , this reference will not work.
@table is datatable in Uipath and not in your database. If you want to use it, either get datatable from database and compare it with your dt or else send your dt into database and use this query

5

I can get this DT from execute.
1

And what’s next?

6

Now you can use group by using linq query.

If you can help me with your query i can write it down for you.

Otherwise just for ex.

(from dr as datarow in dt where dr.item(“columnname”).tostring=“Example” select dr).copytodatatable

7

My DT from first query -DT1
My query - “USE " + SQLDB + " select firsrst, second,third from @table r group by r.third”

8

@RPA3

Instead of @table, Try with table only

Hope this helps

Thanks

9

Not work, Same error.
Could you share xml file with me, please?

10

Could you share with file or scrin, please?

11

@RPA3

Please share your xml. will amend changes to that.

12

test.xaml (5.8 KB)

13

Do you know it?

1 Like
14

@RPA3

I think, i don’t.

@supermanPunch can you help ?

15

@RPA3 Can you please explain what Output are you trying to get ? :sweat_smile:
What are you trying to do or What are the operations you have performed till now ?

What should this query do according to you ?

Thank you for tagging me in @Lakshay_Verma

1 Like
16

" first, second, third" - only for you.

17

I put my process

18

It does not matter. My request is correct. But I can’t connect them.

I get DT from the first request.

Next I want to add it to the second request

19

@RPA3 The reason I am asking this is to find another work around for your operation. And as far as I know, we cannot pass datatable type values into SQL query, we can pass other primitive variable types like String, Integer, Double, DateTime but I’m not sure if a Datatable is possible and hence you might be getting the Error “Execute Query: The table type parameter ‘table’ must have a valid type name”

20

What I can do?:frowning: