Question:
Can I set a Select() and an Update() in the same SQL clause, similarly to the example below?
Update EQUIPMENT
Set EQUIPMENT.EQUIPMENT=’<%EQUIPMENT%>‘,
EQUIPMENT.DISABLED=<%DISABLED%>,
EQUIPMENT.CLASS_EQUIP=CLAS_EQUIP.INDEX,
EQUIPMENT.SECTOR=SECTORS.INDEX
Where EQUIPMENT.INDEX=<%INDEX%>
and CLAS_EQUIP.CLASS_EQUIP=’<%CLASS%>‘
and SECTORS.SECTOR=’<%SECTOR%>‘
Solution:
No, you can’t. You must first set a Select() storing CLAS_EQUIP.INDEX and SECTORS.INDEX in two Internal Tags, and only then execute the Update().