Results field add commas to the numeric values. Is there a way to keep the program from applying a format to numbers in the query grid when I click on them? (4232322)

The result set displays numeric values without commas in the grid, but when clicking into the field, it adds commas to the result. This makes it difficult to copy/paste ID rows for lookups.

e.g. displays as 6510200000098276 but changes to 6,510,200,000,098,276

This may be an issue depending on the platform connected.

WORKAROUND:

Go to Tools | Options | Environment | Grid. 

Set the formatting for Number, in the custom section:

e.g. #########

(Should work for Oracle, SQL Server, other. This may not work for other connections,  MySQL, ASE Sybase, ODBC, other). 

STATUS:

This issue is fixed in Toad Data Point 4.0. This version can be downloaded from the downloads section of our website, which you can access by clicking here.