Message received. I'll go away
Hi Homer, hope you haven’t gone completely away just yet. Your question (and
problem) may be off-topic for this list, but I'll try to keep my answer more or
less on-topic.
Your SQL puzzles me, I've never before seen 'select distinct Sum(' in a
subselect, and
I wrote:
WITH MyParam(Param) as
(SELECT CAST(:MyInput AS SMALLINT) FROM RDB$DATABASE),
Tmp(PolNum, Transdate, Sum_Of_ArAmt) AS
(SELECT PolNum, Transdate, sum(ArAmt)
FROM AR
WHERE ArAmt 0
GROUP BY 1, 2)
SELECT M.CARRIERNO, M.CARRIER, M.POLNUM, M.INVOICENO, M.TRANSNO, M.TRANSDATE,
Thank you, Svein. I like the param idea. As you might be able to tell, this
piece of the project is still under development. Now is a perfect time for me
to switch to parameters.
I solved my problem late last night. It was not easy to isolate. I usually set
break-points and step through the
I thought I had it fixed by switching to a different TIBCQuery to insert a new
record. That worked fine. However, the same problem exists when I try to alter
the SQL in order to filter the result set in the grid.
The exact same error (exactly the same) happens when I close the query to
alter
Try 'Append' instead of 'Insert'
Thanks, Steve, but that was one of the first things I tried. Didn't work. I
solved the insert problem by using a different TIBCQuery component, however now
I can't close the query without producing the same error. Please see the code
in my prior post.