Viatcheslav V. Vassiliev
Guest
|
 Posted: Fri Oct 24, 2003 6:49 pm Post subject: Re: Need help storing a Microsoft Word or Excel Document in |
 |
|
Use query with parameters and LoadFromStream()/SaveToStream() method of
TParam or TParameter object.
//----------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Randel Bjorkquist" <rbjorkquist (AT) coilcraft (DOT) com> сообщил/сообщила в новостях
следующее: news:3f997348 (AT) newsgroups (DOT) borland.com...
| Quote: | Hi all,
I am looking for some help to get both, a Microsoft Word and Excel
documents
into an SQL Server database without using data aware controls. I have
been
able to get an image into the database, via copying and pasting an image
into a TDBImage control while having a life dataset.
I am not looking for some help to get these other documents and images
into
the database without using data aware controls. I'm honestly not sure
what
the SQL statement would look like either. How do I assign a binary value
or
build my SQL statement on the fly and use a binary value.
INSERT INTO TestTable (Pic, PicDesc, WDoc, WDocDesc, EDoc, EDocDesc)
VALUES(??????, "BlueMoon.jpg", ??????, "Doc1.doc", ??????, "Excel1.xls")
I have an Image field set up in a Microsoft SQL 2000 Server database. I'm
building my application using CBuilder 6.0 Enterprise.
Thanks for any and all help in advance,
Randel Bjorkquist
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
