Search

You searched for the word(s): Invalid Row-count
Page 1 of 2 (20 items) 1 2 Next >
  • Re: Invalid row-count in subquery Error

    How many records does the query below return: SELECT BKIC_PROD_DESC FROM DBACOPY.BKICMSTR WHERE BKIC_PROD_CODE = SKU How about: SELECT BKICMSTR.BKIC_PROD_DESC        FROM DBACOPY.BKICMSTR        WHERE BKICMSTR.BKIC_PROD_CODE = INV_LASTUSED.SKU   Each query should return only ...
    Posted to General (Forum) by Mirtheil on 05-13-2011
  • Re: "Invalid row-count in subquery."

    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"?
    Posted to General (Forum) by Linda84 on 05-12-2010
  • "Invalid row-count in subquery."

    Hi, 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 = ...
    Posted to General (Forum) by morten03@marbase.com on 07-29-2003
  • Invalid row-count in subquery Error

    What  I am doing wrong here? UPDATE INV_LASTUSED SET SKU_NAME = (SELECT BKIC_PROD_DESC FROM DBACOPY.BKICMSTR WHERE BKIC_PROD_CODE = SKU) UPDATE INV_LASTUSED SET INV_LASTUSED.SKU_NAME =     ( SELECT BKICMSTR.BKIC_PROD_DESC        FROM DBACOPY.BKICMSTR        ...
    Posted to General (Forum) by Cholotron on 05-13-2011
  • Re: Invalid row-count in sub query

    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.
    Posted to Pervasive PSQL Summit v10 (Forum) by Jay.Clark on 11-02-2009
  • Re: Invalid row-count in subquery Error

     Hi 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    
    Posted to General (Forum) by Cholotron on 05-13-2011
  • Invalid row-count in sub query

    Hi, 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,   (select count(*)      from "HistoryLines" hl2      ...
    Posted to Pervasive PSQL Summit v10 (Forum) by stephanlotter on 10-31-2009
  • Re: "Invalid row-count in subquery."

    Morten, 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. Thanks, Jerry
    Posted to General (Forum) by jxiao on 08-13-2003
  • Re: "Invalid row-count in subquery."

    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)    
    Posted to General (Forum) by Manah on 05-11-2010
  • Update subquery

    When i use this query it have error update master 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~
    Posted to General Discussion (Forum) by hokwai57@hotmail.com on 05-18-2003
Page 1 of 2 (20 items) 1 2 Next >