Can't Edit Query Result

[PhaseTwenty]

I ran a query that looks like this:

Code:

SELECT aa.`name`, ap.`scanline_setup`
FROM aa, ap
WHERE aa.`id` = ap.`association_id` AND `customer_id` = 17
ORDER BY aa.`name`;

aa.`name` and ap.`scanline_setup` are not primary keys. I also made sure to use Edit and Execute Resultset / F8.

I tried to edit the values of scanline_setup in the result tab and it won't let me. I switched to Form view and the field is not editable. Is there something I'm missing?

[ashwin]

Hello,

Quote:

I tried to edit the values of scanline_setup in the result tab and it won't let me. I switched to Form view and the field is not editable. Is there something I'm missing?

As you are having two tables in resultset, Result tab will contain a combo-box that allows you to choose table to edit. This table columns are highlighted and all other columns are grayed. Please refer attached screen-shot.

Regards,

Ashwin A

[PhaseTwenty]

Ah, I didn't notice that. Too bad it doesn't just automatically know which table a column came from and didn't require me to select it first. Thank you for the response.

[Author]

Posts