> Bronislav Klučka <[EMAIL PROTECTED]> writes: > > > PLIIIIIIZ HELP ME > > > >> > > I've read the documentation, where is written: "When the > database first > >> > > opened, SQLite reads the database schema into memory and uses that > >> > > schema to parse new SQL statements. If another process changes the > >> > > schema, the command currently being processed will abort > because the > >> > > virtual machine code generated assumed the old schema. This is the > >> > > return code for such cases. Retrying the command usually > will clear the > >> > > problem." > > The easest solution to this problem is to re-open the database > when you get > the schema changed error. > > If your application must regularly drop and recreate tables, then > maybe it's > appropriate to use > > DELETE FROM TABLE WHERE 1; > > instead of just > > DROP TABLE; CREATE TABLE ...; > or > DELETE FROM TABLE; > > which will just delete the records without removing the table; > i.e. the schema > is not changed this way. >
1/ I cannot re-open the database. I have 1 "database" component and many "query" components (writen in delphi) connected to the database as set in "database" component, that means that I would have to re-open the main database component and then all query components, but some of them can process query at that time.. reopening is not a solution. 2/ I do not need recreate table (or delete table) it's general problem with database managing, this components should process the database and one of the possibility is to delete table... Brona --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
