Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook



The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic

Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.

If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.

Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.

Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Variable Array in Combo-List Box???

  • Filter
  • Time
  • Show
Clear All
new posts

    Variable Array in Combo-List Box???


    Does anyone know how to display an array of memory variables in a combo or list box on a form? I want to create a form where a user can map fields in the current active table to global memory variables.

    When I import a user table, it could have the address field named [ADDRESS]; or [STREET]; or [ADDR1] etc. My application is set up to do specific things to an address field�s contents, but in order to do that, it needs to know in what field the address information is stored. (The same is true of several other typical fields and data found in most tables and mailing lists; like: first name, last name city, state, ZIP and so forth.)

    I currently have a global memory variable array called �FIELDS[1024]�, which lists the �working� table�s field names. Currently, I�m having to put the global memory variable for a given field (address = �M_ADD�) on my form with a button next to it that, which when pressed, pops up a UI_GET_LIST_ARRAY() box, displaying the fields list from which to select. Once selected, the field name appears on the form, in the M_ADD field, along with its type and length.

    I would like to have a series of drop-down combo boxes that when dropped would display the field names available and let him-her select directly from it. Once selected by the user, that field name would be copied to the �M_ADD� memory variable, for display purposes and for use in my address-specific scripts throughout the rest of the application�s current session � unless intentionally re-mapped by the user, of course.

    Is this even possible? I tried using a �normal� combo-listbox control, but it doesn�t list any arrays in the available variables window when I�m asked to select a field and won�t work (Error message) if I try to type it in later�


    Geoff Hollander

    RE: Variable Array in Combo-List Box???

    Geoff, prehaps the ui_get_list_array() dialog will help.

    -- tom


      RE: Variable Array in Combo-List Box???


      I'm doing that now, launching it from a button on the form, and it works OK. Once chosen, the field name etc. appear in the memory variable fields displayed on the form.

      I was hoping to make theis part of my application look more professional and save the user 2-4 additonal clicks by utilizing a dropdown list that would both offer the fields choice, load the selection into the apopropriate memory variable and then display it, and its relevent information when finished. (Keep in mind that this program will typically require the user to map anywhere from 4 to 25 fileds, depending on how many different data processing operations are run.)

      I take it that there is currently no way to do this now, other than the dialog you suggested. (I think it can be done in version 5 using the new XBasic Dialog Builder code.) Thanks for the help.

      Best regards,

      Geoff Hollander


        RE: Variable Array in Combo-List Box???

        I'm sure I don't understand all the nuances of what you are doing, but could you do something like this? Create a separate work table that is initialized for a user upon starting the process for a particular work table. The table would have a record for each field with fields like field_name,fiedl_type and field_size. Upon initializing this work table, populate it with one record per field for the current working table. Your lookups could be based on this table.


          RE: Variable Array in Combo-List Box???


          Thanks -I think that that's a very viable option. In fact, I was thinking of using that same technique to possibly create a a user-saved table of re-callable queries and perhaps settings. This would work the same way. Hmmmm...

          I guess that this kind of thing will be neccessary in Alpha Five as long as forms must be tied to tables. The new XBasic dialog language should free us from that constraint.

          Again, thanks. It will be awhile before I can try it out, but will let you know when I do.

          Best regards,

          Geoff Hollander