William, Thanks for posting all details.
While we investigate further, I STRONGLY suggest that you use the latest and greatest version and build:1.864xRT03. http://www.rbase.com/65ppupdates There has been MAJOR fixes since the release of 1.850xRT03. I can recall a few FIXES in relation to SATTACHed tables and supported commands in EPPs. RBW65PP1.TXT RBW65PP2.TXT RBW65PP3.TXT RBW65PP4.TXT Good Luck! Very Best Regards, Razzak. At 11:28 AM 2/7/2003 -0800, William Mason wrote:
Oops - sorry for the lack of details: 1> SELECT is against SQL Server using SQL Server DSN 2> Here is the statement INSERT INTO tmpHammer + (HammerID , + StockID , + AuctionDateID , + LotNo , + AuctInvCloseCode , + RecordEntryTS , + RecordEntryUserID, + RecordEditTS , + RecordEditUserID , + ConsignorAcctID, + AccountRepCode, + GuaranteedSaleInd) + SELECT T2.HammerID, T2.StockID, T2.AuctionDateID, T2.LotNo, + T2.AuctInvCloseCode, T2.RecordEntryTS, T2.RecordEntryUserID, + T2.RecordEditTS, T2.RecordEditUserID, T1.ConsignorAcctID, + T1.AccountRepCode, T1.GuaranteedSaleInd + FROM Inventory T1, Hammer T2 + WHERE T1.StockID = T2.StockID + AND T2.AuctionDateID = .vftAuctionDateID + &vctLotNoClause + &vctCloseClause + &vctAcctExecClause + &vctConsignorClause 3> Build is 1.850 RT03 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of A. Razzak Memon Sent: Friday, February 07, 2003 11:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SELECT against ODBC - Razzak's Reply At 11:00 AM 2/7/2003 -0800, William Mason wrote: >Would anyone have an inkling as to why a SELECT statement works fine from >the R> but returns a "No rows found" when run from an EEP from a form's >pushbutton? The SELECT is being issued against a foreign database. William, 01. Are you using a SELECT statement against R:BASE/Oterro SATTACHed DSN or "OTHER" DSNs in EEP? 02. Can you post the exact SELECT statement being used in EEP? 03. And finally, what version and build of R:BASE for Windows? Very Best Regards, Razzak.
