SELECT *
FROM tbl_how_hear
ORDER BY iSortOrder
INSERT INTO
tbl_how_hear
(sHowHear, iNoGenealogy, iSortOrder)
VALUES
('#ARGUMENTS.sHowHear#', #ARGUMENTS.iNoGenealogy#, #ARGUMENTS.iSortOrder#)
UPDATE tbl_how_hear
SET sHowHear = '#ARGUMENTS.sHowHear#',
iSortOrder = #ARGUMENTS.iSortOrder#,
iNoGenealogy = #ARGUMENTS.iNoGenealogy#
WHERE iHowHearIDPK = #ARGUMENTS.iHowHearIDPK#
SELECT *
FROM tbl_how_hear
WHERE iHowHearIDPK = #ARGUMENTS.iHowHearIDPK#
DELETE
FROM tbl_how_hear
WHERE iHowHearIDPK = #ARGUMENTS.iHowHearIDPK#
SELECT *
FROM tbl_how_hear
WHERE iHowHearIDPK =