Okay Tore ;o)

>1 in stead of 13 was a typo. SET RANT ON and SET RANT off means that whatever is between those two lines are ment not to be taken too seriously, but more like a friendly joke.
>
>>Tore,
>>what is this ?
>>

SET RANT ON

>>and
>>what is this ?
>>

for x=1 to 1

>>may by
>>

for x=1 to 13

>>
>>
>>>SET RANT ON
>>>Do you ever check with help?
>>>SET RANT OFF
>>>

>>>SET EXCLUSIVE ON & Not OFF, OFF is if you must share, to pack it must be ON!!!!!!!!!
>>>

>>>By the way, SET EXCLUSIVE OFF is usually only set ONCE in your program, or in the config.fpw file. In stead you add the EXCLUSIVE keyboard whenever you need it
>>>
>>>

>>>for x=1 to 1
>>>  use ('month'+alltrim(str(x,2))+'2005') EXCLUSIVE
>>>  delete for no=1151
>>>  pack
>>>endfor

>>>And if you need to PACK regularly, you should reconsider your design. PACK should typically be used about once a year to clean up the tables, not daily or weekly!
>>>
>>>>hi,
>>>>i try to make pack only at one pc, i get error message "File must be opened exclusively "
>>>>

>>>>SET EXCLUSIVE off
>>>>for x=1 to 13
>>>>  delete FROM ('month'+ltrim(str(x))+'2004') where no=1231
>>>>  pack    &&File must be opened exclusively
>>>>endfor
>>>>

>>>>
>>>>thanks
>>>>>>>

>>>>>>>for x=1 to 1
>>>>>>>  use (trim(str(x,2))+'2005')
>>>>>>>  delete for no=1151
>>>>>>>endfor

>>>>>>
>>>>>>trim() will only trim to the right, IIRC. Here you need ltrim() or alltrim(); or simply convert the number with trans(x).
>>>>>
>>>>>Yes, I ment to use alltrim, but I simply forgot. I also thought about the transform function, but on top of my head I was not sure if it defaulted to trim the result or not, but it sure does. So your solution is the simplest in this case.