RE: Error 1005 when adding a Foreign Key

2004-07-02 Thread Héctor Maldonado
Hi, Check if column PlanName is the primary key (and the only one) in table testplans. If so, check if both fields PlanName in testplans and PlanName in runload_list are exactly of the same type and size. Regards, Hector -- Ing. Hector Maldonado Melgar Dpto. Desarrollo de Software TCI S.A.

Re: how to insert blob data remotely.. SOLVED :)

2004-07-01 Thread Héctor Maldonado
Hi Again.. Fortunately I found a way to do this using C++/Qt. Here's the code for who are interested in: QFile *myFile; QSqlQuery query; QString strQuery; QByteArray myByteArray; // open the image and fill the bytearray myFile = new QFile("/root/hm/variostepsa/fotos_marcopolo/paradi

how to insert blob data remotely

2004-07-01 Thread Héctor Maldonado
Hi all!.. How can I insert blob data (specifically a jpg image) into a blob field remotely?.. I mean, the client has to choose a jpg image in his/her PC and upload it to the server. I found this piece of code: INSERT INTO car_models (Brand, Picture) VALUES ('Subaru Impreza', LO