Universal Data Type



Can anyone think of a way to store data into a database as a universal
(binary) datatype and then be able to retreive it later?

For example:

I would like to be able to take any field from any table (including memos)
and put it into this datatype.

Suppose I had the following tables:

MainTable
Name c(10)
Age n(3,0)
Notes m
Expire d
Member l

Universal
Data u (or whatever the universal data type is)

I would want to be able to:

Replace u with Name or
Replace u with Age or
Replace u with Notes or
Replace u with Expire or
Replace u with Member

Right now the best I can come up with is to use a memo field and do
conversions for numeric, date, datetime, and logical fields.

Can anyone think of anything better?

Thanks,
Jeff


.



Relevant Pages

  • Re: Universal Data Type
    ... > and put it into this datatype. ... > Expire d ... > Replace u with Member ... > Right now the best I can come up with is to use a memo field and do ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Universal Data Type
    ... You'll have to use a binary memo field for u. ... > Expire d ... > Replace u with Member ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Universal Data Type
    ... Check out SAVE TO MEMO. ... > and put it into this datatype. ... > Expire d ... > Replace u with Member ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Memo Fields through DDF Builder
    ... Bill, ... I can create the Memo field as the last field of my table. ... after I am done with creating DDFs for all the fields in that table ... the datatype as 'Note'. ...
    (comp.databases.btrieve)
  • Re: How can I override Memo field size default to make it larger??
    ... To change a TEXT field to a MEMO field, go to table design view and reselect ... the datatype. ...
    (microsoft.public.access.gettingstarted)