Re: CeDeleteRecord Anomalies

"zaphead" <benterry1972@xxxxxxxxxxx> wrote in news:1113579353.583011.230500
@f14g2000cwb.googlegroups.com:

> I am trying to use the CeDeleteRecord function on CE4.2. Sometimes
> this function fails (repeatable depending on the database I'm using).
> The odd thing is that it fails (returns FALSE), but an immediate call
> to GetLastError also returns 0. Upon verifying the state of the record
> that should have been deleted, it is indeed still there. Even more
> strange: if I call CeDeleteRecord a SECOND time after it fails the
> first time, the call succeeds and the record is deleted! Can anyone
> explain this behavior? Note: I am implementing a routine that stores a
> CRC with each record I save. I am deliberately corrupting a record
> using a hex editor (simply changing a byte in the record). My outine
> reads records in, verifies the CRC, and if bad, deletes the record.
> This delete is the part that is failing.
>


Hi!

Does your database contain Text as well? And maybe is the sorting depending
on a string field?

I do experience similar problems - not trying to delete the record but just
access it - and I found mine problems are somehow dependent on the text
size just SOMEWHERE on some record within the database.
If you do have text, try limiting it to not more than 250 characters; in my
application, this did quench the problem (sounds like 256 to me...).

I did contact Microsoft support; they're still in the process of thinking.

Kerstin
.

Relevant Pages

  • Re: When to use sub-values
    ... from the outset as if each discrete problem is a database problem -- ... "optimizations" are merely optimizations. ... within LOCATE (depending on the controlling-nesting levels you want to ... reimplemented our own simulated RDBMS to be able to store/retrieve/sort ...
    (comp.databases.pick)
  • Re: About MS-Access RDBMS
    ... ie you shouldn't be able to say 'fails rule 2 because it ... > database not by applications' own exception processing features. ... > 8) Physical independence rule: ... > data manipulation, integrity rules, authorisation etc. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: About MS-Access RDBMS
    ... Since Access fails rule 1, ... database not by applications' own exception processing features. ... Physical independence rule: applications and interactive operations ... Access can define unique key and foreign key integrity rules, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: The future of Linux
    ... Occasionally, I might use a spreadsheet, wordprocessor, or database. ... depending on the selection of OS your work uses. ... "bash history" that remembers your commands and allows you to search ... talking to remote databases without a GUI overhead across the network. ...
    (comp.os.linux.misc)
  • Re: asp.net, vs2k5, getting started connecting to databases... Im confused
    ... It's a bit confusing when you first get started and the short answer ... Depending on how you want to display the data in your webparts, ... // this with the current connection. ... // Close data reader object and database connection ...
    (microsoft.public.dotnet.framework.aspnet)