cancel
Showing results for 
Search instead for 
Did you mean: 

userquery AND headerdata

0 Kudos

Dear experts,

Could someone explain to me why a query like:

SELECT T0.[DocNum]
FROM [dbo].[ODLN]  T0
WHERE T0.Comments Like '%$[ORDR.DocNum.number]%'

works and this one:

SELECT T0.[DocNum]
FROM [dbo].[ODLN]  T0
WHERE T0.Comments Like '%$[$8.0.0]%'

doesn't?

The first query gives a correct DocNum (if I skipp the .number part it returns a value like N'204209' (inc. quotes) instead of just 204209).

The second query gets the same N'204209' value. If I add the .number for the last .0 I get a value like 204209,000000 which isn't what I want either.

I'm kinda lost figuring this out so any help would be appreciated.

René

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear René,

I have tested in 2007A db. Both are working if you change the 2nd one to $[$8.0.number].

Are you sure it is not working?

Thanks,

Gordon

0 Kudos

that's strange. It does work now... Don't understand why I got errors but at least it works now...

thank you for your time

Former Member
0 Kudos

Please close your thread since it is no longer an issue.

Answers (0)