>
>DECLARE @lcField Char(40)
>DECLARE @lcField2 Char(40)
>DECLARE @lnNumero Integer
>DECLARE @lnNumero2 Integer
>
>WHILE EXISTS (SELECT 1 FROM Relation)
>BEGIN
> SELECT @lnNumero=Numero,@lcField=Field,@lcField2=Field2 FROM Relation
> PRINT 'Update Relation '+@lnNumero+'.'
>
> SELECT @lnNumero2=Numero FROM Field WHERE Field=@lcField
>
> UPDATE Relation SET NoField=@lnNumero2 WHERE Numero=@lnNumero
>
> SELECT @lnNumero2=Numero FROM Field WHERE Field=@lcField2
>
> UPDATE Relation SET NoField2=@lnNumero2 WHERE Numero=@lnNumero
>
>END
>
I need to select all records at first and loop. I do not think this would do it.
