I've tried various things for the last two hours, and I give up! What
I really need is ImportRowAt(), and it would solve my issue, but since
that doesn't exist:
I have two tables with identical schema. I run through TableB and if
I find a row that matches my criteria, I want to insert it as the
FIRST row of TableA, which already contains items.
If I could clone the row, it'd meet my needs. If I could InsertAt(0)
without the "row is already in another table error", it'd meet my
needs.
Any help would be appreciated... so far I've seen a TON of posts on
this very issue, but they never get resolved, so I'm not the first to
hit this, but those who solve it don't report back :-)
....so, any of these three will work:
1) Create a true clone of the row from TableB that I am free to
InsertAt(0) into TableA
2) ImportRow into TableA, then swap it within TableB (from the end of
the table to the start)
3) Accomplish what ImportAt() would if such a method existed
Thanks,
Dave
I really need is ImportRowAt(), and it would solve my issue, but since
that doesn't exist:
I have two tables with identical schema. I run through TableB and if
I find a row that matches my criteria, I want to insert it as the
FIRST row of TableA, which already contains items.
If I could clone the row, it'd meet my needs. If I could InsertAt(0)
without the "row is already in another table error", it'd meet my
needs.
Any help would be appreciated... so far I've seen a TON of posts on
this very issue, but they never get resolved, so I'm not the first to
hit this, but those who solve it don't report back :-)
....so, any of these three will work:
1) Create a true clone of the row from TableB that I am free to
InsertAt(0) into TableA
2) ImportRow into TableA, then swap it within TableB (from the end of
the table to the start)
3) Accomplish what ImportAt() would if such a method existed
Thanks,
Dave