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. ERKcool

    Change Custom SQL Query with multiple data sources

    The SQL Pulls the Products (Code, Description, Sale Price, Department, Etc..) from the ACCOUNTING database. I don’t have the permissions to edit this database. Add tables, drop them etc. The second database LMMISC is one I created with one table in it CustomeProductFields. I want to link the...
  2. ERKcool

    Change Custom SQL Query with multiple data sources

    I couldn’t get CR8 to create the query using the Select Expert so I used the Pervasive Control Center to run “hand typed” SQL Query’s on the data tell I got something that worked at a speed I could live with. (If I did a join or union the system took way to long to complete the query. Don’t know...
  3. ERKcool

    What products are customers not buying?

    The query that finaly worked is SELECT Products."Code", Products."Desc", Products."SalePrice" FROM "DEBC Lead Masters"."Products" Products WHERE "Products".Code not in (select distinct("BillingDetail".DetailNo) from "DEBC"."BillingDetail"BillingDetail where...
  4. ERKcool

    Change Custom SQL Query with multiple data sources

    CR8 & Pervasive.SQL 2000i The query SELECT Products."Code", Products."Desc", Products."SalePrice" FROM "DEBC"."Products" Products WHERE "Products".Code not in (select distinct("BillingDetail".DetailNo) from "DEBC"."BillingDetail"BillingDetail where "BillingDetail".CVNo='619383')...
  5. ERKcool

    What products are customers not buying?

    Thank You, Thank You, Thank You Very good guess. That was just what the problem was. The customer number is text stored as text in a text field. Now all I have to do is wait for the system to run the join on 400,000 records. Thank You for you help I truly do appreciate it. Erik
  6. ERKcool

    What products are customers not buying?

    CR gives me the error "ODBC error: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Incompatible type in predicate
  7. ERKcool

    What products are customers not buying?

    First you would create a report that used one field of the same datatype as the product code field." The field is the same data type but the size is different. CR gives me the error "ODBC error: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Incompatible type in...
  8. ERKcool

    What products are customers not buying?

    I thank all for the help provided. If I find a solution I’ll post it.
  9. ERKcool

    What products are customers not buying?

    Yes, their is a customer table with a customer number.
  10. ERKcool

    What products are customers not buying?

    Any idea of how I could get the data I seek?
  11. ERKcool

    What products are customers not buying?

    Ok there is some miscommunication. - The old report is one that looks at the customers billing detail, finds all products that they have ordered and prints that product with a blank spaces to write in so customers can use them as reorder sheets. What I am after is the inverse of that. What...
  12. ERKcool

    What products are customers not buying?

    Products that don’t match products pulled by the last report?" (The one that told me the products they do order) Tell me the products that a specific customer doesn’t order? -Erik
  13. ERKcool

    What products are customers not buying?

    CR v8 I have 2 tables Billing.Detail (invoice #, customer number, product code, description, order quantity, sale price, etc…) Products (products code, description, text2, amount1, amount2, etc…) Tables are linked by product code. I can get it to tell my what products a given customer...

Part and Inventory Search

Back
Top