Hot Topic (More than 10 Replies) @Xlistvalues (Read 1324 times)
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
@Xlistvalues
Jun 28th, 2006 at 12:18pm
Print Post Print Post  
Var Str1 as string
Var Str2 as string

Str1 = @Xlistvalues(@fn,"Assets!Asset_Number")
//Writeln(Str1)
Str2 = @PopupMenu(Str1, "Choose Asset Number")//This Line is not working?

I copied this code out of the programmer's guide page 88, a box pops up in the top right corner of the screen that says "Choose Asset Number" but I donot get the list of values. If I uncomment the Writeln, the slate pops up with the values.

I know I'm missing something simple, but what ??
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: @Xlistvalues
Reply #1 - Jun 28th, 2006 at 12:22pm
Print Post Print Post  
proudpoppy wrote on Jun 28th, 2006 at 12:18pm:
Var Str1 as string
Var Str2 as string

Str1 = @Xlistvalues(@fn,"Assets!Asset_Number")
//Writeln(Str1)
Asset_Number = @PopupMenu("Str1", "Choose Asset Number")// This line does not work?

I copied this code out of the programmer's guide page 88, a box pops up in the top right corner of the screen that says "Choose Asset Number" but I donot get the list of values. If I uncomment the Writeln, the slate pops up with the values.

I know I'm missing something simple, but what ??


The variable: Str1 should not be in double quotes. Try it this way:
Code
Select All
Asset_Number = @PopupMenu(Str1, "Choose Asset Number")
 


  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: @Xlistvalues
Reply #2 - Jun 28th, 2006 at 12:25pm
Print Post Print Post  
Still nothing.. Sad
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: @Xlistvalues
Reply #3 - Jun 28th, 2006 at 12:28pm
Print Post Print Post  
Uncomment the writeln that prints Str1. Also check @Error to see if your XListValues call is correct. Do you have "Assets!Asset_Number" in the current application?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: @Xlistvalues
Reply #4 - Jun 28th, 2006 at 12:43pm
Print Post Print Post  
Var Str1 as string
Var Str2 as string

Str1 = @Xlistvalues(@fn,"Assets!Asset_Number")
Writeln(Str1)
Str2 = @PopupMenu(Str1, "Choose Asset Number")
Writeln(Str2)

With the above code I get the little popup in the top right corner of the screen "Choose Asset Number"

Then I get two Writeln Windows with the values.
And Assets!Asset_Number is in this database, I have double checked all the spelling and element names.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: @Xlistvalues
Reply #5 - Jun 28th, 2006 at 12:54pm
Print Post Print Post  
Take a careful a look at the list of values in the writeln window. If the values are there and okay, there aren't very many other points of failure. Make sure they are properly separated and do not contain slashes or other special characters.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: @Xlistvalues
Reply #6 - Jun 28th, 2006 at 1:01pm
Print Post Print Post  
They all contain "-" dashes.... Angry
All 3000 of them !!
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: @Xlistvalues
Reply #7 - Jun 28th, 2006 at 1:22pm
Print Post Print Post  
I don't think dashes should be a problem. But a popup menu with 3000 items is almost certainly a problem.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: @Xlistvalues
Reply #8 - Jun 28th, 2006 at 1:32pm
Print Post Print Post  
I copied and pasted all the values into a combo box, Sesame slowed down to a crawl. I'll have to skin that cat a different way. Wink
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: @Xlistvalues
Reply #9 - Jun 28th, 2006 at 1:36pm
Print Post Print Post  
Dragging 3000 list items around is going to slow anything down pretty thoroughly.

Normally in this case, prefiltering the list by having the user type the first letter or two works pretty well. Would you like an example of this? If you get Inside Sesame, I wrote this technique up recently.

  

- 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: @Xlistvalues
Reply #10 - Jun 28th, 2006 at 1:41pm
Print Post Print Post  
Proudpoppy,

You probably know about the PopupSelectPosition( ) command, however I thought I would mention this just incase you overlooked its capabilities.

Adding

PopupSelectPosition(4, @XPos(YOUR ELEMENT), @YPos(YOUR ELEMENT) )

to your command will make your popup menu pop up from your triggering element so it will be more noticeable to the user.  

You could use the @elementname( ) command as part of the above to make  it work generically from any element it was called from. Check out page 200 & 201 in the 1.1 programming guide if you need to place the popup in other desired positions.

Best of luck with your project.  Smiley
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: @Xlistvalues
Reply #11 - Jun 28th, 2006 at 4:29pm
Print Post Print Post  
Hammer wrote on Jun 28th, 2006 at 1:36pm:
Dragging 3000 list items around is going to slow anything down pretty thoroughly.

Normally in this case, prefiltering the list by having the user type the first letter or two works pretty well. Would you like an example of this? If you get Inside Sesame, I wrote this technique up recently.



Yes I do get inside Sesame, I check out my recent issues.
Thanks
  
Back to top
 
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: @Xlistvalues
Reply #12 - Jun 28th, 2006 at 4:33pm
Print Post Print Post  
BOBSCOTT wrote on Jun 28th, 2006 at 1:41pm:
Proudpoppy,

You probably know about the PopupSelectPosition( ) command, however I thought I would mention this just incase you overlooked its capabilities.

Adding

PopupSelectPosition(4, @XPos(YOUR ELEMENT), @YPos(YOUR ELEMENT) )

to your command will make your popup menu pop up from your triggering element so it will be more noticeable to the user.  

You could use the @elementname( ) command as part of the above to make  it work generically from any element it was called from. Check out page 200 & 201 in the 1.1 programming guide if you need to place the popup in other desired positions.

Best of luck with your project.  Smiley


Thanks Bob
I did know about that command I was trying to get the @popupMenu to work before positioning the popup window. But any and all suggestions are appreciated !!
  
Back to top
 
IP Logged