I
Islam Elkhayat
In my web application i have a datagrid which fill Cities and have a forign
key to Country table... here is the query:
SELECT A.ID, A.A_NAME, A.E_NAME, B.A_NAME AS COUNTRY, A.PHONE_CODE FROM
hrc_city AS A "+
"INNER JOIN hrc_country AS B ON B.ID=A.COUNTRY".
In edit mode i display country name in a dropdown list using another query
from country table, i have to problems.
1- After i edit any row of the grid except first row.. i found the row i
edit twice, one in the top first row whth the updated data
and another one in the orignal row with the old data!!
2- the updated data display the id of the country instead of the name...
if the grid became in the edit mode again (even if i didn't edit anything)
everything get fixed and displayed correctly the right row with the right
country name!!!!
What's wrong... do i miss something??
Help please
regards
key to Country table... here is the query:
SELECT A.ID, A.A_NAME, A.E_NAME, B.A_NAME AS COUNTRY, A.PHONE_CODE FROM
hrc_city AS A "+
"INNER JOIN hrc_country AS B ON B.ID=A.COUNTRY".
In edit mode i display country name in a dropdown list using another query
from country table, i have to problems.
1- After i edit any row of the grid except first row.. i found the row i
edit twice, one in the top first row whth the updated data
and another one in the orignal row with the old data!!
2- the updated data display the id of the country instead of the name...
if the grid became in the edit mode again (even if i didn't edit anything)
everything get fixed and displayed correctly the right row with the right
country name!!!!
What's wrong... do i miss something??
Help please
regards