Copy a row from Table A to position 0 in Table B

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • dave@softwareonline.com

    Copy a row from Table A to position 0 in Table B

    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

Working...