Hi,
We are using the SQL Plugin (version 18.3).
When we try to insert a "big" blob (±700MB) in the database it don't work but
we don't have any error, and our database accept 2GB size blobs.
To insert the blob we proceed like this :
dim wPS as PreparedSQLStatement = db.Prepare("INSERT INTO " + aTab + "(" +
aColID + "," + aColBlob + ") values ( ?, ?)")
wPS.BindType(0, SQLPreparedStatementMBS.kTypeString)
wPS.BindType(1, SQLPreparedStatementMBS.kTypeLongBinary)
wPS.SQLExecute aID.XStr, aBlob
Here aBlob is a string and the result of the binary stream of a file. And aID
is an integer.
Does MBS limit the size of blobs ? or are we doing something wrong when we
insert the blob in the database ?
Thanks for your help.
Cordialement,
<http://www.8sens.com/>
Logiciels de gestion MAC et PC
Benjamin Rault
Service développement
8sens
2 bis rue Léon BLUM
91120 Palaiseau
Tel. 01 69 32 21 03
[email protected] <mailto:[email protected]>
www.8sens.com
<applewebdata://B444B0D1-661A-4889-BCDA-BEF28AC3F693/www.8sens.com>
N'imprimez ce message que si nécessaire, pensez à l'environnement.
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
