[V4RB] Duplicating record

[Christer Olsson]

>On 3/5/05 4:06 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


-- 

  *************************************************************
  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