Skip to Content
0
Former Member
Jan 08, 2011 at 03:54 PM

Query Generator Problem

45 Views

Hi, I'm having sounds like silly problem using Query Generator, if I execute this query it does not give me the 'selection list' for Fiscal Year. I'm using v8.8 PL10 but in v2007 it's working fine. If I use other table like OITM w/ fieldX =N'[%0]', its working in v8.8.

SELECT T0.[Code], T0.[Name] FROM [dbo].[@BA_OAMD2]  T0 WHERE T0.[U_FisYear] =N'[%0]' 

thanks,

Edited by: Jojo on Jan 8, 2011 4:55 PM

Edited by: Jojo on Jan 8, 2011 4:56 PM