Subject | Can't edit in grid after join |
---|---|
Author | slsolutions2002 |
Post date | 2002-01-29T21:04:31Z |
I have 2 tables joined as follows:
SELECT *
FROM COSTCATEGORIES C,
COSTCATEGORYDEFINITIONS
WHERE C.COSTCATEGORYNO=COSTCATEGORYNO
The COSTCATEGORIES table is displayed in a TIB_Grid. All works fine
except I can not edit any fieldd in the grid. If I remove the join
as follows:
SELECT *
FROM COSTCATEGORIES
I can now edit in the grid ?
Can anyone help ?
Thanks
SELECT *
FROM COSTCATEGORIES C,
COSTCATEGORYDEFINITIONS
WHERE C.COSTCATEGORYNO=COSTCATEGORYNO
The COSTCATEGORIES table is displayed in a TIB_Grid. All works fine
except I can not edit any fieldd in the grid. If I remove the join
as follows:
SELECT *
FROM COSTCATEGORIES
I can now edit in the grid ?
Can anyone help ?
Thanks