|
Hello Jon, Continuing on from my response in MIDRANGE-L ... I don't get errors on VR1 occurring in two structures but Values(:VENDR1.VR1) fails as you noted. I think the problem is that qualified names are allowed only on individual fields because Values( :VR1.VENDORNAME) compiles OK if I change the second VR1 (in VENDR2) to be VR2 and the VENDP file doesn't exist so the pre-compiler cannot verify the number of fields. Remember that the SQL Precompiler is not at the top of the intelligence heap ... Regards, Simon Coulter. -------------------------------------------------------------------- FlyByNight Software AS/400 Technical Specialists http://www.flybynight.com.au/ Phone: +61 3 9419 0175 Mobile: +61 0411 091 400 /"\ Fax: +61 3 9419 0175 mailto: shc@flybynight.com.au \ / X ASCII Ribbon campaign against HTML E-Mail / \ --------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
