Alpha Video Training
Results 1 to 6 of 6

Thread: Post Operation Returns Error

  1. #1
    Member
    Real Name
    Warren Slaughter
    Join Date
    Dec 2016
    Posts
    7

    Default Post Operation Returns Error

    I wrote a post operation and it worked a few times, now it gives me the error "Numeric Value is out-of-range". I tried isolating each item that was being posted, but the error persists. I really don't understand the meaning of this error as it returns even on character posts (replaces) Does anyone know why I would suddenly start getting this error when the operation has worked before?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Post Operation Returns Error

    Could be a calculated field rule triggered by the value being posted.
    There can be only one.

  3. #3
    Member
    Real Name
    Warren Slaughter
    Join Date
    Dec 2016
    Posts
    7

    Default Re: Post Operation Returns Error

    I do use calculated fields in the transaction table, but the post operation simply involves copying (replacing) fields from the transaction database to the master table. The calculations in the transaction always give the correct values, and do not go out of range. I am trying to design an app that will serve as a time clock replacement. The employee enters his number and then clicks clock in or clock out. I did find out I have to use a separate record for each "punch". If you try to keep the time in and time out on the same record, Alpha Five simply copies the clocked in time to the clocked out time. The computer I am working with is old, so that's why I'm using version 4.

  4. #4
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,610

    Default Re: Post Operation Returns Error

    I would open a browse and look for unexpected values in one of the fields.

    Sort each field descending and chances are a weird value will show itself.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Post Operation Returns Error

    If you try to keep the time in and time out on the same record, Alpha Five simply copies the clocked in time to the clocked out time.
    I've never seen anything like that. I usually find that Alpha does exactly what I tell it to do. Incorrect results are always a failure on my part to supply the correct instructions.
    There can be only one.

  6. #6
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,610

    Default Re: Post Operation Returns Error

    Warren

    Can you make a sample of your system and attach it to a message?

    Something is wrong that we may be able to find quickly with a sample...
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. Error Running a post Operation
    By Grant.EStores in forum Application Server Version 9 - Web/Browser Applications
    Replies: 2
    Last Post: 07-28-2009, 08:19 AM
  2. Error Running Post Operation
    By RAY BARENCHI in forum Alpha Five Version 8
    Replies: 2
    Last Post: 02-01-2008, 01:14 PM
  3. using the post operation
    By drmjgm in forum Alpha Five Version 7
    Replies: 3
    Last Post: 04-14-2007, 10:41 PM
  4. Post Operation
    By jas in forum Alpha Five Version 5
    Replies: 6
    Last Post: 01-15-2006, 01:44 PM
  5. post operation
    By C Johnson in forum Alpha Five Version 4
    Replies: 6
    Last Post: 11-25-2002, 08:51 AM

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
  •