Jump to content
Changes to the Jaspersoft community edition download ×

Problems with select of two tables


ktrinad

Recommended Posts

By: Fco Antonio - jofranco

Problems with select of two tables

2003-07-08 09:24

Hi:

I need to generate reports with a DBMS DBF (Clipper)

I have the DBF_JDBC20.jar and Ireport 0.2.1

 

 

In the generation of reports with a single table is no problem.

 

Now in the generation of reports with two tables I have the following problems

 

Case 1:

 

If used wizard report with

select table1.field1, table2.field2 from table1, table2

 

In step 2 it appears the fields:

table1.field1

table2.field2

 

to the compilation marks to errors in classis.java in variable the names

field_table1.field1 and field_table2.field2

 

When modifying select to:

select table1.field1 as A, table2.field2 as B from table1, table2.

 

compilation errors do not exist , but this it does not appear and hang iReport

 

As I can make select?

 

 

 

 

 

 

 

 

 

By: Giulio Toffoli - gt78

RE: Problems with select of two tables

2003-07-08 16:40

Why don't use simply

 

select field1, field2 from table1, table2 ?

Can you send me the XML ?

 

Giulio

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...