Alpha Video Training
Results 1 to 2 of 2

Thread: numeric field problems

  1. #1
    Member
    Real Name
    Steven Greer
    Join Date
    Jun 2008
    Location
    Manchester,PA
    Posts
    379

    Default numeric field problems

    Ok so the code has been working for a long time until i tried something today and discovered it is not giving the full info here is a screen shot of whats happening i can send code privately due to the info that is in it.

    dbaseerror.jpg

    it is pulling the correct list of docs from the sql server based on the idclientd but seems to no like the value of the number, the main table stores the number correctly and fields are same type and same size numeric,19.
    my sql field is bigint() but haven't had any issues on any other places.
    Last edited by steve745; 01-29-2018 at 08:27 PM.

  2. #2
    Member
    Real Name
    Steven Greer
    Join Date
    Jun 2008
    Location
    Manchester,PA
    Posts
    379

    Default Re: numeric field problems

    I was able to work around this error by using query to dbf and just rewrote the script.

Similar Threads

  1. How do you add a calc field to display the average of a numeric field within a group footer
    By dwjgoblue in forum Alpha Five Version 10 - Desktop Applications
    Replies: 2
    Last Post: 01-11-2014, 10:38 AM
  2. Changing Field from numeric to character problems
    By gmeredith17 in forum Alpha Five Version 8
    Replies: 6
    Last Post: 02-25-2008, 10:06 AM
  3. import a numeric field into a character field
    By dcorcoran in forum Alpha Five Version 6
    Replies: 5
    Last Post: 04-02-2005, 09:44 AM
  4. Copying Calculated Field to a Numeric Field
    By Alastair in forum Alpha Five Version 5
    Replies: 14
    Last Post: 10-07-2004, 07:34 AM
  5. Keeping numeric field numeric upon importing
    By David Farr in forum Alpha Five Version 5
    Replies: 2
    Last Post: 03-19-2003, 10:01 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
  •