Paging in Pervasive SQL
How to do paging in Pervasive SQL (version 9.1)? I need to do something similar like: //MySQL SELECT foo FROM table LIMIT 10, 10 But I can't find a way to define offset. ...
pervasive
What's a 'pervasive database'?
I'm sorry, but this keyword doesn't mean anything to me... Can someone give me a definition? Thanks in advance... ...
Methods for interacting with a Pervasive SQL database
I'm in the process of developing a web interface to a service business management application that uses a Pervasive SQL database to store information (not my choice, by the way). At the moment, I'm using the official Pervasive SqlClient implementation with a custom set of query generation classes so I can write code like: new SelectQuer...
How do I move a Pervasive PSLQ database between servers
What is the easiest way to move a Pervasive PSQL database between two servers. I can stop the database engines if necessary. ...
Determining the start and end range of bytes changed in a file
I'm working on a little experimental utility to use within our company that indexes notes stored in our custom CRM software for full-text searching. These notes are stored in a Btrieve database (a file called NOTES.DAT). It's possible to connect to the database and retrieve the notes for indexing by using Pervasive's ADO.NET provider. Ho...
Using parameterized SQL with LIKE in WHERE clause (Pervasive SQL)
Hi all, I have a Pervasive database that I connect to using C++. All my queries so far is parameterized, i.e "SELECT USER.NAME FROM USER WHERE USER.ID = ?", and that works fine. But in a search query I use LIKE in the WHERE clause, and then it seems I can't use parameters and wild chars (%). My query looks something like this "SELECT ...
SQL statement with LIKE
Hello I would like to select all records that have an underscore character in their 11th character, so i try this: SELECT * FROM "BOM_SUB_LEVEL" where TOP_CODE like '%%%%%%%%%%_%%%' but this doesnt work as expected, can someone help? thanks ...
Pervasive 8 and Python
Is it possible to access a Pervasive 8 (not Pervasive SQL) database from python? ...
Btrieve/Pervasive db and Ruby
Is there any solution to work with Btrieve/Pervasive db from Ruby level? Any gem? Maybe somebody have some experience with such a thing? Or maybe use some Java libs through Jruby? I've never used Jruby ...
Connect a Pervasive DB using OLE DB
We have a existing closed source third party application using a Pervasive PSQL database. For Example the PSQL are located in the directory c:\test and have names like holiday.dat, offers.dat and so on. I want to read and if possible write to these files without having installed the Pervasive Workstation Engine. With the Workstation Engi...
Pervasive and Tango?
We are currnetly looking at redeveloping an Interanet application that was created it would appear with Pervasive SQL and Tango (it usues TAF fiels so this is out assumption). Looking at the Pervasive website I cannot even find any references for Tango now. Is this product no longer being sold or used? Are there any resources availabl...
Most efficient way to select records in one database based on result set from totally different database
I have 2 totally separate databases - one MSSQL and one Pervasive. Due to the way our product data is stored in the Pervasive database, you cannot easily run a query to get a products's information and features to display on our website. So, using a DTS package I take the product data from Pervasive and process it so it is one MSSQL t...
Create local Linked Server using Server Name or IP Address?
Based on the answer I received on this question (http://stackoverflow.com/questions/1911969/...) I have set up a Linked Server on SQL Server 2008 to a Pervasive database. Since both databases are on the same physical server, what would be the recommended method to create the linked server, using the IP Address of the server or the Serve...
Pervasive ODBC access from PHP on Linux?
Can anyone give me an example of querying a Pervasive PSQL database from PHP on a remote Linux machine? Pervasive claims PHP can access it, but their examples use Windows COM objects, which isn't available on Linux, and the first "PHP DTO Extensions 1" link they have for download actually links to a bunch of ASP .NET scripts, and isn't...
Connecting SharePoint 2010 with a Pervasive 10.12 database
we recently installed SharePoint 2010. I am trying to connect our SharePoint server with another server that hosts our Pervasive database. I can do the connection between these 2 servers in Access, but I am having problems connecting SharePoint to Pervasive. In SharePoint Designer, I tried to create a database connection>OLEDB>connectio...
Pervasive & Linux
I'm interested in quering a Pervasive DB server running on a Windows platform from Linux. Would anyone happen to know if this is possible, what's required and what resources there are for me to read up on it? Thanks! ...
Improving SQL Code
I'm using Pervasive SQL. I have the following UNION of mulitple SQL statements. Is there a way to clean this up, especially the Pay Date an the Loc No fields that are selected in each statement. Is there a way to pull this out and have only one place to need to change those two fields? ( SELECT '23400' as Gl_Number, ...
Btrieve Date Integer
Hi everyone, this is my question: I'm migrating data from a Btrieve file (.dat) through Pervasive Control Center and there is field type which is defined as integer but is a date and for example the date '31/12/2009' (seen in the legacy system) is view it as the number 733772 when I export it. The legacy system shows the date correctly...
How to connect Pervasive ODBC using PHP on Windows??
I want to Connect Pervasive ODBC using PHP on Windows. Wether we have to download Pervasive client version for same???? whats else we need to download for this??? ...
Select max date row from results
Using Pervasive SQL, I have a result set: Tp_No Name State Eff_Date Actual Billed 1006 ABC TN 2006-07-01 .1 .5 1006 ABC TN 2008-02-15 .27 .6 1006 ABC TN 2010-09-01 .37 .7 1022 Widget TN 2006-07-01 ....