Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
EDB 2.04 B4 fails INSERT INTO ..SELECT.. JOIN |
Tue, Jan 4 2011 6:47 AM | Permanent Link |
Mauro Botta | 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. |
Tue, Jan 4 2011 7:56 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Tue, Jan 4 2011 8:47 AM | Permanent Link |
Mauro Botta | 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. |
Wed, Jan 5 2011 3:52 AM | Permanent Link |
Mauro Botta | 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 |
Wed, Jan 5 2011 4:23 AM | Permanent Link |
Malcolm Taylor | 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 -- |
Wed, Jan 5 2011 5:07 AM | Permanent Link |
Mauro Botta | 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 > -- > |
Wed, Jan 5 2011 5:45 AM | Permanent Link |
Malcolm Taylor | 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 |
Wed, Jan 5 2011 6:09 AM | Permanent Link |
Mauro Botta | 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. |
Wed, Jan 5 2011 6:22 AM | Permanent Link |
Malcolm Taylor | 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. -- |
Tue, Jan 11 2011 3:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Monday, May 6, 2024 at 12:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |