Director-SQL:Select all fields from linked record?
Michael Bedar
mike at bedar.net
Thu Jun 8 21:48:14 CDT 2006
I have a select statement like
"SELECT AB_LINK->AField1 FROM TableB"
where TableA and TableB are linked with AB_LINK, and AField1 is of
course a field in TableA
This works, but I need to get 2 fields, so I tried
"SELECT AB_LINK->AField1,AB_LINK->AField2 FROM TableB"
Which seems to work, BUT then later when I use getRecordsAsPropList()
on the cursor that the above select statement returns, the field
names are not coming through.. i get "#No_name1:" and so on..
So I was trying to figure out how to get all the fields.. I didn't
think ** would work after the -> (and I was right) but is there
another way to do this?
And does anyone know why my field names where not coming through in
the prop list?
Thanks
Mike
More information about the Valentina
mailing list