Search results for query: *

Ok, Thanks for your advise Regards Jeremy

Christiaan, Thank you for your quick response. I have not tried anything yet. This problem was posed to me only on Friday and I have to admit I haven't a clue as to how to start. We have a company-wide PSQL database with a table called 'staff' and the HR department want to purchase a Paradox...

Hi, I am trying through vb.net to link a table in a Paradox 7 database (via odbc) to a table in a PSQL database (also via odbc). I don't know how to set up the connections nor how to set up the SELECT statements Any advise would be welcome Regards Jeremy

Hi, I have a company-wide information system in PSQL. The HR department are thinking of purchasing an HR system with a Paradox 7 backend. I need a way of linking the 'personnel' table in the Paradox 7 database to my existing 'Staff' table in the PSQL backend using key fields. I am using...

Thank you for your assistance. I will give your suggestion a go today and see if it helps

Hi, I am having problems connecting a simple application written in VB.NET (2005) with our Pervasive.SQL V8 database. I have attempted three methods: 1. using OdbcConnection - the application works fine but remains in memory when closed. This happens only when I populate a DataSet object...

Tom, I'm probably showing my ignorance with this question!!! Is there meant to be one DDF file per table? Cheers Jeremy

Tom, In the Control Center, I right-hand click on the Table and select Properties. Regards Jeremy

Tom, No, I haven't had any success getting a resolution. Very frustrating! Regards Jeremy

The record length is: 2941 The Field adjacent to the new fields is called ParentID and is type Integer

The problem only seems to occur for varchar and longvarchar type columns. Your suggestion will probably be an adequate work-around but I am still a little worried about the root-cause of the problem. Of all the tables in the database, the Project table is by far the largest with the most...

Mirtheil, Here is the ALTER TABLE Statement: ALTER TABLE Projects ADD COLUMN ContractDURUnits varchar(10) The problem only seems to occur in the one table (Projects) Cheers Jeremy

Hi Mirtheil, Yes, it passed consistency checks after the columns were added Regards Jeremy

Mirtheil, No, I am not issuing the ALTER TABLE statement with an IN DICTIONARY clause. Let me try an lay down the exact steps I have followed to date: 1. I created the table from within the Pervasive Control centre using SQL (not the GUI) 2. I imported all of the data from an existing MS...

Tom, Thanks for your rapid response. I have never been near the DDF (as far as I know). I added the columns to the table using ALTER TABLE sql statement. I'm not sure I am able to give you a before and after scenario - other than a list of columns in the table. For what it is worth the...

When I add a new column to an existing table the new column is automatically populated with what appears to be random copies of data in other columns in the same table. It has happened twice - the first time with longvarchar type columns and the second more recent one with varchar (length 50)...