Differences

This shows you the differences between two versions of the page.

--- swdev:howto:create_database_using_firebird [2011/02/25 16:16]
smayr [Run an embedded SQL Script against Firebird]
+++ swdev:howto:create_database_using_firebird [2011/02/25 16:17] (current)
smayr [Run an embedded SQL Script against Firebird]
@@ Line 407: / Line 407: @@
   # Create a text file named 'Test.Sql' to contain your Firebird SQL script and save it in your project directory. I would suggest including a ''CREATE TABLE'' statement such as: <code sql>
 CREATE TABLE CLIENTS (
-client_id integer not null,
+  client_id integer not null,
-firstname char(20),
+  firstname char(20),
-lastname char(20),
+  lastname char(20),
-PRIMARY KEY (client_id)); </code>Note: The filename is case sensitive, if you choose a different filename you will need to amend the sample code to reflect this change.
+  PRIMARY KEY (client_id)); </code>Note: The filename is case sensitive, if you choose a different filename you will need to amend the sample code to reflect this change.
   # Add the file you created in Step 4 to your project and set the build action to Embedded Resource.
   # Add a button to your form named buttonRunScript and check that its Click Event is set to the ButtonRunScriptClick Event Handler.