Alpha Video Training
Results 1 to 4 of 4

Thread: So...what's wrong with this?

  1. #1
    Member
    Real Name
    Greg Williams
    Join Date
    Sep 2001
    Posts
    321

    Default So...what's wrong with this?

    Hello:

    I have a database "schedule body", that contains the following fields:

    Week - N 2, Week Completed - N 1, Completed Week - N 1.

    What I want to do is have a tablemax expression find the largest week "Week" in the "Schedule body" database when Completed Week" = 1. The field that calculates the "Completed Week" field works fine, but this is the expression I am using:

    tablemax("schedule body","Completed_Week=1","Week")

    And it says "Expression does notreturn a numerical value"

    I want the "week completed" to contain the value.

    So...what's wrong with this?

    Greg Williams

  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: So...what's wrong with this?

    Possibly choking on

    "Schedule body" as a table name (space between words), I don't think you really meant database "schedule body"

    Not a good idea to have punctuation other than underscores in table names, too easy to have it mis-interpreted by the parser.

  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: So...what's wrong with this?

    Further testing seems to indicate that the problem is not with the space, still not a good practice. I was able to tablemax a two word named table.

    Only other suggestion I could make is to double check the structure to see that "week" is numeric.

    Also you refer to

    Week Completed
    Completed Week
    as field names

    and
    Completed_Week -----------------with underscore

    in the expression. Consistency could help.

  4. #4
    Member
    Real Name
    Greg Williams
    Join Date
    Sep 2001
    Posts
    321

    Default RE: So...what's wrong with this?

    Stan:

    Underscore was the problem. Thanks

    Greg

Similar Threads

  1. What is wrong with th is?????
    By Schulzie in forum Alpha Five Version 4
    Replies: 7
    Last Post: 09-18-2003, 01:29 PM
  2. WHAT am I doing Wrong?
    By Ronald Anusiewicz in forum Alpha Five Version 5
    Replies: 1
    Last Post: 05-09-2003, 09:16 PM
  3. What is Wrong Here?
    By Peter DeBilio in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-06-2003, 03:24 PM
  4. Something is wrong
    By Ken Penge in forum Alpha Five Version 4
    Replies: 15
    Last Post: 07-19-2002, 09:45 PM
  5. what am i doing wrong?
    By Edward F. Schulz in forum Alpha Five Version 4
    Replies: 4
    Last Post: 04-01-2002, 02:13 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
  •