SQL Equivalent

[Bastiaan Olij]

Hey Jorge,

You need to name your other table as well:

UPDATE Lot
SET Lot.ItemSeq = Items.Seq
FROM Items
WHERE Items.id = Lot.idItems

Not sure what you're trying to do though...

Cheers,

Bas

On 20/08/13 9:54 AM, Jorge Arias wrote:
>
> Hello,
>
> I am changing one of my applications from DML to SQL (Native data file),
>
> Which SQL statement would be the equivalent of
>
> Find first on Lot.Seq
> Repeat
> Single file find on Items.id (Exact match) {Lot.idItems}
> If flag true
> Prepare for edit
> Calculate Lot.ItemSeq as Items.Seq
> Update files
> End If
> Next on Lot.Seq
> Until flag false
>
> I tryed this:
>
> UPDATE Lot SET  Lot.ItemSeq=Items.Seq WHERE Items.id=Lot.idItems
>
> but of course... it didn't work.
>
> Thanks in advanced
>
> Best Regards,
> Jorge A. Arias
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
>


-- 
Kindest Regards,

Bastiaan Olij
e-mail: bastiaan at basenlily.me
web: http://www.basenlily.me
Skype: Mux213
http://www.linkedin.com/in/bastiaanolij