Hi Tim

i'm converting my application from EDB 2.03 B13 Delphi 2010  to EDB 2.04 B4
Delphi XE

i have found a problem of incompatibility, maybe...


In EDB Manager  (EDB 2.04B4 ) Prepare fails with a query like this :

Insert into ALIAS_DEST.PeopleNames select * from ALIAS_ORIG.PeopleNames as
Orig_People JOIN ALIAS_ORIG.States as Orig_States on Orig_States.ID =
Orig_People.ID_State WHERE orig_States.Continent = 'EUROPE'

( answer : ITALY,GERMAN,SPAIN.. )

ElevateDB Error #700 An error was found in the statement at line 1 and
column 43 (Invalid expression  found, the number of INSERT values does not
match the number of columns)

Two tables PeopleNames  are identical !!!.

these table/files with Edb Manger 2.03 B 13 work fine.

note
 This query without JOIN work fine.

Mauro


Someone will correct me if I'm wrong but I think you'll find its the JOIN.

When you join two tables together you effectively get the columns from both.

Roy Lambert [Team Elevate]

Hi Roy

i have tried this , already :

Insert into ALIAS_DEST.PeopleNames select >>>>  Orig_People.*  <<<<<  from
ALIAS_ORIG.PeopleNames as
Orig_People JOIN ALIAS_ORIG.States as Orig_States on Orig_States.ID =
Orig_People.ID_State WHERE orig_States.Continent = 'EUROPE'

Don't work.

I have installed 2.05 B1 , now

don't work this query, too.


any time in EDB when press "PREPARE" is showed an Access Violation Error

Mauro Botta wrote:

> In EDB Manager  (EDB 2.04B4 ) Prepare fails with a query like this :
>
> Insert into ALIAS_DEST.PeopleNames select * from
> ALIAS_ORIG.PeopleNames as Orig_People JOIN ALIAS_ORIG.States as
> Orig_States on Orig_States.ID = Orig_People.ID_State WHERE
> orig_States.Continent = 'EUROPE'
>
> ( answer : ITALY,GERMAN,SPAIN.. )
>
> ElevateDB Error #700 An error was found in the statement at line 1
> and column 43 (Invalid expression  found, the number of INSERT values
> does not match the number of columns)
>
> Two tables PeopleNames  are identical !!!.
>
> note
>  This query without JOIN work fine.

Mauro

In view of the error reported, I would try running just the 'select'
part of the statement (including the join) in the DB Manager.  This
will show you how many columns are being returned and when you compare
that with the columns of the PeopleNames table may help you to
understand why the error is raised.

If that does not help, then I am out of ideas.

Malcolm
--

i have tried, already.

The two tables ( same file structure, different directory ) are identical.




> In view of the error reported, I would try running just the 'select'
> part of the statement (including the join) in the DB Manager.  This
> will show you how many columns are being returned and when you compare
> that with the columns of the PeopleNames table may help you to
> understand why the error is raised.
>
> If that does not help, then I am out of ideas.
>
> Malcolm
> --
>

Mauro Botta wrote:

> i have tried, already.
>
> The two tables ( same file structure, different directory ) are
> identical.
>
Mauro

Yes, you said both tables were identical.  But the error says the
result of the select does not have the correct number of values.  So
how many values does the select return, and is that number more or less
than you expect?

Malcolm

Malcom,

if i use EDB Manager 2.00 ... -> 2.03x         all work fine
if i use EDB Manager 2.04b4 and 2.05b1     don't work.

Same files.

Mauro Botta wrote:

>
> Malcom,
> if i use EDB Manager 2.00 ... -> 2.03x         all work fine
> if i use EDB Manager 2.04b4 and 2.05b1     don't work.
>
> Same files.

I am sorry, but we do not understand each other so I can't help.
--

Mauro,

<< In EDB Manager  (EDB 2.04B4 ) Prepare fails with a query like this : >>

Please send me the database catalog and relevant table files, along with the
*exact* SQL that you're using.  I'll check it out and see what the problem
is.

--
Tim Young
Elevate Software
www.elevatesoft.com