Here is my custom SQL:
select A.[stdnt_enrl_pk],
A.[person_pk],
A.[acad_car_pk],
A.[term_pk],
A.[term_sess_pk],
A.[crse_sect_pk],
A.[grade_pk],
A.[number_grade],
A.[hours_absent],
A.[note]
From [dbo].[SRM_STDNT_ENRL] A inner join [dbo].[SRM_PERSONS] B
on A.person_pk = B.person_pk
When I VIEW or ADD a record everything works fine. But, if I try to EDIT a record, I get this error:
<<< Record was NOT updated >>>
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'A' does not match with a table name or alias name used in the query.
I have tried every possible thing I can think of to resolve this but I keep getting the error.
Thanks.
I just noticed that it has nothing to do with the join. It happens with saving an edit, even on a single table, when I am using an alias:
select A.[stdnt_enrl_pk],
A.[person_pk],
A.[acad_car_pk],
A.[term_pk],
A.[term_sess_pk],
A.[crse_sect_pk],
A.[grade_pk],
A.[number_grade],
A.[hours_absent],
A.[note]
From [dbo].[SRM_STDNT_ENRL] A
When Saving an edit, the same error occurs:
<<< Record was NOT updated >>>
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'A' does not match with a table name or alias name used in the query.
If I remove the alias, everything is OK.
But, I need to use an alias if I am working with joins to display fields from different tables.
Is this a known issue? Please help. Thanks.