Mensaje
De
17/11/2006 12:57:38
Mike Yearwood
Toronto, Ontario, Canada
Toronto, Ontario, Canada
a
17/11/2006 11:26:45
General information
Foro:
Visual FoxPro
Category:
FoxPro 2.x
Título:
Miscellaneous
ID de la conversación:
01170730
ID del mensaje:
01170765
Views:
17
>We are in the process of modifiying a FP 2.5 which we have not worked on in a long time.
>When we open most of the tables and browse, many of the field names have been appended by an 'a' such as 'datereq' becomes 'datereqa'. When we modify the structure the field name is correctly 'datereq'. The 'select' command fails because it is looking for 'datereq' but 'datereqa' is extracted.
>We even tried opening the table in work area 'c' to see if 'c' would be appended but the field name is appended with an 'a'.
>
>Unfortunately we are under enormous pressure to complete these program modifications.
>
>Thank you for all suggestions.
A SQL command where two tables are joined and the same field name exists in both tables with give you field1_a, field2_a, field1_b, field2_b.
>When we open most of the tables and browse, many of the field names have been appended by an 'a' such as 'datereq' becomes 'datereqa'. When we modify the structure the field name is correctly 'datereq'. The 'select' command fails because it is looking for 'datereq' but 'datereqa' is extracted.
>We even tried opening the table in work area 'c' to see if 'c' would be appended but the field name is appended with an 'a'.
>
>Unfortunately we are under enormous pressure to complete these program modifications.
>
>Thank you for all suggestions.
A SQL command where two tables are joined and the same field name exists in both tables with give you field1_a, field2_a, field1_b, field2_b.