Pervasive Community Site
Community Forum (formally DEVTALK) – Join the ever- growing Pervasive community in a lively, interactive e-nvironment where users can come together and discuss their choice of topics on Pervasive-based products. Participants include Developers, Resellers, System Integrators, and End User and Pervasive team members.
Component Zone – Download the latest utilities and tools posted by third-party vendors. The Zone is your quick stop for getting the latest tools our partners have to offer.
This is a Bug and a defect has been submitted.
I can confirm this as well with v12.01.022 on both the Windows and Linux machines. It is only with this column. It is being looked into.
I did the test with v12.01.022 on both Windows and Linux and could not recreate the issue.
I concur. The sorted order always seems to be the connection order. If I open up a file from three computers, the order is always: PC3 PC2 PC1 If I then open up a SEPARATE session from PC1 (using a new task id), I can then generate: PC1 PC3 PC2 PC1 All of this is regardless of whether I sort in ascending or descending order. I ran my tests on v12.01...
Do you see the column DEFAULT statements in the "SQL View" tab if you right-click and edit the table? Are the defaults working when you insert a row and do not specify a value for those columns? I tested this with PCC v12.01.022 on a Windows machine talking to a PSQL 12.01.022 Windows engine, and the column defaults are included as expected...