David,

Thanks a lot.

>Naomi,
>
>>How can we specify default field values to be carried over using CA? We're using CA Builder from Mark McCasland.
>
>You can add a DEFAULT clause (and also CHECK constraint if needed) to the .CursorSchema property cursor definition. This can be useful to avoid NULL values if you APPEND BLANK into the cursor or to pre-populate certain fields:

CursorSchema = "cstate C(2) DEFAULT 'FL', ccounty C(20) DEFAULT ''"

The syntax for DEFAULT and CHECK are the same that you would use in the CREATE CURSOR command, although you cannot specify NULL or NOT NULL in the CursorSchema (it automatically gets that setting from the SQL backend).