We have been using Paradox for a long time now, and are trying to
"upsize" much of our current system to Sybase SQL Server 10, while
maintaining PdxWin as the front end. The good news is that it basically
works. The bad news...
There sometimes are very long (~3") delays between certain operations
involving forms that are linked to Sybase tables. The forms will work
fine for moving through rows and editing data. However, we get these
long delays when (a) locating a record through the built-in "zoom", (b)
switching from view<-->design, (c) sometimes saving data will take a long
time. The problems are not very consistent, except for the long delay in
locating records. In fact, the locate does not always work either. The
locate problem is not found on a straight table view, although the save
problem sometimes is. Queries work great.
Does anyone have any experience with such problems? We are using PdxWin
5.0, SQL Links 2.0, Sybase SQL Server 10 (on Sun LX), and the latest
IDAPI driver. I have heard of at least one ODBC driver that works much
better than the "native" IDAPI driver -- anyone else?
Thanks in advance,