SqlCe and Secure Digital

[Simone]

Hallo.
I have this problem.
In my app, i insert data into an SDF that is located on a Secure Digital.
After inserting Data (no SqlCeException during install), i cannot find all
records into DB.
I have seen that in my SD the free space is about 3MB. Then i free space of
the SD and the next INSERT insert all records on SD.

The problem is the space of the SD? Why during the insert of the data with
the command INSERT, CF don't send me SqlCeException?

Thanks Simon.

 

[Guest]

It probably has nothing to do with free space, but caching. I'm betting the
driver or the controller is caching the write until the stream is flushed.
After you insert, close the connection and see what happens.