I've been struggling with this syntax for a while now. I must be doing something really wrong.
I have 2 tables
tactualdata & tparams.
tactualdata.fkey is a compound '.' delimited data field
why they did it this way, I dont know?
where tactualdata.fkey corresponds to tparams.ffeature+'.'+tparams.ftoolset+'.'+tparams.fisnum
I want to build a cursor that contains all the tactuadata records and (the tparams records that match on ffeature and on ftoolset.
I am trying
Select *;
from dbtwiz!tactualdata ;
left Join dbtwiz!tparams;
ON(Thisform.zgetfeature(tactualdata.fkey) = Alltrim(tparams.ffeature) And ;
thisform.zgettoolset(tactualdata.fkey) = Alltrim(tparams.ftoolset)) ;
into Cursor cExport Readwrite
this matches up the ffeature field correctly but it does not match up the ftoolset correctly.