Alpha Video Training
Results 1 to 4 of 4

Thread: Why does this not work

  1. #1
    Member
    Real Name
    Joe Schanno
    Join Date
    Aug 2007
    Location
    Eastern Shore of Maryland
    Posts
    12

    Default Why does this not work

    The following worked in the Alpha Four program that served my office very well.

    Clients and cases in my office are identified by a unique 5 number charactor string for each client and a number after a decimal to identify the case, i.e. 10000.001, 10000.002, 10001.001, 10002.002

    VCLIENT is a numeric field created with the expression VAL(CLient_num).

    LASTCASENUM is a user entered charactor field. It is normally filed by a variable from a prior record.

    VLASTCASENUM is a numeric field created with the expression VAL(LASTCASENUM)

    NEWCASENUM is numeric field created with the expression: IF(ISBLANK(LASTCASENUM),(VCLIENT)+.001,(VLASTCLIENTNUM+.001)

    Case Num is str(NEWCASENUM)

    The calculation for NEWCASENUM is not working, showing up as an incomplete expression. Anybody know why?

    Any idea how I can shorten up this process.

    Thanks

  2. #2
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: Why does this not work

    VLASTCLIENTNUM is not defined in your example and the IF statement is missing an ending paren.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

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

    Default Re: Why does this not work

    Quote Originally Posted by Joe Schanno View Post
    The following worked in the Alpha Four program that served my office very well.

    Clients and cases in my office are identified by a unique 5 number charactor string for each client and a number after a decimal to identify the case, i.e. 10000.001, 10000.002, 10001.001, 10002.002

    VCLIENT is a numeric field created with the expression VAL(CLient_num).

    LASTCASENUM is a user entered charactor field. It is normally filed by a variable from a prior record.

    VLASTCASENUM is a numeric field created with the expression VAL(LASTCASENUM)

    NEWCASENUM is numeric field created with the expression: IF(ISBLANK(LASTCASENUM),(VCLIENT)+.001,(VLASTCLIENTNUM+.001)

    Case Num is str(NEWCASENUM)

    The calculation for NEWCASENUM is not working, showing up as an incomplete expression. Anybody know why?

    Any idea how I can shorten up this process.

    Thanks
    The isblank() function accepts a quoted field name as its parameter.

    ISBLANK("LASTCASENUM")

  4. #4
    Member
    Real Name
    Joe Schanno
    Join Date
    Aug 2007
    Location
    Eastern Shore of Maryland
    Posts
    12

    Default Re: Why does this not work

    Thanks

Similar Threads

  1. Why doesn't this work?
    By vwater in forum Alpha Five Version 6
    Replies: 26
    Last Post: 02-15-2005, 10:17 AM
  2. Looking for work
    By rlgiordano in forum Alpha Five Version 5
    Replies: 0
    Last Post: 09-16-2004, 11:28 AM
  3. Why doesn't this work
    By russ Boehle in forum Alpha Five Version 5
    Replies: 5
    Last Post: 12-20-2002, 04:27 PM
  4. Why Doesn't this work?
    By Ken L Herrold in forum Alpha Five Version 4
    Replies: 10
    Last Post: 10-17-2000, 05:27 PM

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
  •