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


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


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

unless, with user tables no, whyyyy?


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.