cFolder = Addbs(oApp.cDocsLoc) + "INVESTIGATIONS\" + ; AddBS(Alltrim(Str(Year(.oCaseRecord.Opendate)))) + ; AddBs(.cAcronym) + AddBs(.oCaseRecord.Case_ID) cFolder = Alltrim(Upper(cFolder)) Select ; wf.foldername, ; wf.category ; From webdocfolders wf ; Where Alltrim(Upper(casetype)) == "INVESTIGATION" ; Into Cursor curFolders Select curFolders Go Top Scan cNewFolder = cFolder + ; Upper(AddBs(Alltrim(curFolders.foldername))) + ; Upper(AddBs(Alltrim(curFolders.category))) cNewFolder = Alltrim(Upper(cNewFolder)) MkDir (cNewFolder) EndScanThis works, except that every other folder is lower case. What I end up with is a folder structure similar to this:
client communications - confidential CLIENT PROVIDED DOCUMENTS email REPORTS miscellaneous SCANS discovery material CIVIL INVESTIGATION criminal investigations FINANCIAL _ CREDIT other work product - confidential DATABASE PRODUCTS internal email INTERVIEWSThe top level folder is always lower case, but inside that folder, the rest alternate from upper to lower case. Wassup with this?