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

Announcement

Collapse

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

Posting to another Database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Posting to another Database

    I have a table which records a payment and I want the payment number to be posted to the invoice table.

    Shouldn't present a problem I know, but all it does is record a 0 on the invoice table instead of the payment number. I have checked it over and over, the linking keys are the invoice number on both tables and the payment number is a numerical field 5 digits long on both tables. I can't fathom why it doesn't work. Any clues please.

    #2
    Re: Posting to another Database

    Judith,
    First, in Alpha since at least v5 a database is a collection of tables....I "think" you are simply referring to a single database and different tables--correct me if incorrect.

    If above is true, make certain that the links are correct and actually are present....make sure they are of the same number of characters as well in the table structure and if not, use alltrim if character fields when comparing/change to be same if numeric.

    In addition, if you are certain that the value is not 0, then it usually means that something did not get resolved (an error will many times produce a 0 result).

    More info/sample illustrating would be the next step..... :)
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________



    Comment


      #3
      Re: Posting to another Database

      Hi Mike,

      Yes this is a single database with several tables and the posting takes place when a payment is recorded in the payments table the payment reference number should be posted to a numerical field on the invoice table. The tables are linked by a numerical field (the invoice number).

      Comment


        #4
        Re: Posting to another Database

        What's the data type of the "payment reference number" in the payments table? You're not trying to post a "character" value into a "numerical" field are you?

        Comment


          #5
          Re: Posting to another Database

          No Tom, it's a numerical field in both tables

          Comment


            #6
            Re: Posting to another Database

            Ok. As others have suggested it's time to post a zipped copy of the database, with instructions for us to follow in order to see the "mis"-posting.

            Comment


              #7
              Re: Posting to another Database

              Hi Tom,

              Thank you so much for all your help. I have added more fields to my invoice table in the hope it solves the posting problem. As you say maybe posting each payment field from the banks table is confusing the bank_ref field in the invoice table.

              Regards

              Judith

              Comment


                #8
                Re: Posting to another Database

                Let me add a bit of background to assist other "travelers" may find this thread later on.

                In Judith's design several fields in her primary table had the same "replace value" post field rule, all pointing to a single field in the target table. The effect of this is to give Alpha heartburn. The rules require it to post all the field values entered in the primary record's several fields to the same target field in the destination table. These fields were all numeric so they autofilled with zeros, some of which were being posted last. The solution was to create matching fields in the destination table so each post field rule defintion in the primary table would post to a separate target field in the destination table.

                Comment

                Working...
                X