Thanks! I would definitely welcome comments and suggestions. I'll also look into fixing the DeleteCmd. I was a little short sighted on that one.
>
Hi Brian,
>>
>>Did I goof up the DeleteCmd in my builder for over 254 characters?
>>
>>
>Hi Mark,
>
>Humm, "goof up" is rather strong, maybe you did it for a reason <s>
>
>Basically in Cr8_DMLCode() .DeleteCmd gets written "directly", so if the cUpdateWhereClause is long, it stops the whole build process when it comes time to the WriteMethod() call in AddClass().
>
>
>...
>WITH THIS
> ._BuildSelectCmd()
> .DeleteCmd = [delete from <<LOWER(THIS.cTableName)>> where <<THIS.cUpdateWhereClause>>]
> .InsertCmd = lcInsertCmd
> .UpdateCmd = lcUpdateCmd
> .CursorSchema = lcSchema
>ENDWITH
>...
>
>
>I've been using your caBuilder for a side project (using SQL Server backend) that I've been tasked with recently and it has been extremely useful. Many thanks. I was going put a small list together of suggestions for you to consider but I just haven't had the time yet.
>
>
>- Brian
Mark McCasland
Midlothian, TX USA