Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Sqlite3 Forcing creating a database
Sqlite3 Forcing creating a database [message #8714] Mon, 26 March 2007 21:56 Go to next message
DuncanShortland is currently offline  DuncanShortland
Messages: 45
Registered: January 2006
Member
Using 2007.1rc2

What are the conditions for sqlite to create a new database?

I am trying to create a new empty database using the sample SQL book example.

Changing the dataabse name does not create an empty database.

But somehow the database can appear.

How can it always be created?
Re: Sqlite3 Forcing creating a database [message #8715 is a reply to message #8714] Mon, 26 March 2007 23:12 Go to previous message
mirek is currently offline  mirek
Messages: 13975
Registered: November 2005
Ultimate Member
DuncanShortland wrote on Mon, 26 March 2007 15:56

Using 2007.1rc2

What are the conditions for sqlite to create a new database?

I am trying to create a new empty database using the sample SQL book example.

Changing the dataabse name does not create an empty database.

But somehow the database can appear.

How can it always be created?


Well, deserves an explanation:)

Over years, the most convenient way how to do things is to compare the content of db creation (actually, upgrading) scripts and if they do differ, execute them on database. So if you want to *force* this, just delete .sql files from config directory (empty will not match and scripts will be performed).

Mirek
Previous Topic: Is this correct?
Next Topic: how to connect to sqlite via U++ in VC++
Goto Forum:
  


Current Time: Mon Apr 29 01:20:24 CEST 2024

Total time taken to generate the page: 0.09693 seconds