Hi!
Thanks, I will try

And how I do it in other interfaces, for example, Python?

Fluffy Cat


-----Original Message-----
From: "Simenec, Thomas" <[EMAIL PROTECTED]>
To: "Ruslan Bulatov" <[EMAIL PROTECTED]>
Date: Wed, 8 Dec 2004 11:45:21 +0100
Subject: RE: Re[2]: INSERT LONG values

> 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]

Reply via email to