Fastest lookup method

[osumatt]

I'm new to ACCPAC programming but I've been working off of examples I've found and I've been having success entering orders into ACCPAC through an external program (.NET) by using the ACCPAC .NET libraries.

The problem I am having deals with performance. I'm trying to verify the existence of an order. What is the fastest way to check if an order exists? Also, if I need to position to this order to modify information on it, what's the fastest way to do this? I think it's a combination of .Fetch, .Browse and .Order.

BTW, I've done a lookup through ACCPAC's UI and recorded a macro, but it didn't really clear things up for me.

 

[jayconverse]

.Order=1
.Browse "ORDNUMBER = " & sOrder, True
if .Fetch then ....


Jay Converse
IT Director
Systemlink, Inc.

 

[zemp]

Also, I would make sure that all view compositions are done and done properly.

zemp

 

[osumatt]

Thanks guys, I took both of your suggestions and it works great.

 

[jayconverse]

True, if you're updating. But if not, it's extra overhead.

Plus, if you're just verifying existence and not updating, then open the data link like this:

Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READONLY)

and you can pick up more speed.




Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

An alternate method:

.Order=1
.Fields("ORDNUMBER").PutWithoutverification sOrder
if .Read then ....

OR

if .Exists then .... (might be quicker than .Read, I have not checked the speed)