Carlos Guzmán Álvarez wrote:
Hello:
Can you send along your code and connection string so I can try to
debug what's going on here?
I have done nothing special, just open the connection and call
GetSchema("Columns", new string[] { null, null, "table_name" })
Two questions: Any idea how I should go about debugging this? Is there a
connection string setting I should be looking at? I'm still getting
empty strings for default values (xml version of my dataset is
attached). And, once I get it working, is there a function to submit
changes to the schema back to the database or do I need to create ddl
and execute it?
Thanks for your help.
Amanda Kabak
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>USERID</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>0</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>Unique identifier for each user</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>LOGINNAME</COLUMN_NAME>
<COLUMN_DATA_TYPE>varchar</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>50</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>50</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>1</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME>NONE</CHARACTER_SET_NAME>
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>The login name of the user (includes domain if applicable)</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>FIRSTNAME</COLUMN_NAME>
<COLUMN_DATA_TYPE>varchar</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>50</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>50</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>2</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME>NONE</CHARACTER_SET_NAME>
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>User's first name</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>LASTNAME</COLUMN_NAME>
<COLUMN_DATA_TYPE>varchar</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>50</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>50</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>3</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME>NONE</CHARACTER_SET_NAME>
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>User's last name</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>NICKNAME</COLUMN_NAME>
<COLUMN_DATA_TYPE>varchar</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>100</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>100</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>4</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME>NONE</CHARACTER_SET_NAME>
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>User's nickname</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>EMAILADDRESS</COLUMN_NAME>
<COLUMN_DATA_TYPE>varchar</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>250</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>250</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>5</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME>NONE</CHARACTER_SET_NAME>
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>User's email address</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>DATEOFBIRTH</COLUMN_NAME>
<COLUMN_DATA_TYPE>timestamp</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>8</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>6</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>User's date of birth</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>PROMPTONEXIT</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>7</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>Indicates if user wants the application to prompt on exit</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>GENDER</COLUMN_NAME>
<COLUMN_DATA_TYPE>char</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>1</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>1</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>8</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME>NONE</CHARACTER_SET_NAME>
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>CURRENTSCREENID</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>9</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>Indicates if the user is in the middle of a wizard sequence</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>CURRENTTRACKID</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SUB_TYPE>0</COLUMN_SUB_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>10</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>If the user is in the middle of a wizard sequence, indicates the track of that sequence</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>DESKTOPOBJECTIVEID</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>11</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>If the user has selected to freeze the desktop countdown timer, this is the objective to display</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>DESKTOPROTATESPEED</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>12</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION>number of minutes between changes of displayed objectives on countdown timer</DESCRIPTION>
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>STARTTIME</COLUMN_NAME>
<COLUMN_DATA_TYPE>time</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>13</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>ENDTIME</COLUMN_NAME>
<COLUMN_DATA_TYPE>time</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>14</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>MONDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>15</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>TUESDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>16</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>WEDNESDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>17</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>THURSDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>18</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>FRIDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>19</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>SATURDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>20</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>SUNDAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>21</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>IMMEDIATEMIN</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>22</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>IMMEDIATEMAX</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>23</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>SHORTTERMMIN</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>24</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>SHORTTERMMAX</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>25</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>INTERMEDIATETERMMIN</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>26</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>INTERMEDIATETERMMAX</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>27</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>LONGTERMMIN</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>28</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>LONGTERMMAX</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>29</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>LIFETIMEMIN</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>30</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>LIFETIMEMAX</COLUMN_NAME>
<COLUMN_DATA_TYPE>float</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>31</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>PRETARGETDATEDAYS</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>32</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>REMINDERDISPLAYDELAY</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>33</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>REMINDERSNOOZEDURATION</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>34</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>INSPIRATIONMIN</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>35</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>INSPIRATIONMAX</COLUMN_NAME>
<COLUMN_DATA_TYPE>integer</COLUMN_DATA_TYPE>
<COLUMN_SIZE>4</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>36</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>1</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
<Columns>
<TABLE_CATALOG />
<TABLE_SCHEMA />
<TABLE_NAME>USERPREFERENCES</TABLE_NAME>
<COLUMN_NAME>SPELLCHECK</COLUMN_NAME>
<COLUMN_DATA_TYPE>smallint</COLUMN_DATA_TYPE>
<COLUMN_SIZE>2</COLUMN_SIZE>
<NUMERIC_PRECISION>0</NUMERIC_PRECISION>
<NUMERIC_SCALE>0</NUMERIC_SCALE>
<CHARACTER_OCTET_LENGTH>0</CHARACTER_OCTET_LENGTH>
<ORDINAL_POSITION>37</ORDINAL_POSITION>
<DOMAIN_CATALOG />
<DOMAIN_SCHEMA />
<COLUMN_DEFAULT />
<COMPUTED_SOURCE />
<IS_ARRAY>0</IS_ARRAY>
<IS_NULLABLE>0</IS_NULLABLE>
<IS_READONLY>0</IS_READONLY>
<CHARACTER_SET_CATALOG />
<CHARACTER_SET_SCHEMA />
<CHARACTER_SET_NAME />
<COLLATION_CATALOG />
<COLLATION_SCHEMA />
<COLLATION_NAME />
<DESCRIPTION />
</Columns>
</NewDataSet>
