(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › @Number & Picklist
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic @Number & Picklist (Read 465 times)
Marine8
Member
*
Offline



Posts: 1
Location: Suwanee,GA
Joined: Jul 21st, 2007
@Number & Picklist
May 23rd, 2008 at 3:12am
Print Post Print Post  
I have two questions. Can you reset @number in sesame similar to the way it was done in Q&A ?  And the second one is I am trying to get a picklist popup in a customer field that list all the customers from the CURRENT database that you are working in.  Also, if you enter a new name in the customer field that is not in the picklist, it will add it to your picklist.  I just recently started using Sesame and I see it offers numerous ways to do picklist looking up in a EXTERNAL database, but I haven't seen much on looking up in the CURRENT database that you are working in.  Any help would be appreciated.
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: @Number & Picklist
Reply #1 - May 23rd, 2008 at 4:41am
Print Post Print Post  
@Number reset is done in SDesigner through Application Property Manager.

Your second question as to Popup Customer List, Please look into following code entered in On Element Entry Event:

Code
Select All
var vList as string

vList = @XListValues(@Fn, "Customer!CustomerName")
vList = @SortStringArray(vList, 0)	// 0 = ASCII sort, 1 = Number sort
vList = @UniqueStringArray(vList)	// Removes duplicates
CustomerName = @PopupMenu (vList, "Customer List")
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: @Number & Picklist
Reply #2 - May 23rd, 2008 at 12:23pm
Print Post Print Post  
Quote:
I just recently started using Sesame and I see it offers numerous ways to do picklist looking up in a EXTERNAL database, but I haven't seen much on looking up in the CURRENT database that you are working in.

As with Q&A, if you specify @Filename or @FN, Sesame will look in the current application.

Quote:
Also, if you enter a new name in the customer field that is not in the picklist, it will add it to your picklist.

To add a new record to the Customer database, you can use the XResultSet commands. There is an example of doing this on the Main Menu of the sample application attached to this post.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge