Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Use Browse() with "NOT IN" where clause/filter

Posted By murni over 2 years ago

Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.

Top Replies

Jay Converse Acumen over 2 years ago in reply to murni +1

It means it moves forward from whatever position it's at. FWIW, 100% of the time I use 1, I've never had good luck using 0.

Parents

0 Jay Converse Acumen over 2 years ago

Use the CS0120 view and you can use regular SQL syntax.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 murni over 2 years ago in reply to Jay Converse Acumen

alright noted. One more question, in Browse(Filter, ascending=1), "ascending" will order by which field? if I specify the order in the filter string, will "ascending" be ignored?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 2 years ago in reply to murni

It means it moves forward from whatever position it's at. FWIW, 100% of the time I use 1, I've never had good luck using 0.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jay Converse Acumen over 2 years ago in reply to murni

It means it moves forward from whatever position it's at. FWIW, 100% of the time I use 1, I've never had good luck using 0.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 300

Use Browse() with "NOT IN" where clause/filter

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING