Skip to content

Instantly share code, notes, and snippets.

@theredpea
Created May 17, 2019 17:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save theredpea/acf9dc8fcb64bddc35f7bf0e898b78ee to your computer and use it in GitHub Desktop.
Save theredpea/acf9dc8fcb64bddc35f7bf0e898b78ee 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