Alpha Video Training
Results 1 to 5 of 5

Thread: Color Equation Problem

  1. #1
    Member
    Real Name
    Willy Berchtold
    Join Date
    Dec 2003
    Posts
    70

    Default Color Equation Problem

    I have a browse with color equations that work fine. But if
    I use this browse as a custom lookup browse alpha 5 comes
    up with an color equation error.

  2. #2
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,172

    Default RE: Color Equation Problem

    You give little information to go by, but if the lookup table is the same as the current table, you have opened a second instance of the same table. The color equation will fail, since it can't reconcile the table of field refereces in the equation. The solution in that case is to base the lookup on a browse without a color equation.

    If the lookup table is not the same as the current table, then the color equation will still work, since it can reconcile the equation.

    Jerry

  3. #3
    Member
    Real Name
    Willy Berchtold
    Join Date
    Dec 2003
    Posts
    70

    Default RE: Color Equation Problem

    Hi Jerry

    I have a standard invoice set. With invhead and line item table. In the line item table I use a lookup to the product
    table and use a custom browse. This all works fine. But if I use a color eqation in the custom browse is soon as I open
    up the lookup it comes with error " Warning: Error parsing color eqation for field Product-"part_no".
    This is the color eqation I use for the part_no column: case(PRODUCT-"Not_Listed,"Red on White",.T.,"Black on White")

    Thanks Willy Berchtold

  4. #4
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,172

    Default RE: Color Equation Problem

    If the product table is linked in any fashion in the set, you will have the same issue since the table will be opened twice. An example would be your scenario in the invoice set in Alpha Sports. If the product browse from invoice_items has a color expression, the expression will generate an error.

    Jerry

  5. #5
    Member
    Real Name
    Willy Berchtold
    Join Date
    Dec 2003
    Posts
    70

    Default RE: Color Equation Problem

    You where right the product table is in the invoice set. But
    even after a deleted it out of the set. it still came up with the same error.

    Thanks Willy

Similar Threads

  1. Color equation problem
    By Greg Ojeda in forum Alpha Five Version 5
    Replies: 5
    Last Post: 02-28-2004, 07:53 AM
  2. Color equation problem
    By admin@dcitelecom.com in forum Alpha Five Version 5
    Replies: 1
    Last Post: 03-17-2003, 12:31 PM
  3. Color Equation ??
    By James Connors in forum Alpha Five Version 4
    Replies: 2
    Last Post: 08-16-2001, 03:47 AM
  4. Ver 4.5 Color Equation Bug
    By James Connors in forum Alpha Five Version 4
    Replies: 3
    Last Post: 05-04-2001, 06:01 PM
  5. Color Equation Problem
    By Steve Buckler in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-07-2000, 07:19 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
  •