Ok, a brief explanation.
I am developing a software for molecular descriptors calculation.
For every molecules I have to calculate thousands of descriptors.
These descriptors are divided in blocks.
During the calculation I would like to store the calculated descriptors
in a database, embedded, I chose firebird but actually I am working on a
not embedded IB6 database.
For every block I create a table, every table has tens of columns, each
column is a molecular descriptor. All the fields are float.
Every row is a molecule.
I create the table at runtime.
After the suggestions of raistware and bram I changed the tables
structure using unique field names.
Two create statements are at the bottom of this mail.
There are more then 20 tables, every table with tens of columns.
After the calculation I would like to show the calculated descriptors to
the user.
So I join the tables.
If I join the empty tables TSQLquery works properly, if the tables are
not empty I got the error:
incorrect values within sqlda structure
I get this error with TSQLquery but not using zeos component. With zeos
components I have other problems (slowness and the obtained fields are not
float).
The query could be a query with a join of 20 or more tables.
Here an example with only two tables:
select *
from DESCVALUES1 D1
left join DESCVALUES2 D2 on D1.D1_IDDESCVALUE1 = D2.D2_IDDESCVALUE2
The complete error message is: (ibDescriptors is the TIBconnection). I am using
Interbase 6.
ibDescriptors: Fetch
- Dynamic SQL error
- SQL error code= -804
- incorrect values within sqlda structure
I also need to use select statement with explicit fields and not with *.
Just another question a bit out of this thread, is it possible to create the DB
at runtime? I am not able to do that.
Thanks,
a.
CREATE TABLE DESCVALUES1 (D1_IDDESCVALUE1 INTEGER NOT NULL , D1_DESCVALUE1
FLOAT, D1_DESCVALUE2 FLOAT, D1_DESCVALUE3 FLOAT, D1_DESCVALUE4 FLOAT,
D1_DESCVALUE5 FLOAT, D1_DESCVALUE6 FLOAT, D1_DESCVALUE7 FLOAT, D1_DESCVALUE8
FLOAT, D1_DESCVALUE9 FLOAT, D1_DESCVALUE10 FLOAT, D1_DESCVALUE11 FLOAT,
D1_DESCVALUE12 FLOAT, D1_DESCVALUE13 FLOAT, D1_DESCVALUE14 FLOAT,
D1_DESCVALUE15 FLOAT, D1_DESCVALUE16 FLOAT, D1_DESCVALUE17 FLOAT,
D1_DESCVALUE18 FLOAT, D1_DESCVALUE19 FLOAT, D1_DESCVALUE20 FLOAT,
D1_DESCVALUE21 FLOAT, D1_DESCVALUE22 FLOAT, D1_DESCVALUE23 FLOAT,
D1_DESCVALUE24 FLOAT, D1_DESCVALUE25 FLOAT, D1_DESCVALUE26 FLOAT,
D1_DESCVALUE27 FLOAT, D1_DESCVALUE28 FLOAT, D1_DESCVALUE29 FLOAT,
D1_DESCVALUE30 FLOAT, D1_DESCVALUE31 FLOAT, D1_DESCVALUE32 FLOAT,
D1_DESCVALUE33 FLOAT, D1_DESCVALUE34 FLOAT, D1_DESCVALUE35 FLOAT,
D1_DESCVALUE36 FLOAT, D1_DESCVALUE37 FLOAT, D1_DESCVALUE38 FLOAT,
D1_DESCVALUE39 FLOAT, D1_DESCVALUE40 FLOAT, D1_DESCVALUE41 FLOAT,
D1_DESCVALUE42 FLOAT, D1_DESCVALUE4!
3 FLOAT, D1_DESCVALUE44 FLOAT, D1_DESCVALUE45 FLOAT, D1_DESCVALUE46 FLOAT,
D1_DESCVALUE47 FLOAT, D1_DESCVALUE48 FLOAT);
CREATE TABLE DESCVALUES2 (D2_IDDESCVALUE2 INTEGER NOT NULL , D2_DESCVALUE1
FLOAT, D2_DESCVALUE2 FLOAT, D2_DESCVALUE3 FLOAT, D2_DESCVALUE4 FLOAT,
D2_DESCVALUE5 FLOAT, D2_DESCVALUE6 FLOAT, D2_DESCVALUE7 FLOAT, D2_DESCVALUE8
FLOAT, D2_DESCVALUE9 FLOAT, D2_DESCVALUE10 FLOAT, D2_DESCVALUE11 FLOAT,
D2_DESCVALUE12 FLOAT, D2_DESCVALUE13 FLOAT, D2_DESCVALUE14 FLOAT,
D2_DESCVALUE15 FLOAT, D2_DESCVALUE16 FLOAT, D2_DESCVALUE17 FLOAT,
D2_DESCVALUE18 FLOAT, D2_DESCVALUE19 FLOAT, D2_DESCVALUE20 FLOAT,
D2_DESCVALUE21 FLOAT, D2_DESCVALUE22 FLOAT, D2_DESCVALUE23 FLOAT,
D2_DESCVALUE24 FLOAT, D2_DESCVALUE25 FLOAT, D2_DESCVALUE26 FLOAT,
D2_DESCVALUE27 FLOAT, D2_DESCVALUE28 FLOAT, D2_DESCVALUE29 FLOAT,
D2_DESCVALUE30 FLOAT, D2_DESCVALUE31 FLOAT, D2_DESCVALUE32 FLOAT,
D2_DESCVALUE33 FLOAT, D2_DESCVALUE34 FLOAT, D2_DESCVALUE35 FLOAT,
D2_DESCVALUE36 FLOAT, D2_DESCVALUE37 FLOAT, D2_DESCVALUE38 FLOAT,
D2_DESCVALUE39 FLOAT, D2_DESCVALUE40 FLOAT, D2_DESCVALUE41 FLOAT,
D2_DESCVALUE42 FLOAT, D2_DESCVALUE4!
3 FLOAT, D2_DESCVALUE44 FLOAT, D2_DESCVALUE45 FLOAT, D2_DESCVALUE46 FLOAT,
D2_DESCVALUE47 FLOAT, D2_DESCVALUE48 FLOAT, D2_DESCVALUE49 FLOAT,
D2_DESCVALUE50 FLOAT, D2_DESCVALUE51 FLOAT, D2_DESCVALUE52 FLOAT,
D2_DESCVALUE53 FLOAT, D2_DESCVALUE54 FLOAT, D2_DESCVALUE55 FLOAT,
D2_DESCVALUE56 FLOAT, D2_DESCVALUE57 FLOAT, D2_DESCVALUE58 FLOAT,
D2_DESCVALUE59 FLOAT, D2_DESCVALUE60 FLOAT, D2_DESCVALUE61 FLOAT,
D2_DESCVALUE62 FLOAT, D2_DESCVALUE63 FLOAT, D2_DESCVALUE64 FLOAT,
D2_DESCVALUE65 FLOAT, D2_DESCVALUE66 FLOAT, D2_DESCVALUE67 FLOAT,
D2_DESCVALUE68 FLOAT, D2_DESCVALUE69 FLOAT, D2_DESCVALUE70 FLOAT,
D2_DESCVALUE71 FLOAT, D2_DESCVALUE72 FLOAT, D2_DESCVALUE73 FLOAT,
D2_DESCVALUE74 FLOAT, D2_DESCVALUE75 FLOAT, D2_DESCVALUE76 FLOAT,
D2_DESCVALUE77 FLOAT, D2_DESCVALUE78 FLOAT, D2_DESCVALUE79 FLOAT,
D2_DESCVALUE80 FLOAT, D2_DESCVALUE81 FLOAT, D2_DESCVALUE82 FLOAT,
D2_DESCVALUE83 FLOAT, D2_DESCVALUE84 FLOAT, D2_DESCVALUE85 FLOAT,
D2_DESCVALUE86 FLOAT, D2_DESCVALUE87 FLOAT, D2_DESCVALUE!
88 FLOAT, D2_DESCVALUE89 FLOAT, D2_DESCVALUE90 FLOAT, D2_DESCVALUE91 F
T, D2_DESCVALUE95 FLOAT, D2_DESCVALUE96 FLOAT, D2_DESCVALUE97 FLOAT,
D2_DESCVALUE98 FLOAT, D2_DESCVALUE99 FLOAT, D2_DESCVALUE100 FLOAT,
D2_DESCVALUE101 FLOAT, D2_DESCVALUE102 FLOAT, D2_DESCVALUE103 FLOAT,
D2_DESCVALUE104 FLOAT, D2_DESCVALUE105 FLOAT, D2_DESCVALUE106 FLOAT,
D2_DESCVALUE107 FLOAT, D2_DESCVALUE108 FLOAT, D2_DESCVALUE109 FLOAT,
D2_DESCVALUE110 FLOAT, D2_DESCVALUE111 FLOAT, D2_DESCVALUE112 FLOAT,
D2_DESCVALUE113 FLOAT, D2_DESCVALUE114 FLOAT, D2_DESCVALUE115 FLOAT,
D2_DESCVALUE116 FLOAT, D2_DESCVALUE117 FLOAT, D2_DESCVALUE118 FLOAT,
D2_DESCVALUE119 FLOAT);
Joost van der Sluis wrote:
Can you post the structure of those two tables. (Their create-
statement?)
On Thu, 2007-05-03 at 16:50 +0200, Andrea Mauri wrote:
incorrect values within sqlda structure
I got this error only if the DB is not empty, if the DB is empty the
query opens properly.
I tested the same query with a SQL manager and using zeos components.
In both cases it works properly.
I build the query at runtime, it collects tens of float fields from
different tables and joined them.
--
Andrea Mauri
PhD student - Chemical Sciences
Milano Chemometrics and QSAR Research Group
Department of Environmental Sciences
University of Milano-Bicocca
P.zza della Scienza, 1
20126 Milano - Italy
Tel: ++39 02 64482801
mailto:[EMAIL PROTECTED]
http://www.disat.unimib.it/chm/
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
