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.
I rewrote the query to use a temporary table within a stored procedure. However pervasive can't recognize the Insert Query. When I break it up it works. CREATE PROCEDURE UPDATERATING(); Begin if (exists(select "Xf$Name" from "TEMPDB"."X$File" where "Xf$Name" = '##RCPTDIST'))then Drop Table "TEMPDB"...
The following query is only supposed to update 900 records but it updates 4,000 and runs very slow. The sub-query runs 900 records. How should this be written? Update TESTCAN.ITEM Set ITEM.Rating = ToTag.Rating From ( Select CanItem.VendorsItemNum, CanItem.VendorNum, Case Right(RTrim(CanItem.VendorsItemNum),(Length(CanItem.VendorsItemNum)-Locate('...
Thank you for the help. I was hoping that it would be possible with 64-bit MS Office. the local distributors in South Africa say that they don't support or provide v11. They also don't provide assistance/support with MS Office with Access or Excel. Really a disappointment...
Hi, Can anyone elaborate on what the following status is, which a customer of mine is getting from License Administrator: 7365: Record changes were blocked due to multi-user access Changes to the target record were not committed because of multi-user access. Refresh, verify the record, then resubmit your changes. Thanks, Jon
PSQL v10 doesn't have a 64 bit ODBC driver. To use a 64 bit application, you need a 64 bit ODBC driver. PSQL v11 offers a 64 bit ODBC driver. You would either need to upgrade to PSQL v11 or use the 32 bit version of Office.