>>
>>your code was fine (it would work anyhow).
>>
>>i use this:
>>
>>procedure fill_activity
>>if !used('uniqueid')
>> use po_cgms!uniqueid in 0
>>endif
>>select uniqueid
>>local llLock && local limited lock
>>local lnRetVal
>>llLock = .f.
>>do while !llLock
>>if rlock()
>> llLock = .t.
>> llRetVal = uniqueid.idnumber
>> replace idnumber with idnumber + 1
>> unlock
>>endif
>>enddo
>>
>>return llRetVal
>>
>>
>>this goes in the stored procedure portion of your dbc.
>
>After reading your responses for the past 4 months, I know you are not going to like this next questions, but I do not know where in the dbc I put the stored procedure. This will be my first stored procedure.
>I need the ABC blocks for the first one, you know, step by step.
1. open your project
2. look in your database (data tab)
3. try a few times and see how it works.
once you add the stored procedure and call it in the
default value function for that field in your table, the column will be generated automatically when you add a record (ctrl y or append blank)