>USE main1 >gcDelimName = ALIAS( ) + '.xls' >gcPath = [\\Jtchp58544\new smd\Training\Quality Test 01\] >gcDelimName = gcPath + ALIAS() + [.XLS] >COPY fields num,Msisdn,date,flag TO (gcDelimName) XL5 >SET DEFAULT TO [\\Jtchp58544\new smd\Quality Test 01\] >brow >>I ask abot this errors
>COPY fields num,Msisdn,date,flag TO TO (gcDelimFile) xl5 &&&Variable "gcDelimFile" is not found >COPY fields num,Msisdn,date,flag TO ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])&&&Invalid path or file name >COPY fields num,Msisdn,date,flag TO (gcDelimName) xl5 &&&OLE error code 0x800300fc:unknown com status code >>not this ..
>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] && wrong >SET DEFAULT TO [\\Jtchp58544\new smd\Quality Test 01\] && correct >SET DEFAULT TO "\\Jtchp58544\new smd\Quality Test 01\" && this is also >>
>>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])>>You were told yesterday that you shall use ONE, not two delimiters!
>>gcDelimName = [\\Jtchp58544\new smd\Training\Quality Test 01\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])>>The same error is repeated many times in your code, here's another one
>>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] && wrong >>SET DEFAULT TO [\\Jtchp58544\new smd\Quality Test 01\] && correct >>SET DEFAULT TO "\\Jtchp58544\new smd\Quality Test 01\" && this is also correct>>
>>>USE main1&& form d:\llocp >>>gcDelimName = ALIAS( ) + '.xls' >>>**gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')&&if active this line return to same dir d:\llocp >>>gcPath = [\\Jtchp58544\new smd\Training\Quality Test 01\] >>>gcDelimName = gcPath + ALIAS() + [.XLS] >>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5 >>>SET DEFAULT TO (gcPath) >>>brow >>>>>>
>>>SET DEFAULT TO d:\llocp >>>USE main1 >>>gcDelimName = ALIAS() + [.XLS] >>>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS]) >>>COPY fields num,Msisdn,date,flag TO TO (gcDelimFile) xl5 &&&Variable "gcDelimFile" is not found >>>COPY fields num,Msisdn,date,flag TO ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])&&&Invalid path or file name >>>COPY fields num,Msisdn,date,flag TO (gcDelimName) xl5 &&&OLE error code 0x800300fc:unknown com status code >>>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] >>>brow >>>SET DEFAULT TO d:\llocp >>>>>>thanks
>>>>>USE main1 >>>>>gcDelimName = ALIAS() + [.XLS] >>>>>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS]) >>>>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5 >>>>>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] >>>>>brow >>>>> >>>>>>>>>