Re: Blobs - Now is Field Reference File

What clause would I use on a CREATE TABLE command to access these 
UDF's?  Are these promptable when using the CREATE TABLE command 
from within STRSQL?





jpcarr@tredegar.com on 08/20/99 09:19:30 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: Blobs - Now is Field Reference File



>John P Carr wrote:
>> Rob
>> While you were going Gung Ho for SQL file creations,   How did you do
that
>> REFFLD thing again?   So you only had ONE definition of (say) invoice
>> number on your box???   SQL does that real nice huh?
>> 
>> Tongue_In_Cheek(*out)

Bruce said;
>Laugh, but the SQL equivalent is the User Defined Fields. These UDF's
>permit you to not only build that ONE invoice number, but also allows
>you to specify that you can not do any arithmetic other than bump it by
>1. So, nobody adding or multiplying an invoice number TYPE.
>Objects for the data!
>R. Bruce Hoffman@rbruceh on 08/20/99 01:07


Ya,  I know about the User Defined Fields.   I have talked to Kent and Mike
at
length about them.   They still pale in comparison to a "traditional
FieldRef file" IMHO

All my fields in my data base are in my Fieldref.   I have a "Domain" area
of the 
fieldref that defines all unique field(Attribute) types.  All fields in ALL
files
refer to that one definition. (DSPF, PF, ICF, PRTF, and Templates for
Parameters)

For example,  I have a QUANTITY field defined as  (say) 11,3  packed

All instances of the Attribute QUANTITY refer to that one definition.
However, I may want one particluar instance to be 7,0 Zoned but still be 
referenced to the Quantity field(because it is a Quantity).  

Being able to override certain aspects of an Attribute for a particular
instance is very powerful.  Like DFT, TEXT, LENGTH, DECIMAL, TYPE(cast
function), 
etc.   The ease of doing it, looking it up, etc still in my mind 
is way far better than the current implementaion of User Defined Fields.

You get the idea, I'm sure.  

John Carr
The "REAL" EdgeTech

You lose yourself,  You reappear,  You suddenly find you have nothing 
to fear,   Alone you stand with nobody near,  When a trembling distant voice

unclear,   Startles your sleeping ears to hear,  That somebody thinks they 
really found you.

Though the rules of the road have been lodged,  It's only people's games
you have to dodge.....   

It's Alright Ma,  I'm Only Bleeding.











+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---