Creating a DB

Probe

Delphi Developer

Fri, 08 Oct 2004 21:37:28 GMT

Creating a DB

I want to create a db with a Query statement.
On TSQLQuery.ExecSQL I get the following exception:
Cannot prepare a CREATE DATABASE/SCHEMA statement

Thomas Mille

Delphi Developer

Fri, 08 Oct 2004 22:26:42 GMT

Re:Creating a DB

This is a known limitation for Interbase

Quote

Probe wrote:
> I want to create a db with a Query statement.
> On TSQLQuery.ExecSQL I get the following exception:
> Cannot prepare a CREATE DATABASE/SCHEMA statement

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com

Craig Stuntz [TeamB

Delphi Developer

Sat, 09 Oct 2004 00:47:23 GMT

Re:Creating a DB

In article <3CC41DA2.2030...@bss-software.com>, tmil...@bss-software.com
says...

Quote

> This is a known limitation for Interbase

...of the dbExpress driver for IB, that is. Here are two
workarounds:

1) Ship a backup of an empty GDB. Restore it from your program and
populate it using DDL.

2) Include TIBDatabase from IBX in your program for the sole purpose of
creating the database. Once it's created, use dbExpress as usual.

HTH,

-Craig

Other Threads

1. Foxpro DB migrate to MSDE / Create MSDE DB

2. How to create Access DB via Delphi?

3. How to create new DB in Delphi application?

4. Creating a DB using DDL

5. How to create a DB table with index

6. Q: Blob Fields in Delphi2 Can't create a DB

7. possible to create mini-db app in delphi?

8. Create new DB (MSSQL7)

9. Create Paradox Db files at run time

10. Create New DB - Charset