[SetDatabaseBlob] bug?

Just starting out? Need help? Post your questions and find answers here.
kinglestat
Enthusiast
Enthusiast
Posts: 732
Joined: Fri Jul 14, 2006 8:53 pm
Location: Malta
Contact:

[SetDatabaseBlob] bug?

Post by kinglestat »

I am trying out blobs with PB...and I am having difficulties and wondering if there is a bug
I am using LONGTEXT since I need to use fulltext searching which is a form of BLOB

Code: Select all


sql = "CREATE TABLE emailbodystore ( id INTEGER PRIMARY KEY,"
         sql + "subject VARCHAR(200), body LONGTEXT, FULLTEXT ( subject,body) )"
         sql + " ENGINE MyIsam"



SetDatabaseBlob( gODBCdb, 0, NewPtr, NewSize )
   sql = "INSERT INTO emailbodystore ( id, subject, body )"
   sql + " VALUES ("
   sql + Str( id ) + ","
   sql + "'" + EmailInfo\szSubject + "',"
   sql + "? );"

Yet I get "not an error" error when I try to add

UPDATE:
Actually I get an error "MySQL server has gone away"
But It certainly is not the case as I am connected to it and can do queries etc


Is there a bug? or not supported?
I may not help with your coding
Just ask about mental issues!

http://www.lulu.com/spotlight/kingwolf
http://www.sen3.net