Skip to Content

I canu00B4t do a formatted search in a user table

Hye, I'm trying to do a formatted search over a user table using and I get the error -2006, why?

I use "report generator" and my selecc is :

SELECT T0.U_grupo, T0.U_CODE

FROM T0

WHERE T0.U_grupo ='[%0]' FOR BROWSE

If I do the same with standar table ( e.j OITM), all is right:

SELECT T0.ItemCode, T0.ItemName

FROM OITM T0

WHERE T0.PrchseItem ='[%0]' FOR BROWSE

unless, with user tables no, whyyyy?

thank´

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 28, 2004 at 09:16 PM

    I have seen this, though I don't have an official answer, I have my own theories. SBO matches up the variable with the previous field name and looks up the description for that field. The description for user fields is not stored in the same place as standard fields.

    In a previous thread, named "SQL Syntax in SBO" (number 7144) another user showed a way to do dummy selects with the variables to get the names of standard fields. Then the variables can be used for the real work.

    That is awkward, and it limits you to the descriptions of standard fields.

    Bruce

    Add comment
    10|10000 characters needed characters exceeded