Re: Universal Data Type

Jeff,

You'll have to use a binary memo field for u. Your Universal table will
probably also need type and fieldname columns so that you can retrieve the
data later and correctly interpret it. But I'm with Christophe on this one,
why would you want to do this?

--
df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro

"Jeff Grippe" <jgrippe@xxxxxxxxxxx> wrote in message
news:11da5bkseuslecd@xxxxxxxxxxxxxxxxxxxxx
> 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)
  • Universal Data Type
    ... and put it into this datatype. ... 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 ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Memo Problem
    ... member => many comments) would be the best solution. ... It woudl be normalized, ... both showing the same memo field, and you are trying to edit in both forms. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Memo fields in a query
    ... Are the names in the memo field separated by comma or some other punctuation? ... I suppose this is why you need to compare? ... Member ID ... entries in the tblAttendees table. ...
    (microsoft.public.access.queries)
Loading