Location: PHPKode > scripts > LQueryBU > LQueryBU/query_units/examples/units/saveCity.php
====QUERY====
UPDATE 
	City
SET
  Name = '$RECORD->Name',
  CountryCode = '$RECORD->CountryCode',
  District = '$RECORD->District',
  Population = '$RECORD->Population'
WHERE
  ID = $RECORD->ID

====PRE_FORMAT_FIELDS====
<?php 
// Before to eval QUERY, you can check or assign here any variable


?>
====POST_FORMAT_FIELDS====
<?php
// Yo can add here any post action to be executed for all records

?>
====POST_FORMAT_FIELDS_NO_RECORDS_FOUND====
<?php 

?>
====POST_SQL_COMMANDS_OK====
PHP: <?php ?>
SQL
====POST_SQL_COMMANDS_KO====
PHP: <?php return -1;?>
SQL:
====POST_SQL_COMMANDS_NO_RECORDS_FOUND====
PHP: <?php ?>
SQL:
Return current item: LQueryBU