General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Nadya,
Disregard my reply to you. I asked if it handled _b, _c, etc. Its obvious now that you leave them in and just change the _a to the original, and don't remove the _b, _c.
Thanks
>The original table after SQL has fields like
>PropID_a, SiteID_a, ..., PropID_b, SiteID_b
>
>The result of the program is:
>
>PropID, SiteID, PropID_b, SiteID_b
>
>I'm too tired to look for this program right now (still at work). I'll send the code on Monday.
>
>>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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only