Nadya,
How can a table have multiple fields with the same name?
Just curious to know, how do you do this in your post-processing code?
>For cases like this we have a special post-processing altering table structure code. It changes all columns with _a to just fieldname. Send me a letter to work, I'll send you the code on Monday.
>
>Could be a Wish List for Toledo.
>
>>In sql server/transact sql when a query such as:
>>
>>select * from sosord, sostrs where sosord.csono=sostrs.csono
>>
>>is executed, the key value appears once in the result set as csono. In vfp you end up with csono_a, and csono_b.
>>
>>If I want my cursor result to be 'clean' and not have the underscores, then I need to explicitly name all the columns, and include the key from only one of the tables, once. But this results in very long query statements. I wrote a little routine to retrieve all of the column names for a given table into a formatted select string, and put it on the clipboard. This helps speed things up, but I still would be able to use select *.
>>
>>Is there any syntax, or trick that I can use to shorten my select statements. E.g. I wish there was a keyword like
>>
>>select * from sosord, sostrs where sosord.csono=sostrs.csono NODUPLICATEKEYVALUES
>>
>>Is there a specific reason why VFP's sql is implemented so differently than TRANSACT-SQL in such a fundamental area?
- Jayesh