>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
Please show SQL select statement with any pertinent code.
Previous
Next
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