Virtual vield code (lookup)

[MdVries]

I have two tables Dossier and Rolhand

I'am trying to get the newest date from table rolhand into dossier. <-- Text in Red
I'am using virutal field, but i can't get it to work.

Table: Dossier

*DOS_ID Rol_id Rol_date
------ -+--------------+------------
1 05dak-91 21-01-05 <-- this is not working, YET Big Smile
2 02man-11 01-08-05




Table: Rolhand

tab2_id *DOS_ID Rol_date Name
-------+----------+------------+----------
1 1 21-01-05 Marc
2 1 20-01-05 Chris
3 2 25-07-05 Denis
4 2 01-08-05 Walker

I am using Microsoft Visual FoxPro 8.0, i don't know if i can use SQL/Fox pro code.

I use another virtual vield and this one is working!!
look_mgr.get_value(dossier.cost_code,'cost.cost_desc')

dossier.cost_code i use to get the vield cost_desc in table cost.

Now i want to use dossier.dos_id to get Rol_date in table rolhand

I tried to use this code
look_mgr.get_value(dossier.dos_id,'rolhand.rol_date') but i get empty result.

The reason of the is there are more then one vield in the result, that's my guess.

When i put this in a query:

SELECT MAX(Rolhand.rol_datum) AS datum FROM trv_bv!rolhand WHERE Rolhand.dos_id = ( "0000000040" )"

I get one result "04-04-2004" it works!!!! wow!



But when i put the code in an virtual vield in Microsoft Visual FoxPro 8.0 i don't get any result.

My question for now is: can i use sql/foxpro code in an virtual vield??

Later i tryed this one:

SELECT MAX(Rolhand.rol_datum) AS datum FROM trv_bv!dossier INNER JOIN trv_bv!rolhand ON Dossier.rec_id = Rolhand.dos_id WHERE Rolhand.dos_id = ( "0000000040" ) ORDER BY Dossier.dos_id, Rolhand.rol_datum

No results. But when i type this direct in one query it works fine.

 

[Mike Gagnon]

Can you explain what virtual vield means? The term is unfamilliar.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)