Problems with select of two tables

[ktrinad]

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