[V4RB] Duplicating record

[Christer Olsson]

>On 3/5/05 4:26 PM, "Christer Olsson" <christer at ljusaideer.se> wrote:
>
>>>>> If no BLOBs then you can try.
>>>>> Should work, Christer
>>>> 
>>>> Believe me, I have tried. All I get is a new empty record. Any other
>>>> pitfalls
>>>> than BLOB fields? Any example code you could share?
>>> 
>>> How you do this ?
>>> 
>>> Steps ?
>>> 
>>> You should not call SetBlank() if you try do duplicate
>> 
>> No setblank() called. My stripped down non-working code:
>> 
>>   dim query as String
>>   dim res as Boolean
>>   dim c as VCursor
>> 
>>   query = "SELECT recID,* FROM company WHERE recID = '150'"
>>   c = app.mDataBase.SqlSelect( query, 2, 3, 2 )
>>   c.Field("ID_fld").SetString( "newID" ) // unique field
>>   res = c.add
>
>2 3 2 
>
>This is serverSide, ReadWrite ?

Yes.
-- 

  *************************************************************
  Christer Olsson   PO Box 9160        Phone +46 40 25 85 85
  Ljusa Idéer AB    SE-200 39 Malmo    Fax +46 40 25 85 89
  Kantyxegatan 5    Sweden             http://www.ljusaideer.se