>You can't specify default values for free tables. You'll either have to put the tables in a DBC or specify every field you want to put a value in in your INSERT INTO statement.
>
>>Hello all,
>>
>> I have problem that I have free tables in my application. When i Insert any records using Insert Into command, it replaces the values which are not specifing in that command by .NULL. ie for all, for date, for numaric. etc. I didnt find any way to specify default value for free tables.
>>
>>TIA
>>
>>AMIT

He can still create local updatable views for these tables, and have all the DBC features available for the views.