Creating A Database Object
A Database object is where SQL Yoga stores all of the information about your database that is used to automate the creation of SQL queries for you.
Let's look at how to create a Database object.
Note: The SQL Yoga distribution includes a Revolution IDE plugin that is helpful during development. To learn more about the plugin please visit the plugin manual.
Note: The examples used in these tutorials will use the default values for many of the parameters passed into the SQL Yoga handlers. In cases where you are only using one Database object (most cases) there is no need to pass parameters to a command like dbobject_createObject. If you plan on using multiple Database objects make sure you read the API documentation so you understand what the parameters are.
1) Create a Database Object
You can use dbobject_createObject to create a new database object in memory.
This code only needs to be run once so you can execute it in the message box if you would like.
==========
Copy & Paste
==========
dbobject_createObject
put the result
Now a new Database object exists in memory. The name of the Database object is default.
Note: SQL Yoga will throw an error if a Database object named default already exists.
Can you supply an example of ODBC. Using SQL Server with my system.