Hi Mark,

I discovered the following scenario which causes the caBuilder to error out:

One of the SQL Server tables in a DB we have contains just two fields, Account_ID and Group_ID, both of which make up the primary key. When the caBuilder tries to generate the class, it crashes when trying to write the _CA_DMLCode method.

During Cr8_DMLCode(), since the only two fields in the table both end up being in the excluded list (henced looped over), the first parts of lcInsert and lcUpdate never get created which results in orphaned ENDTEXT blocks:

#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

Could you put this on the caBuilder wish list? :)

Thanks,

- Brian