Re: Universal Data Type

Jeff,

Replace With Transform(anyvalue)
is suitable for this.

And what will be the purpose to do this ?

regards
christophe
--
\|||/
(o o)
----ooO-(_)-Ooo-------------


"Jeff Grippe" <jgrippe@xxxxxxxxxxx> schreef in bericht
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

  • 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: 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 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)