Geez you're fast. :)
I just caught that as I posted it.
Thanks
>One or more of the fields are longer than 10 chars (i.e. rd_approve_date). Free tables only allow 10 characters as maximum for field names.
>
>>What is wrong with this code?
>>
>>
>>CREATE TABLE assets FREE (region c(6), market c(6), location c(6), asset_type c(10), asset n(10), tag_nbr c(15), description c(30), insrv_date D NULL, ;
>> life n(3), life_rem n(3), book_basis n(9,2), book_val n(9,2), last_close n(9,2), status c(10), completed d NULL, submit_date D NULL, ;
>> rd_approve_date d NULL)
>>
>>
>>Im getting "Field name duplicate or invalid..." error.
>>
>>
>>FWIW: CREATE CURSOR assets... works.
>>
>>TIA.
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville
No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)