>>>>Hi,
>>>>
>>>>Say I have a table that has column MY_INT_FLD I(4). There could be some records in this table that have the same value in this field. And some records that have 0 in this field. I want to create one or two (or maybe even three) UPDATE command(s) that will set each record of this table to a unique value and it has to be greater than 0. Is it possible? TIA.
>>>
>>>
>>>If your table has a primary key, with one update is possible
>>>
>>>

>>>	create cursor MyTable ;
>>>	(	Pk		I, ;
>>>		MY_INT_FLD	I ;
>>>	)
>>>	
>>>	for i = 1 to 100
>>>		insert into MyTable values( 10000+ i, 22)
>>>	endfor
>>>	
>>>	update MyTable ;
>>>		set	MY_INT_FLD = tmp ;
>>>		from ( ;
>>>				select	Pk, ;
>>>						recno() as tmp ;
>>>					from MyTable ;
>>>			) X ;
>>>		where ( MyTable.Pk== X.Pk)
>>>	
>>>

>>
>>The table does not currently have a primary key. What I am trying to do (why I posted the question) is to make this field in question to be primary key. But in order to do it I need to make sure that every record has a unique value. Otherwise, on update I will get the error. Thank you.
>
>
>In that case
>(1)
>

>	create cursor MyTable ;
>	(	;
>		MY_INT_FLD	I ;
>	)
>	
>	for i = 1 to 100
>		insert into MyTable values( 22)
>	endfor
>	
>	update MyTable ;
>		set	MY_INT_FLD = recno()
>

>
>(2)
>

>
>	create cursor MyTable ;
>	(	;
>		MY_INT_FLD	I ;
>	)
>	
>	for i = 1 to 100
>		insert into MyTable values( 22)
>	endfor
>	
>	alter table MyTable ;
>		alter MY_INT_FLD I autoinc 
>	
>	blank fields MY_INT_FLD default autoinc all in MyTable 
>

Thank you. I have never yet used autoinc type field yet. And all my code relies on PK values (in VFP application) to be created based on the PK-seed table (PK_FILE.DBF). So the above approach would require that I change that. I am not ready to go there, yet. Again thank you for your help.