Now that we know how to connect , find , insert and delete records there is one more action that we will write about in this series of articles on ODBC. As well as all the above we will need at some point in time to know how to update a record. This article will show you how to do just that.
Learn ODBC : Deleting a records
In this article we are going to learn how to delete a record with ODBC. We will use the same base code as we have done in the previous examples and just add the additional delete function.
Learn ODBC : Inserting Records
In this article we are going to learn how to insert records into a sql database. The function we will create will be setup to insert into a non Data Collection Table.
Learn ODBC : Finding a record
In this second article about ODBC we will begin to explore the ADODB.Recordset object. We will take what we have learnt previously and use it to write a function that will connect to a database table using the ADODB.Connection object and find a specific record, once found we will return its id.
Learn ODBC : Getting Connected
In this set of articles we will learn how to write code that will allow you to connect to tables within a database. We will show you how to connect to Data collection tables as well as normal SQL tables and show you the four things that you will need to do with them, find, Delete , update and export the records. This first article will teach you how to connect to a Data Base using the ADO object.
Clean a specified Context of HTML
Ever wanted to get rid of the html from a specific context? Have you needed to create a clean MDD and get rid of the annoying characters that are messing up your Reports for survey tables? If the answer is yes to either one or both of these questions then you should read this article. In it we explain how to open up your MDD file in your dms script and clean the metadata of all those unwanted characters before you export the data.
Adding Hints to your metadata
Recently we posted an article on how to use Autoanswer and from that article we got a request to do an article on how to use hints. So here you are , an article on autoanswer hints and how to use them.
Create test data with AutoAnswer
Do you need to create some test metadata and data that you can play with. If you do then check this article out. In it we will show you how to use the AutoAnswer system that comes with Author and Author Professional Data Collection tools.
Inactivate a job on a specific date.
Ever wanted to schedule turning a project to inactive so that no more interviewers can be collected? This article shows you how to login to the DPMServer , find the project and make it inactive.
An early Christmas present from Verge Consutling
Christmas is almost apon us and before we know it , we will all be in holiday mode, sitting back relaxing. Anyway , as you already know , Verge Consulting is a company that works in the SPSS IBM Data Collection space offering a wide range of products and services. Just recently they sent eveyone they knew a present of some realy cool templates and special features. This article shows you a few screen shots of some of the things they are giving you for free. The full download can be found here. Thanks Verge and Happy Christmas Everyone !!!