>REPLACE ; > FirstName WITH "Bob", ; > LastName WITH "Smith", ; > BirthDay WITH {01/01/1960}, ; > Gender WITH "M", ; > Address1 WITH "1234 Main Steet", ; > Address2 WITH "", ; > City WITH "Los Angeles", ; > State WITH "CA", ; > Zip WITH "90001", ; > Phone WITH "(123)555-1234" ; > IN AddrBook >I would do this to make it more like a SQL statement:
REPLACE FirstName WITH "Bob", ; LastName WITH "Smith", ; BirthDay WITH {01/01/1960}, ; Gender WITH "M", ; Address1 WITH "1234 Main Steet", ; Address2 WITH "", ; City WITH "Los Angeles", ; State WITH "CA", ; Zip WITH "90001", ; Phone WITH "(123)555-1234" ; IN AddrBookI also believe people who write case statements like this:
DO CASE CASE whatever1 * Code here CASE whatever2 * Code here ENDCASEShould be shot. The correct way to write a case statement, as everyone should know, is this:
DO CASE CASE whatever1 * Code here CASE whatever2 * Code here ENDCASEIt's only natural. :-)