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 Mike Lewis 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. OrcusDanny

    SQL Question

    My apologies, I didn't see that forum in the listings. However, I did manage to find a solution: Query 1 - Returns all rows that have the error I am looking for: SELECT costcentre, productcode, freestock FROM product WHERE CAST(freestock * 1000 AS INTEGER) <> freestock * 1000 AND...
  2. OrcusDanny

    SQL Question

    Yes I am writing the query as SELECT [columnnames] from [tablename] Where ([column]*10^5)<>INT([column]*10^5) And I get the error message 'Invalid use of keyword' Please note that the system is based on Borland Database Engine and paradox SQL so it doesn't support a chunk of the stuff you...
  3. OrcusDanny

    SQL Question

    It gives me error 'Invalid use of keyword'
  4. OrcusDanny

    SQL Question

    Ones that SHOULD be selected include numbers like -1.234567790909E-45 and 4.00267821245E-52 and 0.0200000009 Numbers that should NOT be selected are ALL numbers that have LESS than 5 decimal places. The issue is mainly the fact that some of the values I want to select are NEGATIVE values and...
  5. OrcusDanny

    SQL Question

    Hi, I am working for a bespoke application provider and am stuck with an SQL query I am trying to write. I only have basic to intermediate level SQL knowledge and the main issue I have is that the application is BDE/Paradox SQL based so some of the standard SQL queries that would work in MSSQL...

Part and Inventory Search

Back
Top