Retrieving object pointers [Never Mind]

[Ruslan Zasukhin]

on 11/5/03 4:43 PM, chuck hinkle at chuckbo at hinkles.us wrote:

>> In viSQL also?
> 
> I had forgotten about viSQL. I was running tests and looking at the
> results with MSGBOX commands in RB.
> I started retyping and moving portions of the command around, and I
> stopped getting having the NIL problem, but I was still retrieving 0
> records. I would do a retrieval on a single table, and everything came
> back. I would do a retrieval on just two tables, and I'd get 0 records. I
> tried leaving out the Where clause completely, and I still got 0 records.
> But as soon as I explicitly added to the where clause the pointer = recid,
> then my retrievals were working. So maybe I'm don't have the pointer
> defined correctly (though it looks okay in the Valentina application in
> both the definition and browser windows).
> 
> Anyway, I'm moving on with some

May be you have set up 2 or more pointer between the same 2 tables?

Then you MUST specify link in the WHERE because otherwise Valentina catch
ambigiouty

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------