[libRETS-users] Compact - Compact Decoded format question

[Agustin Garzon]

Thanks a lot Keith!

Would you be so kind to recommend (if any) a forum, list or something among those lines where programmers share their experiences in Rets targeted software implementations?  

Thanks for you patience and support.

Cordially,
Agustin Garzon


----- Original Message ----
From: Keith T. Garner <kgarner at crt.realtors.org>
To: For discussion and help for and by the users of the libRETS C++ library <librets-users at crt.realtors.org>
Sent: Wednesday, July 18, 2007 12:45:27 PM
Subject: Re: [libRETS-users] Compact - Compact Decoded format question

On 7/17/07 5:47 PM, Agustin Garzon wrote:
> I'm having problems understanding the differences between compact and
> compact decoded format.
> I've been through the rets specs and found general information, but I'd
> like to see how it relates to my current implementation.
> 
> The metadata shows me a table (Area, in Property > RESI) that is an INT
> data type.

You will also notice that its Interpretation is either Lookup or LookupMulti.

> When I perform the search, Area is returning a string, I guess it's
> because it's Decoded (it most people-readable), right?

Correct.

> So, it's making a conflict. So how do we deal with this? Is it possible
> that non CHARACTER fields contain strings?

Technically, its not a conflict based on the definition of COMPACT-DECODED.
 At the very least COMPACT-DECODED will decode the Lookup from its "native
representation" to its Short Value or Long Value.  Technically, it doesn't
follow the metadata, but that's the point of COMPACT-DECODED.

> Is it possible to get the actual INT from the field?

Yes, do your query with the format being forced to COMPACT.  If you need the
values, do the decoding on the client side using the Lookup and Lookup-Type
metadata.

> Is it possible to
> tell what fields may contain strings besides their declared data type?

In general, the only time this will happen is with Lookups or LookupMultis
when using COMPACT-DECODED.  However, I've seen an MLS format an integer
and/or decimal with a $ when the Interpretation was set to Currency for that
table.

> I hope you don't see this question too off-list-topic. I really
> appreciate your support.

Again, this was more about RETS in general rather than libRETS specifically,
but I didn't mind answering this one.

Keith

-- 
  Keith T. Garner - Managing Director - Center for REALTOR® Technology
   kgarner at realtors.org - 312-329-3294 - http://blog.realtors.org/crt

_______________________________________________
libRETS-users mailing list
libRETS-users at crt.realtors.org
http://mail.crt.realtors.org/mailman/listinfo/librets-users







       
____________________________________________________________________________________
Sick sense of humor? Visit Yahoo! TV's 
Comedy with an Edge to see what's on, when. 
http://tv.yahoo.com/collections/222
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.crt.realtors.org/pipermail/librets-users/attachments/20070718/f03dd0fb/attachment.html