Retrieving object pointers [Never Mind]

[chuck hinkle]

> on 11/5/03 2:17 PM, chuck hinkle at chuckbo at hinkles.us wrote:
>
> Hi Chuck,
>
>> Here's something that seems odd. I've got my three tables, Employees,
>> Departments, and DeptEmp, with pointers between them. I know that
>> they're
>> going in correctly, because I can go to the browser window and see the
>> associated records.
>>
>> But when I do select * from Employees, Departments, DeptEmp" my cursor
>> is
>> nil.
>
> 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 window functionality now that I think my
database interfaces are working.



>
>> I still have to run tests to see if the order I list the tables in
>> matters or if I can get it to work if I explicitly link the pointers in
>> the
>> Where clause. And I'll go through the Tutorial and Reference again and
>> look
>> for some other tests to see where I've gone amiss. But if you see
>> anything
>> obvious that I'm forgetting, I'd appreciate the suggestion. You all have
>> gotten me very far along so far.
>
> If you use ObjectPtrs then you can skip them in the WHERE clause.
>
> I recommend as first step play with 2 tables.
>
> --
> 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
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>




Chuck Hinkle [INTJ]

"Perception is usually more persuasive than reality"