Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 21.1 ('Xojo Eliza')
Instant purchase and download via GumRoad!

COLUMN

MS SQL Server

Using the Xojo MSSQLServer Plugin

Issue: 21.1 (January/February 2023)
Author: Vince Du Beau
Author Bio: Vince is an experienced Filemaker developer. He is exploring Xojo as an alternative to Filemaker.
Article Description: No description available.
Article Length (in bytes): 4,826
Starting Page Number: 98
Article Number: 21110
Resource File(s):

Download Icon project21110.zip Updated: 2023-01-03 09:08:37

Related Web Link(s):

http://www.microsoft.com/en-us/sql-server/sql-server-downloads
http://innerjoin.bit.io/introducing-pgsqlite-a-pure-python-module-to-import-sqlite-databases-into-postgres-bf3940cfa19f

Excerpt of article text...

Microsoft's SQL Server originally started out as a product for IBM's OS/2. Today it is one of the leading database servers. You can download it online (http://www.microsoft.com/en-us/sql-server/sql-server-downloads). If you are looking to play around or test the waters or write a column there are two free versions, Developer and Express. A full paid version would probably be best for a production environment. I chose the Developer version. When you install it you also install the SQL Server Studio which can be used to manage and query your databases. I am using 64-bit Windows 10 in a Virtualbox VM.

Xojo has a plugin for MSSQLServer, as most users know.

When you start the SQL Server Management Studio you will see something similar to Figure 1.

On the left side you will see details about the server. If you expand the database topic it will show a list of the databases. As you can see, I have already created the Chinook Database. If you wish to create the Chinook database for yourself, you can open the included file by clicking on the open folder (see Figure 2). This will automatically open a new query tab. Then just click on the Execute button (See Figure 3). You could also open a new query tab, copy and paste the SQL code into the new query, and click on Execute.

If you wish to create a new database from scratch, please read the documentation.

I am using the same Chinook database that I used for the ODBC examples. I will supply the SQL code to create it with the column. The code sample is a modified version of the ODBC code for SQL Server:

...End of Excerpt. Please purchase the magazine to read the full article.