HELP: Query Advice

[Ruslan Zasukhin]

On 5/2/04 10:37 PM, "Ian Devaney" <idevaney at mac.com> wrote:

>>> 2, Once I have a cursor with all the data what is the best way to deal
>>> with it?
>> 
>> 
>>> In Valentina I can't say:
>>> 
>>> "lists.list_value as Prefix, lists.list_value as Suffix,
>>> lists.list_value as Country"
>> 
>>> So what do most people do in this situation?
>> 
>> You can use index to get field.
>> 
>>     field(1)
> 
> Just wondered if there was a better way. Will this be improved in later
> versions?

Yes. Valentina 2.0 can do

    select fld as alias

>> Also I wonder:
>>     do you have strong reasons to keep in the same column 'Value'
>>     data of different types? May be better to use 3 tables ?
> 
> You could be right. Just thought it might be tidier. I use a list table
> with key-value pairs:
> 
> contactPrefix - Mr.
> contactPrefix - Mrs.
> 
> country - Ireland
> country - UK
> 
> etc.
> 
> This works really well for most things and is very simple for editing
> etc..
> 
> Thanks,
> 
> Ian
> 

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------