Alpha Video Training
Results 1 to 3 of 3

Thread: Bad parameter?

  1. #1
    Reese Fletcher
    Guest

    Default Bad parameter?

    I have a set comprised to two tables where the parent table is linked to a child table via a one to many link. I'm trying to total the hours in the child table based on the link. I found a total() example in the Alpha 5 help. The construc I'm using is as follows:

    total(child_tbl->field, grp->parent_tbl, grp->child_tbl)

    This is very similar to the example in the help, but I receive the following error when I try to save the calculation:

    Bad paramater summarize over: Group 'grp->parent_tbl' not found.

    Is there something that I am missing?

    Thanks,
    Reese

  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: Bad parameter?

    Though not stated in the docs, total() is more suited to reports (where you create "groups") than it is to forms.

    It sounds to me like this is your problem or if you are using it on a report, you have not created the group.

    Dbsum() and tablesum() probably offer the best possibilities for making your total work.

  3. #3
    Reese Fletcher
    Guest

    Default RE: Bad parameter?

    Stan, even though I forgot to say that I was doing this in a report, you realised it. I apologize for leaving that little tid-bit out in the details. I did get the tablesum() working though. I'm a newbie to this database world (about 4 weeks young), and I constantly find that what seems perfectly logical to me isn't quite so logical to the software. hehe I appreciate the help.

    Thanx,
    Reese

Similar Threads

  1. Skip parameter in UDF
    By Bill Parker in forum Archived Wishlist
    Replies: 5
    Last Post: 03-11-2006, 09:39 AM
  2. Parameter window too small
    By Ron Strougo in forum Alpha Five Version 6
    Replies: 0
    Last Post: 06-16-2005, 02:08 PM
  3. Function Parameter calling bug?
    By csda1 in forum Alpha Five Version 5
    Replies: 0
    Last Post: 07-29-2004, 10:48 AM
  4. Optional Dot-Variable Parameter
    By Blake in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-15-2003, 02:29 AM
  5. Prompting a Parameter run time!
    By Andy Dibble in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-24-2003, 07:03 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
  •