Search results for query: *

OK, I've downloaded 2011 30-day trial and re-created my report. Chose New, Standard Report, Tables: SA_REPPRINT (5 test invoice numbers), SA_HDR (header info, 181K rows), SA_LIN_ITEM (line info, 524K rows) (named the column in my 'reprint' table the same as the indexed column of my invoice...

I have written a Crystal 10 report that duplicates the customer invoice feature in our accounting software. Our existing software allows reprinting invoices, but only one at a time. Now, I am at the same wall with Crystal. I have successfully joined two tables, one containing the invoice header...

Looks like I have v8.6. I don't know if an upgrade will be feasable in our future or not because of the software that is using Pervasive, I will have to look into it. This table is in a seperate database that I setup just for our web-apps that we use to 'gather more info', so I'm not worried...

CREATE TABLE TrackingNumbers (OrderNumber CHAR(10) NOT NULL, PONumber CHAR(25), TrackingNumber CHAR(25), CustomerName CHAR(25), Weight DOUBLE, NumberPkgs INTEGER, ServiceType CHAR(10), DateShipped TIMESTAMP DEFAULT now()) ODBC Error: SQLSTATE = 23000, Native error code = 0 No default value...

Thanks for getting me going, but I can't make it work. Using Pervasive Control Center and Data Manager, I tried creating the table with no luck, syntax error. Putting 'CURRENT_TIMESTAMP' in single quotes, got me a little further, invalid timestamp. So I see where sending it a default timestamp...

I am using UPS WorldShip to write to a Pervasive V8 table. After each shipment, the software sucessfully writes the fields that I specified to correct columns in the table. The WorldShip software, however, does not have a time or date field anywhere that I can find that I can use to timestamp...

Thank you both so much for your help. I read most of the evening on ADO filters. Here is what I am using now. It has cut the display time of the page from 1 minute 5 seconds to just 1-2 seconds. And since this table should never have more than 2500 records, I'm happy with the performance. If you...

I have a asp page that queries a local psql database and a remotely stored mysql database. They both have a 'Customer' table with a 'CustomerNumber' column. I am currently comparing each customer in the local table with the customers in the remote table, and if the remote customer is missing, I...

Thank you! I will.

No, the question isn't whether it's possible. But neither did I want help optimizing my already inefficient code. So let me rephrase. Will someone please be gracious enough to provide me with some example code snippets that I can insert into my existing asp page with English layman explanations...

I have a local psql database and a remotely stored mysql database. They both have a 'Customer' table with a 'CustomerNumber' column. I am currently comparing each customer in the local table with the customers in the remote table, and if the remote customer is missing, I list that customer from...

I apologize in advance, there's at least 3 forums this could fall into :) My company has a psql based program that stores 'customers' in a local database. Our offsite website has a MySQL database that stores SOME of those customers as 'dealers'. There is a flag in the local table that specifies...

The final result of the completed report should sum all PO's for all item numbers in a given range, but only 90 days out (I will tackle that later). The item qty's are kept in one table (purchline), referenced to another table by po number (purchorder), that table holds the dates. And yes, each...

I have a local server that contains our inventory that changes constantly. Our online store is hosted elsewhere and uses a mysql database for storing the inventory. I would like to update the online database every hour. I have a local SQL script that pulls the local updated inventory data (2100...

OK, I got the inner/outer join thing, (now) I guess that I didn't analyze the question because I was getting the right answer... As for the A and B, I will continue to have to use the "." notation since this is pulling from Pervasive SQL and it craps out with that syntax. Now, as for the...

OK, I have a pretty extensive report pulling data from 3 different tables, and working perfectly. Now, of course, anytime management sees something good, they want to break it. The only solution that I can see would maybe be a Expression Field, but it's not recognizing any of my syntax. Here's...

Great! Under Fields, Formula Fields, I created an Item Group with: Left ({Items.ItemNumber},InStr ({Items.ItemNumber},"-")+2 ) This gave me the name formatting that I needed. Then a Color Group with: mid({Items.ItemNumber},InStr({Items.ItemNumber},"-")+1,2) This separated out my colors Now I...

I have been tasked with producing a report that groups data by the first part of the item number. 90% of the item numbers contain a hyphen but hardly any are the same number of characters. An example of the data pulled would be: Item Number Qty Cost Ordered AB1234-01SM 10...

The command worked and the indexes were added, however, performance was unchanged. I re-ran the Query Plan and attached it with a screenshot of my indexes. To me, the indexes look duplicated and that maybe I should change the existing ones??? http://www.froggtoggs.com/temp/Items1.zip

I read your link and the additional info from here: http://cs.pervasive.com/forums/p/4332/4332.aspx The file is attached, and thanks again for addressing this.http://www.froggtoggs.com/temp/Items.zip