10.09 changes in designer
Hi
V10.09 in D6
There seems to be a change in designer behaviour which is a bit of a
nuisance.
DB aware components normally show the field name. I cant remember what
happened when you clicked on one before but it didn't cause any problems.
In 10.09 it tries to open the query,
if this contains valid SQL and the connection is fast and the fields contain
something meaningful - data is displayed, that can be helpful if you prefer
to see the data as opposed to the field names. The control is probably
attached to cursor as below but doesn't cause a problem unless mouse
movement is very rapid.
if this contains valid SQL and the connection or the SQL is slow - the
control attaches itself to the cursor and is dragged if the mouse is moved.
You cant see this until the query has finished opening.
if the SQL is invalid - all the controls become empty
if the connection to the database is down - repeated error messages at a few
second intervals until the designer is closed.
This behaviour only happens the first time a form is opened and the designer
opened. In order to repeat it the form has be closed then reopened.
Is there a way of switching off this behaviour? If I want to see data I can
set the queries to active in the form. Maybe an autoconnect option in the
designer would be useful for those that don't want these problems?
Regards
Paul
V10.09 in D6
There seems to be a change in designer behaviour which is a bit of a
nuisance.
DB aware components normally show the field name. I cant remember what
happened when you clicked on one before but it didn't cause any problems.
In 10.09 it tries to open the query,
if this contains valid SQL and the connection is fast and the fields contain
something meaningful - data is displayed, that can be helpful if you prefer
to see the data as opposed to the field names. The control is probably
attached to cursor as below but doesn't cause a problem unless mouse
movement is very rapid.
if this contains valid SQL and the connection or the SQL is slow - the
control attaches itself to the cursor and is dragged if the mouse is moved.
You cant see this until the query has finished opening.
if the SQL is invalid - all the controls become empty
if the connection to the database is down - repeated error messages at a few
second intervals until the designer is closed.
This behaviour only happens the first time a form is opened and the designer
opened. In order to repeat it the form has be closed then reopened.
Is there a way of switching off this behaviour? If I want to see data I can
set the queries to active in the form. Maybe an autoconnect option in the
designer would be useful for those that don't want these problems?
Regards
Paul
This discussion has been closed.
Comments
Try setting the View | Show Data menu option to turn off live design-time
data.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
View|Show data is already off.
Regards
Paul
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Sorry for delay - been away.
AutoCreateFields was True.
I've just done some more testing. This is always on a newly opened form
since it behaves differently second time round. Reminder of the problem -
when clicking on a ppDBText the control gets dragged by the screen cursor
while the SQL opens.
It looks like -
View|Show Data is not persistent. When opening the designer it is always
off.
if AutoCreateFields is false then no data is displayed - even if View|Show
Data is selected.
if AutoCreateFields is True then the probem occurs. View|Show Data hasn't
been switched on.
Regards
Paul