Search results for query: *

Thanks let me look at it that way.

I will check the queries in Crystal report, but It would be nice if the query worked the same against Pervasive and Access.

I am using Pervasive 11. Since I am having problems converting with Access, the purpose is to create a new table with only part of the table. I can then use this new table, or give it to my helper to create some crystal report when I am too busy. I just do not want them to connect directly to...

Actually I do not get an error. This is what I do. Using an ODBC connection I import the required table(s) in Access. I do not see any problems in the new Access table. I take a Crystal report working against the Pervasive database, and using another DSN I change the link to the Access...

Hi, How can I select all or part of the data from a table, create a new table and insert all the selected data in it. My query would look like Select * from table but how can I create a new table and insert those data in it. Thanks for your help

I am using Pervasive and Crystal report without any problems. Pervasive 10, and Crystal 11 by the way. To do some reports I sometimes extract my data and put the tables in an MS Access Db. My crystal report is using an ODBC connection to the Pervasive, and the MS Access, so I just change link...

On my report I have a set of specific values that I sum. I would like to calculate the percentage of each value compared to the total of all values. Obviously the total value is known only when the report is done. I did this a long time ago, but just do not remember how to do this. Any Hint...

Perfect. thanks

My table is as follows Sales|VendorNb|EmployeeNb| I created a report showing sales by employee Nb if vendor Number is 11111. Now I would like to modify my report to have 2 columns: 1 Column showing sales from vendor 11111 1 Column showing sales from other vendor items. For example, Employee...

Thanks to check. I am using the Pervasive 11 and I believe thePSQL is version 11.10.042.000 as indicated in the 'About' windows.

This is the SQL statement where I am having problems UPDATE TABLE1 INNER JOIN TABLE2 ON TABLE1.VendorNum = TABLE2.VendorNum SET TABLE2.ShortName = LEFT(TABLE1.Name,5) WHERE TABLE2.ShortName=''; I get the following error message: <<<<<<<<<<<<<<<<<<<<<<<< [LNA][Pervasive][ODBC Engine Interface]A...

Thanks, i see. Actually I have 2 tables and I need to get some values from one table and populate a smaler field in the other table. This is the update portion where I have a problem. I will try the UPDATE portion . Thanks.

I would like to create a sql statement to update one field with the first 5 digits from another field. for examople; Column1: 'This is a test' Column2 would be 'This ' If I was able to do this in Access, I have problem to do this directly from the Pervasive SQL prompt. Any help or suggestion...