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 derfloh 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?

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. SuperComputing

    Derived table syntax question

    I am attempting to join 2 tables, but for optimization purposes, I want to "filter" one of the tables down. I posted this originally in the standard SQL forum, you can read about it here: http://www.tek-tips.com/viewthread.cfm?qid=1521676&page=1 What I am trying is this: SELECT...
  10. SuperComputing

    Join Optimization - Set Conditons before Join

    I'm wondering if I can "filter" out what I need from a table before I join it to another table. Table "Items" has 2,795 rows Table "ItemsMonthly" has 39,352 rows I need all rows returned from table ITEMS with the corresponding data from ITEMSMONTHLY that meet the following conditions: TYPE =...
  11. SuperComputing

    Update mdb from SQL select

    I need to pull several columns from a table on a SQL server and then populate a Access mdb with the data. I have searched for software, but can only find apps that convert mdb to sql, the opposite of what I need. I've tried an asp page and can sucessfully pull the data that I need. I can even...
  12. SuperComputing

    Update a table with data from another table

    Forgive me if I've posted this in the wrong forum... We have a Database 'CP' with several tables, one of which is 'Customers'. We went into the 'Customers' table and made changes to both the 'SalesRep' column and the 'Category' column. Now, 45 days later, they want the changes made to the...
  13. SuperComputing

    Update Table from Second Table

    Forgive me if I've posted this in the wrong forum... We have a Database 'CP' with several tables, one of which is 'Customers'. We went into the 'Customers' table and made changes to both the 'SalesRep' column and the 'Category' column. Now, 45 days later, they want the changes made to the...
  14. SuperComputing

    Update table with another table

    OK, We have a Database 'CP' with several tables, one of which is 'Customers'. We went into the 'Customers' table and made changes to both the 'SalesRep' column and the 'Category' column. Now, 45 days later, they want the changes made to the 'SalesRep' column to be undone. I have a backup of...
  15. SuperComputing

    Call an image and map

    OK, Lets say that I have an online catalog with 20+ pages. I am putting a 'table of contents' at the top of the page. It is an image that looks like several buttons and a map that will take you to "page04.htm" when you click on "widgets", etc... If in the future the catalog changes and now when...
  16. SuperComputing

    Import csv file into existing table

    OK I have a table with data like so: COL1 |COL2|COL3| COL4 | COL5 ------------------------------------ 12340001 | 01 | 24 | XXXX | ________ 12340002 | 08 | 03 | XXXX | ________ 12340003 | 12 | 22 | XXXX | ________ And I have a csv like so: 1234001,ABCD 1234002,EFGH 1234001,IJKL I...
  17. SuperComputing

    Update table with data from a csv

    OK I have a table with data like so: COL1 |COL2|COL3| COL4 | COL5 ------------------------------------ 12340001 | 01 | 24 | XXXX | ________ 12340002 | 08 | 03 | XXXX | ________ 12340003 | 12 | 22 | XXXX | ________ And I have a csv like so: 1234001,ABCD 1234002,EFGH 1234001,IJKL I need...
  18. SuperComputing

    Read and write data with comma separated values

    Hello again guys, I am making excellent progess with my application especially with all of your help. I have a 50 char text column in a table that I am storing my data in. I can't create new columns. My page takes input from a form and writes it into the field like such: 1A01A 1A01B 1A01C...
  19. SuperComputing

    Pulling from a table twice and pulling partial data

    Hello all, thanks again for all the help so far. I have a table with 9 columns, I need to pull 4 columns and split up a 5th into peices. This is what I have so far and it is working: Set con = Server.CreateObject("ADODB.Connection") con.open "DSN=FTInventory" strQuery1 = "SELECT Barcode...
  20. SuperComputing

    Cursor placement on a form

    I have a single entry form on an .asp page that reads in a barcode number and queries a database and returns the details for that item. When the page first loads, and when it reloads after the query, I need the cursor to be automatically placed into the input for the form. Is there an easy way...

Part and Inventory Search

Back
Top