Normal Topic OneSheets (Read 1175 times)
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
OneSheets
Sep 1st, 2004 at 9:07pm
Print Post Print Post  
Five new OneSheets posted at the Sesame Library!
http://www.lantica.com/Support/sesame_library.html

Entering A Program
@SelectTreeItem on a Command Button
Assign Next Number Using a Global Value
Assign Next Number Using @XLookupR
Check For A Unique Value
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: OneSheets
Reply #1 - Sep 2nd, 2004 at 1:45pm
Print Post Print Post  
Quote:
new OneSheets posted at the Sesame Library!
http://www.lantica.com/Support/sesame_library.html

Assign Next Number Using a Global Value
Assign Next Number Using @XLookupR


All the Sesame OneSheets are terrific, Thanks. Smiley

You keep giving us great options to accomplish similar tasks and unfortunately some of us do not have enough experience or knowledge to know what method to employ. So maybe we can pick the brains of the more experienced programmers.

Can you give us (once again) the pros and cons of using the different methods shown in the OneSheets to assign next number?

What method is best for what types of uses?

What is the downside to using one versus the other?

Thank you
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: OneSheets
Reply #2 - Sep 2nd, 2004 at 1:53pm
Print Post Print Post  
The Global Values method is going to be MUCH faster and is not subject to lookup errors. It works in Preview mode.

The @XLookupR method will guarantee that you get the next highest number without having to worry about bookkeeping, imported records or factors other than your programming that may change what the "next" number should be.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged