cursor.UpdateRecord

[Ivan Smahin]

Hello Karl,

Thursday, April 19, 2007, 5:14:41 PM, you wrote:

KG> Dear Ruslan

KG> I do have a similar problem.

KG> The Database is a very simple One-Table-Database and i work in  
KG> Classes-Way (no Server) in RB2007R2 (Val 2.9)

KG> The update-Procedure does not work at all, the Programm quits without
KG> error etc. There is no proper Cursor (=VCursor) but the code is  
KG> similar to V4RBRef-page69

KG> Example:
KG> ...
KG> rTbl = myDB.myReg (Table of DB)
KG> EF_ = Editfields

KG>    rTbl.RecID = val(ST_Rid.Text) -> this is a existing RecId of the  
KG> Table "rTbl"
KG>    if Trim(EF_Titel.Text) > "" and Trim(EF_Zeile_1.Text) > "" then
KG>      MsgBox " Titel und 1. Zeile können nicht gleichzeitig  
KG> aktualisiert werden"
KG>    else
KG>      if Trim(EF_Titel.Text) > ""  then
KG>        rTbl.Eintrag.value = EF_Titel.Text
KG>        rTbl.istTitel.value = True
KG>      else
KG>        rTbl.Eintrag.value = EF_Zeile_1.Text
KG>        rTbl.istTitel.value = False
KG>      end if
KG>    end
KG>      .....

KG>   rTbl.TxtNr.value = EF_Text_Nr.Text
KG>    rTbl.fldFrank.value = EF_Frank.Text
KG>    rTbl.ReplEintrag.value = makeReplaceEintrag(rTbl.Eintrag.GetString)
KG>    rTbl.SortEintrag.value = makeSortEintrag(rTbl.Eintrag.GetString)
KG>    rTbl.UpdateRecord -> -> Program quits
KG>    rTbl.Flush


KG> BTW: rTbl.addRecord works in a very similar Procedure (but adding  
KG> instead of updating) without problems.

As far as I get it you are trying to update the table - not cursor?
Could you report it to mantis?
Have you tried our examples?

Examples\SQL_way\Records_AddDeleteUpdate
Examples\API_way\Records_AddDeleteUpdate



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com