insert into address_book
(
customers_id,
entry_username,
entry_gender,
entry_company,
entry_firstname,
entry_lastname,
entry_street_address,
entry_postcode,
entry_city,
entry_state,
entry_country_id,
entry_zone_id)
values
(<@KEY@>,
'<@SACCOUNTCODE@>',
'<@GENDER@>',
'<@COMPNAME@>',
'<@NAME@>',
'<@LASTNAME@>',
'<@SPOSTAL1@>',
'<@SPOSTALCODE@>',
'<@SPOSTAL2@>',
'<@SPOSTAL3@>',
<@PROCESS@>&SELECT countries_id from countries where UPPER(countries_name) = upper('<@COUNTRIES_NAME@>')##,0)
@@GO@@
update customers set
customers_default_address_id = LAST_INSERT_ID()  where customers_default_address_id = 0 and customers_id = <@KEY@>
@@GO@@
 


