How can I store files in a field? 
Author Message
 How can I store files in a field?
I want to be able to store a Word document with a record.
How can this be accomplished?

Thanks,
Ash



Mon, 29 Dec 2003 00:45:06 GMT
 How can I store files in a field?

Ash,

Check out "Storing BLOB" in book online.  Basically, you will have to create
an Image datatype column in your table to store the files.  Performance and
fragmentation will be an issue if you choose to go this route.  My
*prefered* route would be storing the files outside of Sql server but have a
table with all details about the files (i.e. relative path, file size, name,
etc).

-oj


Quote:
> I want to be able to store a Word document with a record.
> How can this be accomplished?

> Thanks,
> Ash



Mon, 29 Dec 2003 00:56:43 GMT
 How can I store files in a field?
Just as a thought...
You may find it more practical to store the filename in a
Record and (using automation) store and open the files
when needed? Otherwise you may face a really huge db.
Mike.
Quote:
>-----Original Message-----
>I want to be able to store a Word document with a record.
>How can this be accomplished?

>Thanks,
>Ash

>.



Mon, 29 Dec 2003 01:07:46 GMT
 How can I store files in a field?
Do you have an example of storing and referencing the files which you would
share with me?


Quote:
> Ash,

> Check out "Storing BLOB" in book online.  Basically, you will have to
create
> an Image datatype column in your table to store the files.  Performance
and
> fragmentation will be an issue if you choose to go this route.  My
> *prefered* route would be storing the files outside of Sql server but have
a
> table with all details about the files (i.e. relative path, file size,
name,
> etc).

> -oj



> > I want to be able to store a Word document with a record.
> > How can this be accomplished?

> > Thanks,
> > Ash



Mon, 29 Dec 2003 01:11:56 GMT
 How can I store files in a field?
When you say use automation what do you mean?
I need to be able to open the file modify it and then resave it without
specifying any paths or such at least that the user is concerned with.


Quote:
> Just as a thought...
> You may find it more practical to store the filename in a
> Record and (using automation) store and open the files
> when needed? Otherwise you may face a really huge db.
> Mike.

> >-----Original Message-----
> >I want to be able to store a Word document with a record.
> >How can this be accomplished?

> >Thanks,
> >Ash

> >.



Mon, 29 Dec 2003 01:23:21 GMT
 How can I store files in a field?
Ash, the problem isn't really with storing details about
the file, that should be easy to get, and then you just
store the details as a record.
However, in regard to referencing that file, what is your
app in - vb6 etc.?
Based on that, we can help you work out how to use
automation or the like to actually open that file for the
user to make changes to it.
If you give us some more details about your environment,we
can give you some more details about how to go about this.

Sara

Quote:
>-----Original Message-----
>Do you have an example of storing and referencing the

files which you would
Quote:
>share with me?



>> Ash,

>> Check out "Storing BLOB" in book online.  Basically,
you will have to
>create
>> an Image datatype column in your table to store the
files.  Performance
>and
>> fragmentation will be an issue if you choose to go this
route.  My
>> *prefered* route would be storing the files outside of
Sql server but have
>a
>> table with all details about the files (i.e. relative
path, file size,
>name,
>> etc).

>> -oj



>> > I want to be able to store a Word document with a
record.
>> > How can this be accomplished?

>> > Thanks,
>> > Ash

>.



Mon, 29 Dec 2003 01:54:47 GMT
 How can I store files in a field?
I was thinking you could have a button appear on the Word
doc (when you open it) that the user can click once they
have finished editing the document. The button would
automatically re-save the document for them with your
chosen file name and close the Word application.

When you get into this you will probably find a way to
trap any instance of EXIT or SAVE from the word menus as
well!

I've forgotton how to get the list of commands (but they
are available in the Word / SQL help files). However, I do
have a good book at home! I'll check this out tonight. If
you have no success, check this board tommorrow and I'll
post a solution for you to try.

Microsoft does have a fairly good system of automation
between its products (COM). Although you may find a few
quirks/differences in the methods used to open (for
example) a Word doc or an Excel.

Good luck
Mike

Quote:
>-----Original Message-----
>When you say use automation what do you mean?
>I need to be able to open the file modify it and then
resave it without
>specifying any paths or such at least that the user is
concerned with.



>> Just as a thought...
>> You may find it more practical to store the filename in
a
>> Record and (using automation) store and open the files
>> when needed? Otherwise you may face a really huge db.
>> Mike.

>> >-----Original Message-----
>> >I want to be able to store a Word document with a
record.
>> >How can this be accomplished?

>> >Thanks,
>> >Ash

>> >.

>.



Mon, 29 Dec 2003 02:08:13 GMT
 How can I store files in a field?
I'm building an intranet based web application using active server pages.
I'm quite comfortable talking to SQL server through asp, but not with files.

Below is an example work flow:
1. Create a record and attach a file.
2. Someone else reviews and modifies the attachment then approves the
record.
3. Original record creator opens and prints the document.
4. Record is stored for history.

Thanks,
Ash


Quote:
> Ash, the problem isn't really with storing details about
> the file, that should be easy to get, and then you just
> store the details as a record.
> However, in regard to referencing that file, what is your
> app in - vb6 etc.?
> Based on that, we can help you work out how to use
> automation or the like to actually open that file for the
> user to make changes to it.
> If you give us some more details about your environment,we
> can give you some more details about how to go about this.

> Sara

> >-----Original Message-----
> >Do you have an example of storing and referencing the
> files which you would
> >share with me?



> >> Ash,

> >> Check out "Storing BLOB" in book online.  Basically,
> you will have to
> >create
> >> an Image datatype column in your table to store the
> files.  Performance
> >and
> >> fragmentation will be an issue if you choose to go this
> route.  My
> >> *prefered* route would be storing the files outside of
> Sql server but have
> >a
> >> table with all details about the files (i.e. relative
> path, file size,
> >name,
> >> etc).

> >> -oj



> >> > I want to be able to store a Word document with a
> record.
> >> > How can this be accomplished?

> >> > Thanks,
> >> > Ash

> >.



Mon, 29 Dec 2003 04:05:14 GMT
 How can I store files in a field?
Ash,

#1: create a table with at least 3 columns to store details for the
attachment
    -filepath
    -filename
    -filetype (DOC, TXT, ETC)
#2: when someone reviews the record, you just need to query the table for
the filepath/name/type and present the attachment for editing
#3: this is very much the same as #2
#4: update the table to reflect any changes as far as filepath/name/type

-oj


Quote:
> I'm building an intranet based web application using active server pages.
> I'm quite comfortable talking to SQL server through asp, but not with
files.

> Below is an example work flow:
> 1. Create a record and attach a file.
> 2. Someone else reviews and modifies the attachment then approves the
> record.
> 3. Original record creator opens and prints the document.
> 4. Record is stored for history.

> Thanks,
> Ash



> > Ash, the problem isn't really with storing details about
> > the file, that should be easy to get, and then you just
> > store the details as a record.
> > However, in regard to referencing that file, what is your
> > app in - vb6 etc.?
> > Based on that, we can help you work out how to use
> > automation or the like to actually open that file for the
> > user to make changes to it.
> > If you give us some more details about your environment,we
> > can give you some more details about how to go about this.

> > Sara

> > >-----Original Message-----
> > >Do you have an example of storing and referencing the
> > files which you would
> > >share with me?



> > >> Ash,

> > >> Check out "Storing BLOB" in book online.  Basically,
> > you will have to
> > >create
> > >> an Image datatype column in your table to store the
> > files.  Performance
> > >and
> > >> fragmentation will be an issue if you choose to go this
> > route.  My
> > >> *prefered* route would be storing the files outside of
> > Sql server but have
> > >a
> > >> table with all details about the files (i.e. relative
> > path, file size,
> > >name,
> > >> etc).

> > >> -oj



> > >> > I want to be able to store a Word document with a
> > record.
> > >> > How can this be accomplished?

> > >> > Thanks,
> > >> > Ash

> > >.



Mon, 29 Dec 2003 15:23:23 GMT
 How can I store files in a field?
Thanks, I will give it a try today.


Quote:
> Ash,

> #1: create a table with at least 3 columns to store details for the
> attachment
>     -filepath
>     -filename
>     -filetype (DOC, TXT, ETC)
> #2: when someone reviews the record, you just need to query the table for
> the filepath/name/type and present the attachment for editing
> #3: this is very much the same as #2
> #4: update the table to reflect any changes as far as filepath/name/type

> -oj



> > I'm building an intranet based web application using active server
pages.
> > I'm quite comfortable talking to SQL server through asp, but not with
> files.

> > Below is an example work flow:
> > 1. Create a record and attach a file.
> > 2. Someone else reviews and modifies the attachment then approves the
> > record.
> > 3. Original record creator opens and prints the document.
> > 4. Record is stored for history.

> > Thanks,
> > Ash



> > > Ash, the problem isn't really with storing details about
> > > the file, that should be easy to get, and then you just
> > > store the details as a record.
> > > However, in regard to referencing that file, what is your
> > > app in - vb6 etc.?
> > > Based on that, we can help you work out how to use
> > > automation or the like to actually open that file for the
> > > user to make changes to it.
> > > If you give us some more details about your environment,we
> > > can give you some more details about how to go about this.

> > > Sara

> > > >-----Original Message-----
> > > >Do you have an example of storing and referencing the
> > > files which you would
> > > >share with me?



> > > >> Ash,

> > > >> Check out "Storing BLOB" in book online.  Basically,
> > > you will have to
> > > >create
> > > >> an Image datatype column in your table to store the
> > > files.  Performance
> > > >and
> > > >> fragmentation will be an issue if you choose to go this
> > > route.  My
> > > >> *prefered* route would be storing the files outside of
> > > Sql server but have
> > > >a
> > > >> table with all details about the files (i.e. relative
> > > path, file size,
> > > >name,
> > > >> etc).

> > > >> -oj



> > > >> > I want to be able to store a Word document with a
> > > record.
> > > >> > How can this be accomplished?

> > > >> > Thanks,
> > > >> > Ash

> > > >.



Mon, 29 Dec 2003 21:59:19 GMT
 
 [ 10 post ] 

 Relevant Pages 

1. Cans access2.0 engine access btrieve files?

2. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

3. Anyone know of some canned (cheap or free) DB performance testing software

4. Switching from inhouse to canned package.

5. bcp canned app

6. Canned PARADOX scripts?

7. canned code to get db on web quickly via perl or

8. MDX : Canned Report or OLAP

9. Viruses in Files Stored in Field With Image Datatype

10. store a file in a table field

11. storing huge text files as fields - how ??

12. Storing binary file data in a Jet memo field


 
Powered by phpBB® Forum Software