You are viewing limited content. For full access, please sign in.

Question

Question

SQL query Question

asked on April 20, 2015

We're directly calling the LF DB in SQL and we were able to get the Query working but we're j looking for more details on the toc_flags column in the Toc table.  We were getting duplicate results until we added the following to our stored procedure, 'select tocid from toc where toc_flags & 0x800 = 0'.  Just wondering what this flag represents and if this is the best way to only return the latest version.

0 0

Answer

SELECTED ANSWER
replied on April 20, 2015 Show version history

Hi Brandon,

That select statement checks to see if an entry is in the recycle bin or not.

-Ben

2 0

Replies

replied on April 20, 2015

That's what we were figuring, thanks for the clarification.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.