Alpha Video Training
Results 1 to 2 of 2

Thread: Extra characters at end of expression

  1. #1
    Member Citadel's Avatar
    Real Name
    Alan Storey
    Join Date
    Nov 2006
    Location
    Reading, Berkshire
    Posts
    124

    Angry Extra characters at end of expression

    Hi all

    This is the message I get when I set the current date in a date field within an embedded browse in the attached (simplified) app. The date does set correctly but then I get the error message!!

    Specifically, I press the 'D' button at the top of the 'Next Call' column in the browse.

    Even using the debugger, I cannot isolate the source of the error. Any ideas?
    Kind Regards
    Alan

  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: Extra characters at end of expression

    There's a problem with the cansaverecord event in your field rules for the call list table. Not sure what is intended but the first line is not commented out as it should be.

    Not sure what is intended because you will get a new error when you fix that. The script refers to table.current() and then the notes field. There is no notes field in the call list table.

    Footnote: If you can stand it, I suggest using underscores if you must separate words in table names (not spaces). The Alpha documentation does too.

    Seems the cansaverecord event script should be

    Code:
    t = table.current(2)
    if len(alltrim(t.NOTES)) = 0 then  
    	cancel()  'cancel save if key field is empty
    end if
    Last edited by Stan Mathews; 03-11-2010 at 10:23 AM.
    There can be only one.

Similar Threads

  1. Extra characters at the end of expression & SQL
    By MichaelCarroll in forum Application Server Version 10 - Web/Browser Applications
    Replies: 10
    Last Post: 03-02-2010, 11:03 AM
  2. Extra Characters at End of Expression
    By Rich Hartnett in forum Application Server Version 10 - Web/Browser Applications
    Replies: 6
    Last Post: 10-11-2009, 10:18 PM
  3. Extra Characters at end of Expression
    By Dan Blank in forum Application Server Version 8
    Replies: 1
    Last Post: 11-10-2007, 03:07 PM
  4. Extra characters at end of expression error
    By Camille Venners in forum Alpha Five Version 5
    Replies: 7
    Last Post: 05-09-2003, 06:21 AM
  5. Extra Characters?
    By Howard Berg in forum Alpha Five Version 4
    Replies: 21
    Last Post: 04-23-2000, 01:08 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
  •