Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
ODBC - ODBC with the MySQL Connector/ODBC driver
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
mysql:it 's a db not a dbms how it 's possible?!
Does the binary log enabling affect the MySQL performances?
Strange behavior, Table Level Permission
FULLTEXT query format question
Preventing Duplicate Entries
Comparing and writing out BLOBS
Executing MySQL Commands From Within C Program
Can 't access mysql after kernel upgrade
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Downgrade Mysql from 4 to 3 23
MySQL Cluster Software
mysql test 4 1 fails with the gis test
ERROR 2002: Can 't connect to local MySQL server through socket
Getting Identity after INSERT
Update one field with more fields from another table
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
mysql have same function mthod as Oracle decode()
 
maxdb 7.5 cpc error -845 on tables/structs with more than 6 columns

maxdb 7.5 cpc error -845 on tables/structs with more than 6 columns

2006-09-08       - By Dave Narotam

 Back

my source contains
"
 EXEC SQL BEGIN DECLARE SECTION;
  struct
  {
     int    i1;
     int    i2;
     int    i3;
     int    i4;
     int    i5;
     int    i6;
     int    i7;
  } testdata2;
EXEC SQL END DECLARE SECTION;

EXEC SQL insert into cpctest
               values (1,2,3,4,5,6,7);

EXEC SQL INSERT INTO cpctest  VALUES ( :testdata2 ) ;
"

The precompiler quits with  
  PRECOM-ERROR NO :    -845   Invalid SQL statement
on the line EXEC SQL INSERT INTO cpctest  VALUES ( :testdata2 ) ;


When the table /struct has only 6 columns everthing is fine?



--

Mit freundlichen Gr??en / Best Regards

Anil (Dave) Narotam
Leiter Software Entwicklung /
Software Development Manager

M & N Solutions GmbH
Dieselstra?e 18
61191 Rosbach

Tel.: ++49(6003)9141-26
Fax:  ++49(6003)9141-49
E-Mail: a.narotam@(protected)


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)