1 Reply Latest reply on Oct 23, 2003 11:15 PM by 403468

    Problem with tables having identical field names

      I was having some major problems selecting fields from two different tables with identical field names.

      e.g. SELECT A.Name, B.Name from TABLE1 A, TABLE2 B WHERE...
      I passed the above statement to open a dynaset, and used the function GetField(0) and GetField(1) to retrieve the names.
      End result was both OFields held the content of B.Name?!?

      I know the problem can be corrected by using aliases, but it would mean a lot of changes to our existing application...
      Is there any ways to get around that? If I did the same query in the worksheet, it returned the right result; which need me to believe there're some bugs in OO4O.

      Any comments or ideas will be appreciated!