Hi
I have begun up-sizing an application to Postgres and now when I open my application and click on a field the cursor automatically tabs past the character textbox fields and stops on the nearest combobox or numeric textbox. If I try to tab around the application the same thing happens. If I run the same application using VFP tables everything works correctly.
In the up-sized version I am using SQL Pass through to create all the views and I can browse and edit the view data like normal but when I use the application I get these strange effects. The application code is the same because I can run the app either on VFP data or Postgres data.
I turned on EventTracking and I can see a different series of events:
The correct events:
47607.832, frmagusers003.conagusers.txtstd1.Message()
47607.833, frmagusers003.conagusers.txtstd1.MouseDown(1, 0, 596, 49)
47607.833, frmagusers003.Paint()
47607.849, frmagusers003.conagusers.txtstd1.MouseUp(1, 0, 596, 49)
47607.850, frmagusers003.conagusers.txtstd1.Click()
The following are the events in the misbehaving version:
47387.102, frmagusers002.conagusers.txtstd1.Message()
47387.103, frmagusers002.conagusers.txtstd1.MouseDown(1, 0, 618, 45)
47387.103, frmagusers002.Paint()
47387.119, frmagusers002.conagusers.txtstd1.RangeLow()
47387.119, frmagusers002.conagusers.txtstd1.RangeHigh()
47387.119, frmagusers002.conagusers.txtstd1.Valid()
47387.120, frmagusers002.conagusers.txtstd1.ProgrammaticChange()
47387.121, frmagusers002.conagusers.txtstd1.LostFocus()
47387.122, frmagusers002.conagusers.txtstd2.When()
47387.124, frmagusers002.conagusers.txtstd2.GotFocus()
47387.125, frmagusers002.conagusers.txtstd2.Message()
47387.125, frmagusers002.conagusers.txtstd1.MouseUp(1, 0, 618, 45)
47387.125, frmagusers002.conagusers.txtstd1.Click()
I have no idea why the control loses focus on a mousedown event triggering the RangeLow() event etc..
Has anyone seen this strange behaviour or have a possible explanation?
Thanks,
Simon
Simon White
dCipher Computing