You searched for the word(s): Invalid Row-count
How many records does the query below return:
FROM DBACOPY.BKICMSTR WHERE BKIC_PROD_CODE = SKU
WHERE BKICMSTR.BKIC_PROD_CODE = INV_LASTUSED.SKU
Each query should return only ...
I tried this against Demodata in v10.31, and it worked:
select * from "Class" where Max_Size = (select max(Max_Size) from Class)
We are not doing fixes on PSQL 9 anymore, so you can try the IN workaround - does that get you the correct result?
Are you getting the error "Invalid row-count in subquery"?
I know this SQL doesn't make any sense, but I need to execute a similar one with the data we have. The one below works fine in MS SQL Server, but Pervasive returns:
''Invalid row-count in subquery.''
P.SQL should be smart enough to check for top 1. Is there a workaround to force this SQL to execute?
SELECT * FROM ''Student'' where ID =
What I am doing wrong here?
SET SKU_NAME = (SELECT BKIC_PROD_DESC
FROM DBACOPY.BKICMSTR WHERE BKIC_PROD_CODE = SKU)
SET INV_LASTUSED.SKU_NAME =
( SELECT BKICMSTR.BKIC_PROD_DESC
Can you provide the exact version of PSQL? The best way is to look in \Program Files\Pervasive Software\PSQL\Bin. Find w3odbcei.dll, right-click and select properties. Click on the version tab.
That was the problem. one of my tables had duplicate records. My update query if working fine now.
select distinct BKIC_PROD_CODE from BKICMSTR
group by BKIC_PROD_CODE
having count(BKIC_PROD_CODE ) > 1
order by BKIC_PROD_CODE
Thank you very much
What am I missing? I get 'Invalid row-count in sub query' when I run the following SQL statement:
select Month(hl1.DDate) MonthOfInvoice, Year(hl1.DDate) YearOfInvoice,
hl1.ItemCode, Sum(hl1.Qty) Quantity,
from "HistoryLines" hl2
This defect (46150) has been fixed. The SP1 FTF build will be ready in the next couple of weeks. Please check with our support staff until then. If you need a developer's build just let me know.
It was a similar query, but instead of using top 1, I was using a field in the subquery ie
Select field1, field2, field3, from table1 where field3 = (select max(field3) from table1)
When i use this query it have error
set qtysold = (select sum(qtysold) from oeshdt where trantype='1' group by item)
where itemno in
(select item from oeshdt where trantype='1' group by item)
ODBC Error: SQLSTATE = S1000, Native error code = 0
'Invalid row-count in subquery.
How can i solve it? thanks a lot~