Alpha Video Training
Results 1 to 3 of 3

Thread: Transposing a negative number to a blank field

  1. #1
    Charles Scott
    Guest

    Default Transposing a negative number to a blank field

    I have written a program which requires importing comma delimited files. In numeric fields where the field must be blank, the number they send in the file is -1.00. How do I transpose the -1.00 number to a blank field. note: zero is not allowed. I've tried using the Val function, and the Zblank function, nither will allow a blank field. Anybody got a suggestion?

    Thanks,
    Chuck

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Transposing a negative number to a blank field

    Chuck,

    Blank numeric type fields have been troublesome in the past. Most would either store a zero there, or would use character type fields instead.

    -- tom

  3. #3
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default RE: Transposing a negative number to a blank field

    Add to that the fact that a blank numeric field will return a value of something like 10^308 when read directly from an object on a form - i.e., parentform:MyFieldObject.value.

    You might want to take a look at this thread on Warning:%20%20Uninitialized%20variable%20or%20array%20index%20or%20property%20(sortby)%20in%20/usr/local/forum/apache/htdocs/alphaphorum/alpha_search.php3%20on%20line%2038&direction=Warning:%20%20Uninitialized%20variable%20or%20array%20index%20or%20property%20(direction)%20in%20/usr/local/forum/apache/htdocs/alphaphorum/alpha_search.php3%20on%20line%2039&num=11&id=40596&thread=40596">Checking for empty numeric fields

Similar Threads

  1. negative number input
    By kevinsmith in forum Alpha Five Version 6
    Replies: 2
    Last Post: 10-31-2004, 02:21 PM
  2. test for blank number field
    By Tom Patten in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-07-2003, 11:14 PM
  3. number field not blank
    By Tom Patten in forum Alpha Five Version 4
    Replies: 2
    Last Post: 06-22-2002, 07:49 PM
  4. Negative Number Instead of Positive Number
    By forskare in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-02-2002, 09:28 AM
  5. Negative Number Display
    By JohnZaleski in forum Alpha Five Version 4
    Replies: 6
    Last Post: 04-24-2001, 04:48 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
  •