Normal Topic @xlistvalues (Read 299 times)
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
@xlistvalues
Oct 19th, 2011 at 11:19pm
Print Post Print Post  
This is my code. 

var str1 as string

var str2 as string

if @add

str1= @xlistvalues("c:\sesame2\data\pacific coast fruit products.db","contacts!master!name")
str1 = @sortstringArray(str1,0)
str2= @popupMenu(str1,"Customer List")
  writeLn(str2)

Contacts is the database within the application and master is the form and name is the field.  I have multiple data bases in a "main" application.  Both data bases are in the same application
THe popup menu shows up at add but it is completely blank.  Not even my header is there.
  
Back to top
 
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: @xlistvalues
Reply #1 - Oct 20th, 2011 at 12:49am
Print Post Print Post  
Hi debmckee,

Try taking the "Contacts" database out so it looks like this;  form name equals master, and LE equals name.

str1= @xlistvalues("c:\sesame2\data\pacific coast fruit products.db","master!name")

You can try the code this way:

Code
Select All
var str1 as string
var str2 as string

If @mode() = 0
{
str1= @xlistvalues("c:\sesame2\data\pacific coast fruit products.db","master!name")
str1 = @sortstringArray(str1,0)
str2= @popupMenu(str1,"Customer List")
  writeLn(str2)
} 



Also, you may want to try; str2= @PopupChoiceList(str1, "Customer List") instead of @popupmenu. It's much nicer!

Brandon
« Last Edit: Oct 20th, 2011 at 11:24am by tcgeo »  
Back to top
IP Logged