The Try-endtry block does not change how your program works, UNLESS you have some kind of error.

>main i have hidden field at excel sheet,? i see
>
>another qustion , i think i must have anew table tt at my folder when i run it via try...endtry???not found ( tt) table
>
>thanks
>
>>The line "new name with error is " tells me (and you) that you try to rename a field to a blank field name, which of course is illegal.
>>
>>>thank you,it works with try...endtry
>>>if i stop try..endtry ; i get message syntax error
>>>
>>>
>>>result via try...endtry is
>>> oldname with error is txpno
>>>new name with error is
>>>.
>>>.
>>>
>>>
>>>>You have put the try-catch block in the wrong place!
>>>>
>>>>

>>>>ALTER TABLE (TT) ADD COLUMN TXPNO C(19)
>>>>ALTER TABLE (TT) ADD COLUMN YEARe C(6)
>>>>ALTER TABLE (TT) ADD COLUMN INFTYPE C(2)
>>>>ALTER TABLE (TT) ADD COLUMN INFDATE C(12)
>>>>ALTER TABLE (TT) ADD COLUMN OFFCODE C(6)
>>>>ALTER TABLE (TT) ADD COLUMN ENTRYID C(15)
>>>>ALTER TABLE (TT) ADD COLUMN ENTDATE C(12)
>>>>ALTER TABLE (TT) ADD COLUMN CONFFLAG C(3)
>>>>ALTER TABLE (TT) ADD COLUMN CONFID C(12)
>>>>ALTER TABLE (TT) ADD COLUMN CONFDATE C(12)
>>>>replace TXPNO WITH THISFORM.TEXT1.Value
>>>>replace YEARe WITH THISFORM.TEXT2.Value
>>>>replace INFTYPE WITH THISFORM.TEXT3.Value
>>>>replace INFDATE WITH THISFORM.TEXT4.Value
>>>>replace OFFCODE WITH THISFORM.TEXT5.Value
>>>>replace ENTRYID WITH THISFORM.TEXT6.Value
>>>>replace ENTDATE WITH THISFORM.TEXT7.Value
>>>>replace CONFFLAG WITH THISFORM.TEXT8.Value
>>>>replace CONFID WITH THISFORM.TEXT9.Value
>>>>replace CONFDATE WITH THISFORM.TEXT10.Value
>>>>
>>>>
>>>>FOR gnCount = 1 TO FCOUNT( )
>>>>   m.OldName =  FIELD(gnCount)
>>>>   m.NewName = ALLTRIM(EVALUATE(FIELD(gnCount)))
>>>>     *******************************************************
>>>>   Try
>>>>      ALTER TABLE (tt) RENAME COLUMN (m.OldName) TO (m.NewName)
>>>>   Catch
>>>>      Wait 'Oldname with error is '+m.oldname window
>>>>      Wait 'Newname with error is '+m.newname window
>>>>   Endtry
>>>> NEXT
>>>>

>>>>
>>>>>i try as below, but i think it is wrong way becuse no result
>>>>>
>>>>>

>>>>>CLOSE all
>>>>>SET DATE BRITISH
>>>>>SET CENTURY on
>>>>>thisform.text11.Value=GETFILE('xls')
>>>>>IMPORT FROM (thisform.text11.value) TYPE xls
>>>>>
>>>>>use JUSTSTEM(thisform.text11.value)
>>>>>tt=JUSTSTEM(thisform.text11.value)
>>>>>
>>>>>CLOSE all
>>>>>USE (tt) excl
>>>>> Try
>>>>>*set step on
>>>>>ALTER TABLE (TT) ADD COLUMN TXPNO C(19)
>>>>>ALTER TABLE (TT) ADD COLUMN YEARe C(6)
>>>>>ALTER TABLE (TT) ADD COLUMN INFTYPE C(2)
>>>>>ALTER TABLE (TT) ADD COLUMN INFDATE C(12)
>>>>>ALTER TABLE (TT) ADD COLUMN OFFCODE C(6)
>>>>>ALTER TABLE (TT) ADD COLUMN ENTRYID C(15)
>>>>>ALTER TABLE (TT) ADD COLUMN ENTDATE C(12)
>>>>>ALTER TABLE (TT) ADD COLUMN CONFFLAG C(3)
>>>>>ALTER TABLE (TT) ADD COLUMN CONFID C(12)
>>>>>ALTER TABLE (TT) ADD COLUMN CONFDATE C(12)
>>>>>
>>>>>
>>>>>
>>>>>replace TXPNO WITH THISFORM.TEXT1.Value
>>>>>replace YEARe WITH THISFORM.TEXT2.Value
>>>>>replace INFTYPE WITH THISFORM.TEXT3.Value
>>>>>replace INFDATE WITH THISFORM.TEXT4.Value
>>>>>replace OFFCODE WITH THISFORM.TEXT5.Value
>>>>>replace ENTRYID WITH THISFORM.TEXT6.Value
>>>>>replace ENTDATE WITH THISFORM.TEXT7.Value
>>>>>replace CONFFLAG WITH THISFORM.TEXT8.Value
>>>>>replace CONFID WITH THISFORM.TEXT9.Value
>>>>>replace CONFDATE WITH THISFORM.TEXT10.Value
>>>>>Catch
>>>>>   Wait 'Oldname with error is '+m.oldname window
>>>>>   Wait 'Newname with error is '+m.newname window
>>>>>Endtry
>>>>>
>>>>>
>>>>>FOR gnCount = 1 TO FCOUNT( )
>>>>>   m.OldName =  FIELD(gnCount)
>>>>>   m.NewName = ALLTRIM(EVALUATE(FIELD(gnCount)))
>>>>>     *******************************************************
>>>>>   ALTER TABLE (tt) RENAME COLUMN (m.OldName) TO (m.NewName)
>>>>>
>>>>>NEXT
>>>>>
>>>>>

>>>>>
>>>>>
>>>>>>I'm pretty sure that your problem is the name of the fields, and not the syntax. Try something like this

>>>>>>Try
>>>>>>   Alter table...
>>>>>>Catch
>>>>>>   Wait 'Oldname with error is '+m.oldname window
>>>>>>   Wait 'Newname with error is '+m.newname window
>>>>>>Endtry

>>>>>>Then you write down the wrong values, and tell me what they are.
>>>>>>
>>>>>>>sorry i don't now what you main, or how i can know(to get) the value for OldName and NewName
>>>>>>>What is the value of OldName when you get this error?
>>>>>>>What is the value of NewName when you get this error?
>>>>>>>
>>>>>>>>Please answer my two simple questions!
>>>>>>>>
>>>>>>>>>if you main when i make replace via textboxes it's characters and numbers ,
>>>>>>>>>
>>>>>>>>>if you main excel sheet i have some fields have numbers ,and some fields have characters and ONE field have first record as blabla and next as #
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>What is the value of OldName when you get this error?
>>>>>>>>>>What is the value of NewName when you get this error?
>>>>>>>>>>