General information
Title:
Database Explorer wiping out info in views
Hi,
I am using SDT in my VFP/VMP projects.
I use the "captions" of fields in views for column headers in grids and also often have a "FILTER" button on screens that invokes SFQuery...where users see the captions as fields on which to filter.
A client reported that the captions were being lost, so that they would just see "CODE", "CODE", "CODE" in a number of grid column headings and filter field names. (These are 3 different fields from a lookup table, things like business code, SIC, location code, etc.).
I repaired the view and sent them a new copy (this had happened in 3 different views/screens and i coudln't figure out HOW).
Now i see that when i make a change to a field in a table that is in a view, ALL the captions and comments revert to the original values from ALL the tables in the view. All i did was chagne a single field from 30 to 40 characters, and sure enough, i again lost my nice captions and comments (the comment field is important, as the text "*:SFQUERY NOFILTER" is there to tell SFQuery not to display that field as a filterable field, in many cases, primary keys, etc.).
Please help! i don't want to continaully redefine my view every time i make a change to a table!
Thanks, Jill
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only