The correct command is "DROP TABLE table_name" which I am sure it is
not present in your code.
Maybe you are inserting your table and their data inside a
transaction and then instead of "commit" you "rollback"... or there
is an error somewhere executing an sql command that you are ignoring...
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Dec 12, 2006, at 3:00 PM, Youri wrote:
Marco,
Thanks for your reply. I am expecting my (our) code to be faulty,
but I have to trace that down. In fact this code is totally based
on the one used for the Training course I was participating.
To your opinion, and to try to concentrate on the essential to
track the bug down, apart from issuing a SQL string as "DROP
DATABASE database_name" (which is not present in my code), what
sort of other command could delete a Table in the Database?
TIA,
Youri
Marco Bambini wrote:
You can't really lose a table with the sqlite engine, there are
rare occasions where you can corrupt the database but it is nearly
impossible to just lose a single table.
I am sorry to said you but I am 99% sure that the issue is in your
code...
Give me more details if you want an help.
Regards,
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Dec 12, 2006, at 12:10 PM, Youri wrote:
Andre,
It can't be that. As when the DB is opened with SQLiteManager,
the Table HAS disapeared.
The French Technical Support doesn't either find a reason for
this problem.
Cheers,
Youri
Andre Kuiper wrote:
Hi Youri,
This i cannot reproduce on windows, not even with several
databases and tables. From your story i suspect your app is
losing track of the place where it stored the databasefile, not
RealSQL losing tables.
HTH
Andre
Youri schreef:
Hi,
I am actually very concerned about the
reliability of RBSQL.
Let me explain. I run a MacBookPro on 10.4.8 and RB2006 r4.
I went to 2 training courses lately on which we have
concentrated our
efforts on developping DB app with RBSQL.
During these 2 courses we encountered a very weird behavior
with RBSQL.
Using a simple Database with 1 table and 4 fields, we had the
Table
disapearing sort of "randomly". First time we thought we had
traced the
problem linked to Rosetta. But the second time the problem
arroused only
on one of the 3 machines.
We then thought about a bug in our RB app.
Back at the office, I am experienceing the same problem
(disaperarence of Table in a RBSQL Database).
Let me add that, the app was ran yesterday evening. This
morning I run he app (without any modification/change..) and at
the start the Table has disapeared.
Any thought from regular RBSQL users?
TIA,
Youri
Scott Goelzer wrote:
I've been using it for a year now with few problems that
cannot be traced back to myself. Rock solid so far.
Caveats: I am an amateur user who does not make complex sql
calls. I store and retrieve information in strings.
Seems to be very quick even with my cavemen code hammering at.
I have yet to corrupt a database.
A couple of tips I gleaned from the list that seem to work.
1) Create and manage the database from code. The DB editor in
the IDE can be very quirky. Most of problems went away when I
gave up on the IDE editor and wrote my own.
2) I do not use any of the db controls or objects in the IDE.
Easier to write and control your own classes that retrieve and
set data.
my two cents.
HTH
Scott
*******************************************
Scott Goelzer
Physics Teacher
Coe-Brown Northwood Academy
Northwood NH 03261
[EMAIL PROTECTED]
*******************************************
On Dec 10, 2006, at 5:28 PM, Youri wrote:
Hi,
Is there some developer around using RBSQL for a while
in DB projects?
What do you think about RBSQL Stability, reliability?
What about RBSQLServer?
Cheers,
Youri
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
