U++ forum: Welcome to the forum

Re: Create Table with Sqlite [message #12964 is a reply to message #12255]

Fri, 30 November 2007 18:05

Novo
Messages: 1430
Registered: December 2006

Ultimate Contributor

luzr wrote on Sun, 21 October 2007 18:01

Alex wrote on Sun, 21 October 2007 16:43

Problem solved:

I have to delete all sql-connections (in this sample sqlVer and sqlRaum), and then does the "create table" command work.

Alex

Thanks, looks like a good Sqlite tip Smile

Mirek

Practice when Data Definition Language statements destroy all Data Manipulation Language statements is quite common. This situation should be handled by database API wrappers. Same as committing of all open transactions by DDL.

BTW. If recall correctly, there was an improvment to sqlite's API in order to fix similar situations.

Regards,
Novo

Report message to a moderator