Using Firebird 3.0.4 and SOCI 3.2.3 on Arch Linux.

I have a table like:
> CREATE TABLE foo (
>   name VARCHAR(32) NOT NULL,
>   value BIGINT NOT NULL,
>   data BLOB,
>   PRIMARY KEY (name, value)
> );

I can't insert in to this table using prepared values. Example:

> string name = "whatever";
> uint64_t value = 1234;
> string data = "anything";

> soci::statement st = (db_.prepare << "INSERT INTO foo 
> VALUES(:name,:value,'foo')",
>      soci::use(name), soci::use(value));
> st.execute(true);

// Hangs forever at 100% CPU usage

Or this one with the blob:
> soci::statement st = (db_.prepare << "INSERT INTO foo 
> VALUES(:name,:value,:data)",
>      soci::use(name), soci::use(value), soci::use(data));
> st.execute(true);

// Returns error "Unexpected string type." Seems to be related to the BLOB.

Bugs or am I doing something wrong?

Chris


_______________________________________________
soci-users mailing list
soci-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/soci-users

Reply via email to