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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.