>I am forming a SQL select for a report on two tables which are in a multiple to multiple
>relationship (thru a third, cross reference table). (In VFP 5.0a).
>
>One list contains equipment and the other (engineering) drawings for the equipment.
>Each piece of equipment can have more than one drawing and each drawing can be for more than one
>piece of equipment.
>
>When I run the SQL I get drawings assigned to more pieces of equipment than they should.
>
>The drawing key is of a form "dr00000v" were "dr" is for drawing and the remaining characters
>can be any number, upper case or lower case character. Keys are assigned in sequence
>from a common table as needed.
>
>That is "dr000001" , "dr000002" etc.
>
>The problem extra drawings occur becuase VFP seems to believe that "dr00000v" and "dr00000V"
>are equal as well as others where the last character is different only in being a different
>case.
>
>Please try it. When I run the following from the command window I get .T. as a response to
>? ctemp1 = ctemp2.
>
>ctemp1 = "dr00000v"
>ctemp2 = "dr00000V"
>? ctemp1 = ctemp2
>
>Please, what is happening?
>
>It does not help to place "set exact on"
>
>It has only happended since yesterday when I loaded version VFP 5.0a. It did not seem to happen
>under version 5.0.
>
>Am I missing something?
>
>Best Regards Don
Don,
Check the value of SET('COLLATE'). If SET('COLLATE') equals 'GENERAL', then ? 'v' = 'V' will return .T. If it's 'MACHINE' it will return .F.
hth,
George
George
Ubi caritas et amor, deus ibi est