deleteAllRecords()

[Ruslan Zasukhin]

on 10/20/03 0:27, Florian Bogeschdorfer at fb at memedia.de wrote:

> Hi Ruslan,
> 
> My Valentina application worked fine for a few days until my client choosed
> the function where deleteAllRecords() was used. Since then the table
> obviously does not accept adding records anymore
> 
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM Z_DAY",2,1,2)
> 
> -- <Xtra child "VCursor" 2 269800c>
> put valcursorreccount(c)
> -- 8
> 
> put valaddrecord("Z_DAY",[#Z_DAY_Umsatz:123.0])
> -- 1
> c=0
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM Z_DAY",2,1,2)
> put valcursorreccount(c)
> -- 8
> 
> See the log:
> 
> 23:12:01.215000 (2368): (668) SQL: select RecID, * from Z_DAY; # of records:
> 8
> 23:12:01.215000 (2936): (668) CURSOR(e55e00): FirstRecord : OK
> 23:12:01.215000 (2936): (668) CURSOR(e55e00): Adding record #9: OK
> 23:12:01.225000 (3000): (668) Flushing 'me-inside' database: OK
> 23:12:17.017000 (2936): (668) SQL: SELECT * FROM Z_DAY; # of records: 8
> 23:12:17.017000 (2936): (668) CURSOR(e54cc0): FirstRecord : OK
> 23:12:39.089000 (2392): (668) Flushing 'me-inside' database: OK
> 23:12:43.926000 (2936): (668) SQL: SELECT * FROM Z_DAY; # of records: 8
> 23:12:43.926000 (2936): (668) CURSOR(e55e00): FirstRecord : OK
> 
> It should be nine by now. But there was NO error returned!!!

Florian,

Another tip. Please try

1) STOP SERVER and trash .ind file of that db. START it again, so all
indexes will be rebuilt. Does this fix problem?

Before do this please make a copy of bad db.


2) or you can do this without stop of server by sending
    "REINDEX DATABASE" command.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------