SqlDbx
You are not logged in.
Pages: 1
Would be very usefull, edit the query result. It 'is posibble to apply this of many ways.
1) Close to "Execute button" a "Execute and edit button"
2) rigth click on the result grid and select "edit result" or "edit mode"
3) etc.
Offline
You can edit table data now.
I am not sure why would you want to edit query results?
Offline
In the query i can select only some attributes, and filter by any of them. This way I am seeing what i want to modify and do that.
I'm sorry for my limeted English
Offline
I am still not sure I understand.
Can you provide an example.
Offline
it is more easy do that
Select Invoiceid, InvoiceDate, InvoicePrice, CustomerId
From Invoice
Where Invoiceid = 2285
I see in the result grid that the id, date and price match, then I set (in the grid ) customerid = 44
if i have to do this:
update invoice
set customerid = 44
where invoiceId = 2255
I can make a mistake typing (the correct id is 2285) and do not realize that is not the record I want to correct
Offline
Now it is clear to me.
So currently we do have option to edit data in a table, but
what you want to do is to select only couple of records and
be able to edit them. May be we can add an option in Grid "Edit results" and
if we can figure out table name and key columns are included in results then we
can allow edit
Offline
you can also right click on the column in the results and select generate update. Then you can change the value for the set statement. It is an extra step but works to acomplish the task. If you are having to do this on a regular basis I could see having that feature would be very usefull
Offline
Pages: 1