Skip to content

Instantly share code, notes, and snippets.

@theredpea
Created May 17, 2019 17:57
Show Gist options
  • Save theredpea/39b825e0a24d8b4b0216d872439902c3 to your computer and use it in GitHub Desktop.
Save theredpea/39b825e0a24d8b4b0216d872439902c3 to your computer and use it in GitHub Desktop.

Load this data:

LOAD DUAL(t,n) INLINE [ t,n A,1 B,2 C,3];

Select "A", create a bookmark

Now load this data:

LOAD DUAL(t,n) INLINE [ t,n A,2 B,3 C,4];

Try to apply the bookmark "A"; it doesn't work, because bookmark "A" tracked qNum at the time the bookmark was created; 1 now the qNum col does not contain the value for '1'; even though "A" exists; no selection

Now load this data:

LOAD DUAL(t,n) INLINE [ t,n A,0 B,1 C,2];

Try to apply bookmark "A"; it selects "B" now the qNum col containing the value 2, is for "B"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment