[Rets-dev] How to calculate field sizes

[Allen Schmidt Sr.]

Thanks Sergio,

But this only gives the lookup field size of 11 or 15 which is the ssize
of the lookup ID. Any way to get the absolute largest size of a field
that could be returned from a COMPACT-DECODED query?
And I can only use COMPACT with this. COMPACT-DECODED does not work.

Allen


Sergio Del Rio wrote:

> This is all provided in the metadata. Use the GetMetadata command with
> Type=METADATA-TABLE and ID= to one of the following values:
> 
> 	Property:ALL
> 	Property:RES
> 	Property:LOT
> 	Property:MF
> 	Property:COM
> 
> This will give you the metadata that has all the max sizes you need.
> 
> I have attached a file from the ALL Class which is the cross property search
> that includes a super set of all the columns from each of the remaining 4
> property types.
> 
> Regards,
> Sergio Del Rio
> Templates 4 Business Inc.
> 
> 
> -----Original Message-----
> From: Allen Schmidt Sr. [mailto:aschmidt at fredericksburg.com] 
> Sent: April 4, 2007 10:03 AM
> To: JP Fielding
> Cc: Sergio Del Rio; Rets-dev at rets.org
> Subject: Re: [Rets-dev] How to calculate field sizes
> 
> Thanks for the assistance with this guys. I really appreciate it.
> 
> I think what I am trying to get a hold of is something that I can use 
> with compact-decoded data from MRIS that will give me the field names 
> and the max field size of data that can be returned on that call. Then 
> from that, I will build out my SQL tables to store that data. Using 
> MySQL I can just say there are 500 columns of varchar(255) to create the 
> table as that would make the rows too long.
> 
> Does something like this exist? Or an 'easy' way to find it out?
> 
> Thanks
> 
> Allen
> 
>