Odp: [PHP-DB] Interbase BLOB Insertion Problem

2001-05-22 Thread Jarek Zgoda 

Od: "Xanir" <[EMAIL PROTECTED]>
Temat: [PHP-DB] Interbase BLOB Insertion Problem


> begin declare section;
>   based on test.v1 document;
>   based on test.v1.segment BlobV1Buffer;
>   based on test.state CA;
>   unsigned short BlobV1Len;
> end declare section;

This is DSQL statement, you cann't use it in ISQL!
For detailed description of IB BLOB hadling in PHP go to
www.open-database.de

Cheers
Jarek Zgoda


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Interbase BLOB Insertion Problem

2001-05-22 Thread Xanir 

Hi,

I want to insert data in to a blob. So I followed the steps in de docs, but
when I try to execute this script in the IBConsole:


begin declare section;
  based on test.v1 document;
  based on test.v1.segment BlobV1Buffer;
  based on test.state CA;
  unsigned short BlobV1Len;
end declare section;

  declare CursorV1 cursor for insert blob v1 into test;

  open CursorV1 into :document;

  sprintf(BlobV1Buffer, 'First blob tekst');

   BlobV1Len = strlen(BlobV1Buffer);

  insert cursor CursorV1 values (:BlobV1Buffer:BlobV1Len);

  close CursorV1;

insert into test (state,v1) values ('CA',:document);



an error message pops up:


error:

Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 0
begin
Statement: begin declare section


How do I solve this problem?


Thanks.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]