Alpha Video Training
Results 1 to 4 of 4

Thread: Record List-List Box

  1. #1
    Member
    Real Name
    Steve Lippis
    Join Date
    Jun 2003
    Posts
    81

    Default Record List-List Box

    I'm using a record list-list box on a form to provide values to select from a table. One column displayed in the list box is numeric in the table and the other is a character, however, it appears that the list box treats the numeric field as a character in the list box when it sorts the entries. So instead of 1,2,3,10 I get 1,10,2,3. Is it possible to define a sort for the entries in the record list-list box? I did not see it in the properties.

    Thanks,
    Steve

  2. #2
    Alpha Software Employee Selwyn Rabins's Avatar
    Real Name
    Selwyn Rabins
    Join Date
    Mar 2000
    Location
    Boston, MA
    Posts
    5,306

    Default RE: Record List-List Box

    you have to create an expression for the column instead of referring to the field directly.

    e.g.

    padl(alltrim("" + quantity),10," ")

  3. #3
    Member
    Real Name
    Steve Lippis
    Join Date
    Jun 2003
    Posts
    81

    Default RE: Record List-List Box

    The value for the order_expression property for the list box (from the object explorer) is currently:
    keylist_build('H=.025,1:5[Loc #],2:15[Location]',"" + Locationid,""+Locationnumber,Locationdescription)

    If I understand correctly, I would develop an expression and replace the "+Locationnumber" (without quotes) as this is the field I would like to sort on. Is that the correct approach? Sorry if I'm missing the obvious, but this is new ground for me.

    Steve

  4. #4
    Member
    Real Name
    Steve Lippis
    Join Date
    Jun 2003
    Posts
    81

    Default RE: Record List-List Box

    Got it to work. Figured out the dropdown to select the field also will let you select an expression to enter. Selwyn, thanks again.
    Steve

Similar Threads

  1. scoll in record-list list box
    By davidv43 in forum Alpha Five Version 6
    Replies: 1
    Last Post: 10-31-2005, 02:55 PM
  2. Diff. between List & Record List Xdialog box?
    By Bob Pickle in forum Alpha Five Version 5
    Replies: 3
    Last Post: 12-21-2003, 10:52 AM
  3. X-Dialog Refresh Record-List List-Box
    By Louis Nickerson in forum Alpha Five Version 5
    Replies: 7
    Last Post: 02-20-2003, 08:11 AM
  4. useing a checkbox in a X dialog – record list-list
    By Daniel Weiss in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-09-2002, 02:49 PM
  5. Record List Object: list box problem
    By brett s in forum Alpha Five Version 5
    Replies: 9
    Last Post: 10-08-2002, 06:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •