Accessing IDD Table codeValues with SQL

File uploaded by Gary_Cherlet on Dec 3, 2014Last modified by Gary_Cherlet on Dec 3, 2014
Version 2Show Document
  • View in full screen mode

This document shows you how an IDD Code Table can be made to behave like an SQL Table to, for example, convert State Codes in an SQL Data Table to State Names (from the IDD Code Table).This should complement the training provided from the session IUAP4 - Session Review - SQL and Web Connectivity for IDMS - Cal Domingue(CA) - Tue, Dec 2nd 2014 at the IUA/CA Technical Workshop today. I hope that you enjoy learning how to perform this "sleight of hand" using SQL, by following the step-by-step instructions!

 

Cheers - Gary

Outcomes