Hi BluePrismian,
I would to insert in a single query a whole collection like a table without doing a loop because it is very slow.
I'm try with an insert with nested select like:
insert into Table (a,b)
values (select collection.element from collection, 'number');
I obviously wrote it this way:
"insert into Table (a,b)
values (select"& [collection.element]&" from "&[collection]&", ' "&[ number]&" ');"
but don't works.
a is a text b is a number. a is a value takes from collection (save in BP) and b is a static number eguals for all the rows.
Thanks for all the support and any help will be very appreciate.
I would to insert in a single query a whole collection like a table without doing a loop because it is very slow.
I'm try with an insert with nested select like:
insert into Table (a,b)
values (select collection.element from collection, 'number');
I obviously wrote it this way:
"insert into Table (a,b)
values (select"& [collection.element]&" from "&[collection]&", ' "&[ number]&" ');"
but don't works.
a is a text b is a number. a is a value takes from collection (save in BP) and b is a static number eguals for all the rows.
Thanks for all the support and any help will be very appreciate.