Update or insert in adoquery with a join query
Posted on 2006-03-23
Sometimes things seem to be easy but they have another face and this is my new dilemma here.
I have a main table in my MS SQL 2000 that has two other joined to it
In my form I have a adoconnection + AdoQuery
This is my query:
SELECT CADUSO.RH_FUNC_NOME, CADUSO.RH_DEPTO_NOME,
CADUSO.RH_EMPRESA_NOME, AGENDA_USO_CONEX.AG_ID, AGENDA_USO_CONEX.AG_CODUSO
INNER JOIN CADUSO ON AGENDA_USO_CONEX.AG_CODUSO = CADUSO.RH_FUNC_ID
How can I do when I need to change the information? I have an error when I post. Can't I update, insert in Adoquery with
a join query?