Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SuperComputing

    Parameter or Database Connection?

    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...
  2. SuperComputing

    Parameter or Database Connection?

    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...
  3. SuperComputing

    Automatic Timestamp?

    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...
  4. SuperComputing

    Automatic Timestamp?

    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...
  5. SuperComputing

    Automatic Timestamp?

    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...
  6. SuperComputing

    Automatic 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...
  7. SuperComputing

    Compare sql queries locally, display results

    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...
  8. SuperComputing

    Compare sql queries locally, display results

    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...
  9. SuperComputing

    SQL query comparisons, Do I need an array?

    Thank you! I will.
  10. SuperComputing

    SQL query comparisons, Do I need an array?

    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...
  11. SuperComputing

    SQL query comparisons, Do I need an array?

    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...
  12. SuperComputing

    Comparing the data in 2 tables on 2 servers

    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...
  13. SuperComputing

    SQL Expression Field?

    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...
  14. SuperComputing

    Update online database

    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...
  15. SuperComputing

    SQL Expression Field?

    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...
  16. SuperComputing

    SQL Expression Field?

    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...
  17. SuperComputing

    Grouping by partial field name

    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...
  18. SuperComputing

    Grouping by partial field name

    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...
  19. SuperComputing

    Derived table syntax question

    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
  20. SuperComputing

    Derived table syntax question

    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

Part and Inventory Search

Back
Top