No they don't, Fred. Adir() and file() are finding the file to be renamed.
Sent from my T-Mobile 4G LTE Device -------- Original message -------- From: Fred Taylor <[email protected]> Date:08/18/2015 16:52 (GMT-07:00) To: [email protected] Subject: Re: Problem with COPY and RENAME Do your variables lcimage or doc_url have spaces? Try: RENAME (lcimportpath + LOWER(lcimage)) TO (lcexportpath + UPPER(ALLTRIM(doc_url))) Fred On Tue, Aug 18, 2015 at 3:51 PM, Jeff Johnson <[email protected]> wrote: > RENAME '"' + lcimportpath + LOWER(lcimage) + '"' TO '"' + > lcexportpath + UPPER(ALLTRIM(doc_url)) + '"' > does not work still. > > > > On 8/18/2015 3:39 PM, Fernando D. Bozzo wrote: > >> Hi Jeff: >> >> For testing, do the same on the DOS Window, to see if it is working, then >> try this way >> >> RENAME ( '"' + (lcexportpath) + lcimage + '"' ) TO ( '"' + (lcexportpath) >> + >> UPPER(ALLTRIM(doc_url)) + '"' ) >> >> Note: The quotes are double between single >> >> Regards.- >> >> >> 2015-08-18 22:12 GMT+02:00 Jeff Johnson <[email protected]>: >> >> lcimage = TRANSFORM(caf_image) + '.' + ALLTRIM(caf_ext) >>> lcexportpath = >>> 'D:\users\public\applications\ft_cafe\documents\export\' >>> WAIT WINDOW (lcexportpath) + lcimage + '/' + (lcexportpath) + >>> UPPER(doc_url) >>> IF FILE((lcexportpath) + lcimage) >>> COPY FILE (lcexportpath) + lcimage TO (lcexportpath) + >>> UPPER(ALLTRIM(doc_url)) >>> >>> OR: >>> >>> RENAME (lcexportpath) + lcimage TO (lcexportpath) + >>> UPPER(ALLTRIM(doc_url)) >>> ELSE >>> MESSAGEBOX((lcexportpath) + lcimage + ' file not found.') >>> ENDIF >>> >>> >>> Either way it says "file not found" and the file is found because it >>> fails >>> on the COPY and the RENAME. >>> >>> What am I missing? >>> >>> -- >>> Jeff >>> >>> Jeff Johnson >>> [email protected] >>> (623) 582-0323 >>> >>> Please reply to [email protected]! >>> >>> www.san-dc.com >>> www.cremationtracker.com >>> www.agentrelationshipmanager.com >>> >>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksqEH231GsbYPypvE8-h=Qyf4Zdk7wrur+Z=dj0_6u4...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/CAJCBksqEH231GsbYPypvE8-h=Qyf4Zdk7wrur+Z=dj0_6u4...@mail.gmail.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
