Jump to content
Changes to the Jaspersoft community edition download ×

Recommended Posts

By: Sohan Kasula - skasula

SQL ERROR

2003-03-27 07:04

I am new to this tool and java too.

On using parameter reference in Report Query dialog box and using Read Fields in iReport with the following syntax..

 

Select null department,

null bureau,

null region_name,

null org_cd ,

permit_type,

mms_company_num,

well_name,

well_nm_st_sfix,

well_nm_bp_sfix,

api_well_number,

req_spud_date,

sn_apd,

sn_surf_site_fk

from e_apds

where sn_apd = $P{PSNAPD}

UNION

select

upper (a.description) department,

upper (b.description) bureau,

upper (c.description) region_name,

upper (d.description) org_cd ,

null permit_type,

null mms_company_num,

null well_name,

null well_nm_st_sfix,

null well_nm_bp_sfix,

null api_well_number,

to_date(null) req_spud_date,

to_number(null) sn_apd,

to_number(null) sn_surf_site_fk

from tims_generic_codes a, tims_generic_codes b, tims_generic_codes c, tims_generic_codes d

where a.identifier = 'DEPT_TITLE'

and b.identifier = 'BUREAU_TITLE'

and c.identifier = 'REGION_TITLE'

and d.identifier = 'REGION_CODE'

 

I get an error, saying

Non supported SQL92 token at position 385: PSNAPD. I followed the example with MaxOrderId.

I created PSNAPD parameter with double as the datatype. I don't have any problems in reading fields if the parameter reference is removed.

Help in resolving this is appreciated.

 

thanks

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...