[RBASE-L] - Re: SELECT against ODBC - Razzak's Reply

[William Mason]

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.