In is slow.
Better to optimize the query like this:
Select o.*
>From orders o
Inner join
(
Select
p.Partid
From
Partners p
Where
p.country
Firebird has limitation on both IN clauses and parameter lists for
stored procedures.
Going down the route of trying to get around this can then cause errors
with the command text limit.
It is always best to redesign your stored procedure or query to join on
a table that has the particular par
Absolutely !
It seems that the mandatory postcode field has all kinds of non-postcode
stuff in it !
For anyone else with this issue the original error was:
Invalid length parameter -2 to SUBSTRING. Negative integers are not
allowed.
Changing the query to
SELECT DISTINCT
left(c.addr
This simple query:
SELECT left(c.addr_5, CHAR_LENGTH(c.addr_5)-3) as trimmed
FROM vecusts c
Produces this error
Pressing OK I then get correct values in the trimmed column.
Can anyone assist or tell me what I am doing wrong?
Many thanks
[Non-text p