Hi,

Sorry, I forgot the array declarator for the host variable. The
following should work: 

EXEC SQL BEGIN DECLARE SECTION
<...>
VARCHAR long_value[7];
<...>
EXEC SQL END DECLARE SECTION
<...>
strcpy (long_value.arr, "blabla");
long_value.len = 6;
EXEC SQL INSERT INTO Table1 VALUES(1, :long_value);
<...>

Regards,

Thomas

-----Original Message-----
From: Ruslan Bulatov [mailto:[EMAIL PROTECTED] 
Sent: Mittwoch, 8. Dezember 2004 07:22
To: [EMAIL PROTECTED]
Subject: Re[2]: INSERT LONG values

Hello!

DON'T WORK!
 
> EXEC SQL BEGIN DECLARE SECTION
> <...>
> VARCHAR long_value;
> <...>
> EXEC SQL END DECLARE SECTION

$cpc test.cpc
<...>
     *** PRECOM-ERROR NO: -838  Invalid declarator
<...>

But then I use:
EXEC SQL BEGIN DECLARE SECTION
<...>
typedef VARCHAR VC30[30];
VC30 *long_value;
<...>
EXEC SQL END DECLARE SECTION
strcpy(long_value->arr,"blabla");
long_value->len=6;
printf("arr=%s",long_value->arr);
printf("len=%d",long_value->len);
EXEC SQL INSERT INTO Table1 VALUES(1, :long_value);

Result of execution is:
arr=blabla
len=6
Segmentation fault

What's problem?
Please, help me...
Fluffy Cat

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to