Page 1 of 1
How add MS Word or any other file to MS SQL?
Posted: Thu 03 Nov 2005 13:31
by gizmos
How add MS Word or any other file to MS SQL? Can you exlain to simular Pictures Demos.
Posted: Fri 04 Nov 2005 12:28
by Ikar
Do you mean adding data to server table? It is similar to images. Or do you mean displaying?
Posted: Fri 18 Nov 2005 05:37
by gizmos
Yes adding any file to server table. Please give me any example.
Posted: Fri 18 Nov 2005 13:35
by Ikar
Use something like this
Code: Select all
MSQuery.Edit;
BlobField := MSQuery.FieldByName() as TBlobField;
BlobField.LoadFromFile(FileName);
MSQuery.Post;
Posted: Mon 28 Nov 2005 07:40
by gizmos
In MSSQL table's blobfield type is IMAGE. This time when running BlobField.LoadFromFile(FileName);
Giving me error.
Error was "Bitmap image is not valid."
What is my fault.
Posted: Mon 28 Nov 2005 10:56
by Ikar
This is TDBImage message. You should disconnect or delete this component to avoid the message.
Posted: Tue 29 Nov 2005 04:57
by gizmos
Tnks, It works.