Urban Research
Jump To: SQL Utility - Software
Other: Add Incident to SQL Utility Database
About: Submit Information about SQL Utility

Urban SQL Utility - Incident Detail  

SeverityPriorityStatus
MediumMediumFixed

Urban SQL Utility - Incident Details (As Reported)  
Description: Dropping column breaks Open Table
Reported By: [hidden]
Date Reported: 2000-07-28
Version: 1.0.1.68
Report Method: WWW::FormSubmission
Details: If a table structure is changed (drop column), then I try to
open the table for editing with the Open Table function, I get
the error message...

General SQL error.
[TCX][MyODBC]Unknown column '[name of dropped column]' in 'field
list'

It looks like Open Table is getting the field list from memory
and not updating it when the table structure is changed. I
think I also may have used Open Table on this column before
changing the structure, but I'm not sure.

Greg


Urban SQL Utility - Incident Status Details  
Resolution: Fixed
Fixed By: jeu
Fixed in Version: 1.0.1.80
Fixed Date: 2000-10-23
Details: Modified program to force an update of the underlying table
schema when dropping or modifying columns.


Home | E-Mail | Request Info

© 1996,1997,1998 Urban Research. All rights reserved.