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