deleteAllRecords()

[Ken Ray]

I ran into this a couple of times myself, but it went away... it seemed
to take place only if the number of records you are deleting is large
(it happened when I deleted a table of 5000 records, but didn't when I
deleted a table of 8 records).

Closing and reopening the database connection worked to workaround this
problem, and I was getting ready to send a post to the list when it
mysteriously disappeared.

Oh, and I'm using VXCMD and not V4MD, so the problem is with the
database and not the client (it seems).

I wish I could make it happen again, but perhaps Florian's DB will help
you guys track it down.

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/ 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Florian Bogeschdorfer
> Sent: Sunday, October 19, 2003 4:27 PM
> To: 'Valentina Developers'
> Subject: deleteAllRecords()
> 
> 
> 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!!!
> 
> I am on a42, V4MD and of course the cursor was not locked
> 
> 
> I try changing a record now...OK
> 
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM 
> Z_DAY",2,1,2) Put valcursorreccount(c)
> -- 8
> 
> -- 8
> put deleteAllRecords(c)
> -- 1
> C=0
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM 
> Z_DAY",2,1,2) Put valcursorreccount(c)
> -- 8
> 
> 
> Another table:
> 
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM
> BUCHUNGEN_PLUtable",2,1,2)
> 
> put valcursorreccount(c)
> -- 2488
> put deleteAllRecords(c)
> -- 1
> put valcursorreccount(c)
> -- 0
> c=0
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM
> BUCHUNGEN_PLUtable",2,1,2)
> put valcursorreccount(c)
> -- 0
> put valaddrecord("BUCHUNGEN_PLUtable",[#BPL_Name:"Hallo"])
> -- 1
> c=0
> c= new(xtra "vCursor", GetRef(VAL[#ID]), "SELECT * FROM
> BUCHUNGEN_PLUtable",2,1,2)
> 
> put valcursorreccount(c)
> -- 1
> 
> It WORKS HERE, WHY NOT ON THE OTHER TABLE.
> 
> RUSLAN, IGOR, SERIOUSLY, THERE IS A PROBLEM WITH THIS 
> FUNCTION. I would like to send you the database (about 100 
> K), so you can look why I can not add records to the table...
> 
> Best regards, Florian
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net 
> http://lists.macserve.net/mailman/listinfo/val> entina
>