x Want to participate? Join the group to interact

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.

Databases and Operating Systems

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

murni

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.
- over 2 years ago
- Sage 300
- Databases and Operating Systems
Error HRESULT E_FAIL has been returned from a call to a COM component.

Fenny

i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…
- over 6 years ago
- Sage 300
- Databases and Operating Systems
get Field value in macro into a variable Vb.net.

Fenny

I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…
- Answered
- over 6 years ago
- Sage 300
- Databases and Operating Systems