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.
