>#DEFINE VFP_CRLF CHR(13) + CHR(10) > >LOCAL lcInsertCmd, lcUpdateCmd, lcDeleteCmd, lcSchema > >TEXT TO lcSchema NOSHOW PRETEXT 2 > ACCOUNT_ID I, > GROUP_ID I >ENDTEXT >lcSchema = STRTRAN(lcSchema, VFP_CRLF, [ ]) > >) >) >ENDTEXT >lcInsertCmd = STRTRAN(lcInsertCmd, VFP_CRLF, [ ]) > > > where ACCOUNT_ID = ?crsSecurity_user_group.ACCOUNT_ID AND GROUP_ID = ?crsSecurity_user_group.GROUP_ID >ENDTEXT >lcUpdateCmd = STRTRAN(lcUpdateCmd, VFP_CRLF, [ ]) > >TEXT TO lcDeleteCmd NOSHOW PRETEXT 2 > delete from security_user_group > where > ACCOUNT_ID = ?crsSecurity_user_group.ACCOUNT_ID AND GROUP_ID = ?crsSecurity_user_group.GROUP_ID >ENDTEXT >lcDeleteCmd = STRTRAN(lcDeleteCmd, VFP_CRLF, [ ]) > >WITH THIS > ._BuildSelectCmd() > .DeleteCmd = lcDeleteCmd > .InsertCmd = lcInsertCmd > .UpdateCmd = lcUpdateCmd > .CursorSchema = lcSchema >ENDWITH >>