|
Duh... Thanks Rob. I had it right on my CLRPFM but completely goofed on the OVRDBF... Time to go home.. >-----Original Message----- >From: midrange-l-bounces@xxxxxxxxxxxx >[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx >Sent: Tuesday, October 04, 2005 5:16 PM >To: Midrange Systems Technical Discussion >Subject: Re: OVRDBF and SQL > > > WKCmd = 'OVRDBF File(MKPHSW) ToFile(P#File)'; >Should be > WKCmd = 'OVRDBF File(MKPHSW) ToFile('+ > %trim(P#File) + ')'; > >An alternative is to use dynamic sql instead of static sql. > >Rob Berendt >-- >Group Dekko Services, LLC >Dept 01.073 >PO Box 2000 >Dock 108 >6928N 400E >Kendallville, IN 46755 >http://www.dekko.com >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.