Formatted Search

[Former Member]

Hi,

Iam making use of a simple formatted Search query , But its pops out error(8180).

Query am using is:

SELECT T0.ItemCode FROM OSCN T0 WHERE T0.ItemCode = $[$4.0.0]

I tried changing my query as

SELECT T0.ItemCode FROM OSCN T0 WHERE T0.ItemCode = $[ORDR.CardCode]

Error 8180 is shown here too.CAn somebody please help me out

Thanks

Mini

[Marshall-Jones]

Which form are you trying to get this to work on? The $[$4.0.0] refers to a field on the current form. 4 should be the form type.

[Former Member]

Hi,

Sorry for typing wrong query this is the query am trying.

SELECT T0.ItemCode FROM OSCN T0 WHERE T0.CardCode = $[$4.0.0] , same 8180 error is shown again.

And am trying this search with the sales order form.

Thank you

Mini

[Former Member]

Try $[$4.1.0]

[Former Member]

this works as well as stuart's post:

SELECT T0.ItemCode FROM OSCN T0 WHERE T0.CardCode = $[ORDR.CardCode]

Mini- to test save the query.

bring up the sales order. then go to menu option Tools --> queries --> user queries --> <<select category>> --> select your query.

If your formatted search returns results they will be displayed. This is a quick way of testing without linking the formatted search to the field.

[Former Member]

Hi,

Thanks for responding.

Stuart sorry ot tell that even your query shows error 8180 while execution

Neill, I have been testingthe query both ways

1st i tested through query manager when executing my query that way it shows me error 8180, even after linking through formatted search it shows error 8180.

Thanks

Mini

[Former Member]

Mini-

The query should work.

I copied your search into my b1 installation and it works.

Try creating a new formatted search and paste the string into it.

thanks

John W

[Former Member]

You probably want itemcode not cardcode