Do query functions using getKey=True support MSSQL uniqueidentifier data type?

Hi All,

It appears that when using the runPrepUpdate() (and the named query equivalents) function and setting getKey to True that MSSQL uniqueidentifier primary key columns are not returned unlike bigint identifiers. With getKey set to true the function returns a 0, with getKey set to false it correctly returns the number of rows affected (1 in this case).
Note we are using Ignition 8.1.35 and MSSQL 2019.
The table structure:

CREATE TABLE [dbo].[machine_image](
	[machine_image_id] [uniqueidentifier] NOT NULL,
	[machine_image] [varbinary](max) NOT NULL,
	[time_stamp] [datetime2](3) NOT NULL,
 CONSTRAINT [PK_machine_image] PRIMARY KEY CLUSTERED 
(
	[machine_image_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

image

Script console test code:

encode = 'iVBORw0KGgoAAAANSUhEUgAAAgAAAAIACAYAAAD0eNT6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEwAACxMBAJqcGAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAACAASURBVHic7N13eJRV2gbweyaTNukkoYRAGgGEhMQAoVcREDDSEQEpIrIrYFsLdtHPRcVFbIgiXRBBBASpgvTeMbRAQpBACAmk15n5/oggJYSZt0/m/l1Xrl1lzjmPk2HO854KEBERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERERUdWhUzsAO+MOoCuAzgCaAGgAwBuAh5pBEVkhH0A2gFMADgPYBGAjgCI1gyIi0rp6AGag/AvUwh/+VJGfawC+BBAGIiK6jS+ArwCUQf0va/7wR66fUgD/A+AFInIYnAK4t3gAP4JPR+Q4UgE8DmCX2oEQkfz0agegUU8A2A52/uRY6gLYDGCg2oEQkfyc1A5Ag4YBmAfAoHYgRCowAOgL4ASARJVjISIZcQrgdp0BrAXgrHYgRCorRvnfh51qB0JE8mAC8I/qAI4AqKl2IEQacQFALIAstQMhIulxCuAf0wG0UTsIIg3xQflOmFVqB0JE0uMIQLmmAPaB7wfRncwAosH1AERVDncBlHsN7PyJKqJH+d8PIqpi2OkB/gDSALioHQiRRhUBqAXgutqBEJF0OAIA9AM7f6LKuAF4VO0giEhaTADKtzoRUeUeUjsAIpIWE4DyBYBEVLk4tQMgImk5+hoAZwAFEHjqX21fd3zc/0E0qeMLnQRvpUs9fzh5KjMb8fHcvZix7Kigsj169MAzzzxzzz/39vaG0WgUGppsioqK0KFDB8Hl980bimo+bhJGpAyz2YKDJ9Px/KebcelqvtBqigAYUX55EBFVAY5+3K03RLwHM4e3QPv61SULxj20GnSuyhzN4OslvCPz9PRE7dq17123ry88PT0F1y+XwsJCUeVDankj0M9domiUVa+OLzyNLuj53DKhVbgB8ACQJ11URKQmR58C8BBaUKcDWtcLlDIW6AyO/usgOXVsGiy2Cu1ldUQkmKP3OILH7XXQwaCXeAbF0SdkZGaxOPbotbNB9OgSP6FEVYijJwBEREQOiQkAERGRA2ICQA7D0acAiIhuxQSAiIjIATEBICIickBMAIiIiBwQEwAiIiIHxASAHAYXARIR/YMJABERkQNiAkBEROSAmAAQERE5ICYAREREDogJADkMLgIkIvoHEwAiIiIHxASAiIjIATEBICIickAGtQMgdTg56QSX3bJlC1JSUu75587OznBychJcv1zKyspElTeIeM+IiLSGCYCD8nR3Flw2PT0d6enpEkajfTod4Gl0UTsMIiLJcArAQdWt6a12CHYlKNATzgb+dSGiqoPfaA7qwQbV1Q7BrvD9IqKqhgmAg2oU7o/Iun5qh2E3EtpHqB0CEZGkmAA4MHZq1tHrdejVju8VEVUtTAAc2MiEKDjpubL9fnq1DUetAA+1wyAikhQTAAfWONwfw3s1VjsMTXPS6/DhuHZqh0FEJDkmAA7uvbGt4WkUviWwqhvdOxqNw/3VDoOISHJMABxccHUvzJ/UA3pOBdwltn51fPpCR7XDICKSBRMAQu+O9fD+2DZqh6EpNf09sHJqb3iIODCJiEjLmAAQAOD1US3w2UuduCgQQGRdP2yeMRB1anipHQoRkWyYANBNzw2Ow8qpfeDn7aZ2KKrp1S4c++YNQcPQamqHQkQkKyYAdJsebcJwdvlTeHV4PNxcHOeqiAfCquGnyY/i16l94OPpqnY4RESyc5xveLKan7cbJo9vh3GDYvHjulNYsSUJu46mwWS2qB2apAL93NGrXQR6d6yHnm3DOf1BRA6FCQDdU3B1L/xnWDP8Z1gzXMspwp/nMpGWkYfrucVqhyaYq4sTfL1cEVnHDw1Cq7HTJyKHxQSArOLn7Ya2sbXVDoOIiCTCNQBEREQOiAkAERGRA2ICQERE5ICYABARETkgJgBEREQOiAkAERGRA2ICQERE5ICYABARETkgJgBEREQOiAkAERGRA2ICQERE5ICYABARETkgJgBEREQOiAkAERGRA+J1wETkKGoBaPD3TxAADwBeAHwB6FSMixxXCYA8ANf//t9zAE7//ZMjd+NMAIioqgoC8AiAzn//1FQ3HCKrWQD8CWDT3z/rARRK3QgTACKqStwA9APwJICHADipGw6RIDoAUX//TED5aMBSAHMBbJWqEa4BIKKqwBPAcwCSACwA0BXs/Knq8AYwCsAWAIdRnuCK/nwzASAie6YHMBZACoDPANRWNRoi+cWgfCRgH4BWYipiAkBE9ioWwC4A0wH4qxwLkdIeBLADwEwAfkIqYAJARPZoDIDdAOLVDoRIRToATwE4AqC1rYWZABCRPfEA8DOAGQBcVY6FSCvqAPgD5QsGrcYEgIjshR+AdQD6qh0IkQY5A5j2949VfTsTACKyB7UAbAfQRu1AiDRuAoBZsKJ/ZwJARFrnDWA1gEZqB0JkJ4YD+Op+L2ICQERa5gZgFcpXPBOR9cYCeLOyFzABICIt+wxAO7WDILJTkwA8dq8/ZAJARFo1EMAzagdBZMd0AGYDCKnoD5kAEJEWBQP4Tu0giKoAP5QnAXfdeMnLgIhIi6aifPGf5Pz9/dGgQQPUrVsXnp6ecHd3F1yXk5MTPDw8oNPxNmESJjs7G1lZWUhKSsLRo0dRWCj5pX8A0AnAEJTfk3ETEwAi0ppuAPpLWWFgYCASEhLQtWtXRERESFKnwWBA9erVoddzIJWkUVpail27dmHp0qVYsWIFiouLpaz+EwC/Asi+8S8cPW0NQfklIjbT63TI/XKApMEYmwcDekf/lZBcSsvMcGk5VUwVQQAuSRROZQ4AiJOiIl9fX4wdOxYJCQlwcXGRokoAgE6nQ/Xq1eHs7CxZnUS3Sk9Px2effYZ58+bBZDJJVe07KF8YCIBrAIhIWx6BRJ1/69at8fPPP6N///6Sdv4A4OPjw86fZFWjRg3897//xerVqxEWFiZVtc8B8LrxD0wAiEhLXpOikieeeAKfffYZfHx8pKjuNi4uLvD09JS8XqKKxMbGYv369Wjfvr0U1VXDLTtrmAAQkVZEQoI9/xMmTMCLL74o29y8r6+vLPUS3YuXlxd++OEHPPTQQ1JUN+rG/2ECQERaMQwi1yUlJCTgySeflCicu7m7u0s+nUBkDWdnZ8ycORPR0dFiq3oAQHOACQARaccQMYWbNGmCiRMnShVLhby8vO7/IiKZuLu747vvvpNiCuoJgAkAEWlDBIBwoYWdnZ3x1ltvybowz2Aw8OmfVBcaGoqXX35ZbDUPA0wAiEgbOokp3KdPHylXSlfIw8ND1vqJrDVq1CjUrVtXTBWNANRkAkBEWtBBaEG9Xo+hQ4dKGUuF3NzcZG+DyBrOzs7417/+JaYKHYD2TACISAsaCy3YvHlzBAUFSRnLXfR6Pff9k6b07dtX7JRUI0dPAASfs+hqcPS3jkgyOpRvARSkQwfBgwdW49w/aY2Pjw9at24tpoqGjt6LZQAoFVIwyFf4BSJEdJsgAIKXNTdt2lTCUCrGp3/SIpEJQKSjJwAmANuFFGxfv7rEoRA5rGpCCzo5OYldDGUVg4H3ppH21K9fX0zxao6eAADALCGFhrWSd8UxkQMR/PTv7++vyNM5r/slLQoODhZT3JsJALAQwE5bCgxqHoIWYf4yhUPkcASfrqPU1jwmAKRFIg+m8mICAJhRfvd4kjUvjg/zxxdPyD/nSORABD/CKzU0zwSAtEjk6JczE4BylwC0ALAEgKWiFxj0OjzToR7WPNcRHi6cDyQiIvvGnuwfWQAGAoj9+39jouv4dazj625sHuqPfk3rICKQV4ASEVHVwATgbof//sG+yQmHTNcLY1WOh4iISHJMAIiIJFBWVobLly8jOzsbJpNJ7XBIBm5ubvD19UX16lVjGzgTACIigQ4ePIiVK1di+/btOHXqFEpLBZ0rRnbGy8sLDz74IDp27Ig+ffqgVq1aaockCBMAIiIbrVq1CtOmTcOxY8fUDoVUkJubi61bt2Lr1q344IMP0KtXL/znP/8RezCP4rgLgIjISunp6Rg4cCBGjx7Nzp8AAGazGStXrsRDDz2EyZMn29X0DxMAIiIrHD9+HD169MDWrVvVDoU0qLS0FJ999hmGDh2K7OxstcOxChMAIqL72Lp1Kx599FFcvHhR7VBI4zZv3oxevXohMzNT7VDuiwkAEVElUlJSMG7cOBQWFqodCtmJM2fOYOTIkSgpKVE7lEoxASAiuofc3Fy88MILyMnJUTsUsjN79+7Fm2++qXYYlWICQER0DzNnzsSFCxfUDoPs1Lx587B37161w7gnJgBERBW4dOkSlixZonYYZOfee+89WCwVXjGjOiYAREQVmDlzpubncEn7Dhw4gM2bN6sdRoWYABAR3aGgoAAbNmxQOwyqIhYtWqR2CBViAkBEdIf9+/ejoKBA7TCoiti8ebMmj4lmAkBEdIfDhw+rHQJVIXl5eTh+/LjaYdyFCQAR0R2Sk5PVDoGqmDNnzqgdwl14GRAR0R2uXr0quKxOp4fB1dO2Mk46QCe4SVKAxWJBab7w8yAuX74sYTTSYAJARHQHMaf+xfV5H3Wie9hUxlDfBzp/N8FtkjJ2ffA0/tq+WlDZ/Px8iaMRj1MA9+Z3Mi3bJbdIews3iEheZrNZcFk3zwCby1h0fPy3B25+1QWXFfOZkgtHAG4XAOBlAAMBhMa+vBwAEFnDC4OahWBc50h4uTmrGR8REZEkOALwj+4ATgN4BUDorX9wJj0XH6w+jthJa7AnWfs3PBEREd0PE4ByDwP4FYBfZS+6nF2EntP+wIHzWcpERUREJBMmAIAvgEWwcjqksNSEJ7/fheIy7c3nEBERWYsJAPAcAH9bCqRk5mPeLu4TJiIi+8UEAOgvpNCyg7wilIiI7JejJwDOABoJKXj84nWJQyEiIlKOoycA1SDwPbhWUAKTWZt3PBMREd2PoycATkILWiwAu38iIrJXjp4AEBEROSQmAERERA6ICQAREZEDYgJARETkgJgAEBEROSAmACLwAk8iIrJXjp4AsA8nIiKH5OgJABERkUNiAkBEROSAmAAQERE5ICYAREREDogJABERkQNiAkBEROSAmACIoOMmQiIislOOngCwCyciIofk6AkAERGRQ2ICQERE5ICYABARETkgJgBEREQOiAkAERGRA2ICQERE5ICYAIig4y5CIiKyU46eALAHJyIih+ToCQAREZFDYgJARETkgJgAEBEROSAmAERERA6ICQAREZEDYgIgAq8DJiIie+XoCQC7cCIickiOngAQERE5JCYAREREDogJABERkQNiAkBEROSAmAAQERE5ICYAREREDogJABERkQNy9ARA8DkAPASIiIjsmaMnAERERA6JCQAREZEDYgJARETkgJgAEBEROSAmAERERA7IoHYA9mzZwQuS1ueaU8DtBSQbk9kstopHAVyTIJQ7xclQJxHdhyMkAK4AogA0ANAIQH0AwQDqAKgptFKLBRj2/S5JAiSyEzPUDkAper3wwdHSolyby+gsFsHtkXJK8rMFl9Vp8OGuKiYAwQA6A2gFIB5ANABnVSMiIrvi7u4uuOyBX97C6W3f21RG5+oEOGtjRlbv7AJjQBBqxLVHcPtH4Wz0kr3N4uxMXNiyEleO7EBRVjrMZaWyt2krc1kpslNOCi7v4eEhYTTSqAoJgCuAjgASAHRB+RM+EZFg1apVE1zWVFqI65dOSBiN8jIBXNi6EsdmfYiYMe8gpMsA2do6vexb/Dl/CsoK82RrQwtq1Kihdgh3sdcEwBlANwBDAPQA4K1uOERUlYSGhmLHjh1qh6G64pws7J3yHPIup6Lx0Jckr//A56/g3G8LJK9Xi+rVq6d2CHfRxpiT9R4AMA3ARQC/Angc7PyJSGIxMTFqh6ApiQs+xV/bV0taZ9KKWQ7T+bu7u6NJkyZqh3EXe0gA9AD6AtgE4E8AEwAEqhoREVVp8fHxcHV1VTsMTTn63STJ5uZL8rJxfP7HktRlDzp06AAXFxe1w7iLlhMAZwBPAjgO4GcAnSDi8h4iImt5enqic+fOaoehKfnpF3Dl0DZJ6rq44zeU5uVIUpc9GDhwoNohVEiLCYAOwCAApwDMRfmwPxGRokaPHg0nJye1w9CUjGPSbH3OOLZbknrsQXR0NLp37652GBXS2iLAeACfAmirdiBE5NhCQkLQp08fLF26VO1QNMMl9woaeIkfiD2QfUWCaOzD22+/LepcCTlpJQGoA+D/AAwFh/mJSCPGjBmDrVu34soVx+mwKhNXwwPjIsR/RR8M9MA5CeLRut69e6Ndu3Zqh3FPaqclTgDeAHAGwDCw8yciDalWrRqmTJkCNzc3tUPRhMjISEnqiYiIkKQeLYuOjsbUqVPVDqNSaiYAYQA2A/gA5Yf5EBFpTqNGjTBlyhQYDFoZMFWHk5MTunXrJkldjzzyiCT1aFVQUBDmzJkj6kRJJaiVADwJ4CgA7Y6NEBH9rVevXli6dCn8/f3VDkU1AwYMQHBwsCR1xcXFoWPHjpLUpTVNmzbFmjVrULt2bbVDuS+lE4CaAH5D+ep+T4XbJiISrGXLlli1ahXi4hzv8sLQ0FC8++67ktY5ZcoUBAQESFqnmpycnDBixAj88ssvmjz2tyJKjmnFAViB8st6NMfFxQVubm7w8vKC0Wi0abjPyclJs6s8ibQuNzcXycnJaodhlbCwMKxevRqrVq3Chx9+aDdxi9GoUSPMnTsXvr6+ktYbHByMJUuWYPjw4UhNTZW0bqU99NBDeOutt9CwYUO1Q7GJUovu+qH8qV+165BcXFwQGhqKkJAQ1K1b9+b/r1WrFry9vW3e76vX6+Hl5QVPT09NXvNIZC82btyIoUOHCiobGRmJRYsWSRzR3QICAu5aCFhaWorNmzdj5cqV2LZtG9LT02WPQ0l16tTByJEj8dRTT8l6KmJubi6mT5+OH374wW7eQ51Oh4YNG6JTp07o27cvoqKiVIkjLS1N1IiUEj3XcwD+B4WnG/R6PRo0aID4+HjExMSgWbNmMBqNktTt5uYGPz8/HhJCJAF7TQDudPXqVaSkpCAvLw+5ubmyxyQXX19fBAUFKb5S32w24+zZs7h48aIm378bD30BAQEIDQ2VrD8RQ2wCIOcUgCuAmSjf268IFxcXdOjQAY888oikHf4NTk5O8PX11fzKTiJSXkBAQJWa01aaXq9HZGSkZFsN6f7kSgBcACwF0Eum+m/zwAMPoEePHnjkkUckn6e6wWg0wtfXl3P9RERUJciRALgCWAaghwx132QwGPDII49g+PDhCA0Nla0dnU4HX19feHiotnyBiIhIclInAC4AfoKMnb+zszMefvhhjB49GnXr1pWrmZttVatWDc7OzrK2Q0REpDQpEwAXAEsAJEhY5016vR59+vTBU089herVq8vRxG3c3d3h5+fHIX8iIqqSpEoA9AB+gEydf8OGDTFx4kQ0btxYjurv4unpKdtaAiIiIi2QKgH4AEB/ieq6yd3dHaNHj8awYcMUexL39vaGt7e3Im0RERGpRYoEYDCA1ySo5zbNmjXDpEmTFBnuB7jYj4iIHIvYBKA5gO8h4YFCer0eI0aMwNixYxV76s/MzERBQQHOnj2L7Oxs5OfnIy8vD0VFRYq0T+TIzpw5o3YIRA5JTAIQBOAXAJKdiuPr64tJkyahdevWUlV5G5PJhBMnTuDgwYM4efIkUlNTkZqaioKCAlnaIyIi0iqhCYAzyvf6S3bfYf369TF16lTJb1HKyMjAhg0bsHPnThw9epSdPREREYQnAJMAtJAqiAcffBBTp06Fp6c0NwTn5eVh/fr1WLduHQ4dOgSz2SxJvURERFWFkASgPYCXpQqgTZs2+Oijj+570YY1MjMz8fPPP2PRokWavEyCiIhIK2xNADwBzAMgyTV43bp1w3vvvQeDQdxaxLS0NHzzzTdYv349ysrKpAiNiIioSrO15/0/ACFSNNylSxe8//77olb65+fnY/bs2Vi4cCFKSkqkCIuISBFlZWXIz8+XvZ0b19jaK5PJhLy8PNnb0el0DncGjC0JQEsA46RoNC4uDpMmTRLV+f/222/47LPPkJWVJUVIRESyuXbtGjZu3IgdO3YgMTERZ8+eVaTzv1VQUBAiIiIQHx+Pdu3aIT4+XnNHnWdnZ2PTpk3YsWMHjh07hnPnzik+nVurVi2Eh4ejWbNmaNeuHVq1agUnJ0kGvTXH2v37OgDbAYjenxceHo6ZM2cKzrRyc3Px8ccfY82aNWJDISI7FxkZiUWLFsneTkBAgKB1Snv37sU333yDDRs2oLS0VIbIhKtduzaeeOIJPPXUU6offX748GFMnz4da9euRXFxsaqx3KlmzZoYNGgQnn76aQQEBKgdzm3S0tIQFxcnuLy1CcAgAD8KbuVv1atXx6xZs1CzZk1B5Xfv3o333nsPGRkZYkMhoipAqwlAUlIS3njjDWzZskXGqKTh6emJ559/Hs8884ziN5+eP38eb731FtavX69ou0K4u7vj2Wefxfjx4+Hq6qp2OADEJwDWjP+4Aviv4Bb+ZjAY8PHHHwvu/OfPn48JEyaw8ycizbJYLJg+fTo6depkF50/UL5t+oMPPkC3bt2QlJSkWLtz585Fhw4d7KLzB4DCwkJMmTIFnTt3xp9//ql2OJKwJgEYDyBMbEP/+te/EBUVZXM5k8mEjz76CNOmTeN+fiLSrOLiYjz99NN47733NDfcb43ExER069YNGzZskLWd0tJSTJgwAa+++qpdHrd+9uxZ9OjRAytXrlQ7FNHulwBUA/C62Ebi4+MxbNgwm8sVFhZi3LhxWLJkidgQiIhkU1RUhCFDhmDVqlVqhyJKfn4+Ro4ciV9++UWW+ktLSzFq1Cj89NNPstSvlOLiYowdOxYLFixQOxRR7pcAvArAT0wDfn5+eO+992xebVpUVITnn38e+/btE9M8EZGsTCYTxowZg+3bt6sdiiTKysowYcIEbN68WdJ6LRYLJkyYIPsIg1LMZjNeffVVrF69Wu1QBKusV/YEMEZsA6+//joCAwNtKlNUVIQXXngBBw4cENs8EZGspkyZYjfz2NYqLS3F2LFjkZqaKlmd06dPl21kQS0mkwnjx4+32xstKzsHYDgAUXtDWrdujU6dOtlUxmw245VXXlH8yV+n08FoNMLFxQXOzs42r4bV6/Xw8PCosvtFieSSm5sraUejpL1792LatGlqhyGL7OxsjB8/HsuXL4dOJ+7G9z///BP//a/oteSaVFBQgH//+99Ys2aN6FNtlXavaPUAJoip2NnZGS+99JLN5T777DPs3LlTTNNW8fDwQGBgIAICAuDn5wcPDw/Bh2J4enqibt26dvfLJ9KC06dPY+HChWqHYTOTyYTXXnutSi9O3rNnD3766ScMGjRIcB0WiwWvvfaaXS6MtNaxY8cwZ84cjB49Wu1QbHKvHqsHgPpiKh48eDBCQmw7NXj58uWyfhG4ubmhbt26qFOnDnx8fCSp09fXF3Xq1BGdIRORfVm+fDkSExPVDkN2H330Efr27Sv4jICNGzc6xFqu//3vfxg8eDA8PDzUDsVq93rkfU5MpYGBgTZnQsePH8dHH30kptl78vLyQlxcHLp3746oqCjJOn8/Pz92/kQO6quvvlI7BEWkpaWJmrv/8ssvJYxGu7Kysuxud0NFCcADAB4SU+nIkSNhNBqtfn1RURHefvttyYeIXF1dERcXhy5duiA0NFTSc6/9/f0RHBzMzp/IAR05csQhnv5vENqxnTt3Dnv37pU4Gu368UfRB+YqqqIpgGGw/ojgu/j6+iIhIcGmMl988YXki4DCwsIQFRUly9GW3t7eqF27tuT1EpF9+PXXX9UOQVE7d+5EZmYm/P39bSr366+/wmKxyBSV9hw5cgSpqamoW7eu2qFY5c5HYj2AJ8RUOHDgQJvOzN63b5+kwyaurq5o1aoVHnzwQVk6f6PRaDe/XCKSx7Zt29QOQVFmsxk7duywuVxVORvBFvb02bhzBKANANtW7t3C3d0dAwcOtPr1JpMJn3zyiWQZore3N1q3bm3T9IMtnJ2dJZ9KIKpIWVkZCgsLUVpaCrPZDBcXF7i7uyt+WQvdrbS0VPTwv3+TIESNbQXvMH846XXo2agmDHp5phNLCkuxb1UiFr69BgU5wo/ePXz4sM2ju0ePHhXcHgA84FYN46vHItLV9+aw9APx3jC4Sv8dXGwyYW1qKl7ftQtXRRxRfPjwYQwZMkTCyORzZwLQW0xlCQkJNl0ruWLFCpw7d05MkzfVqFEDLVq0kHUrXnBwsOD6r1y5gr/++guZmZm4fv06CgsLUVJScvPcAS8vLwQEBKBmzZqi2rEHFosF6enpSE5OxuXLl5GZmYnc3FyUlJSgtLQUzs7OcHd3h4+Pz821FmFhYZIt3tSitLQ0JCcn4/z588jIyMD169crTIy9vb0REBCAunXrIjw8nItQVZCamipqvVLN1qFoNbkXdH93+EHebvCpJs9DCwB4+Lqj69Mt0ahdGF5r+wVKCoXFbutFQRkZGcjOzhbUFgDEGavjyzqd4HTL59vNwwmB3u6C67yfEQ0bomNQEJotWYKckhJBdSh5oZJYd/Yyj4qprG/fvla/tqCgADNmzBDT3E3Vq1dHy5YtZT2EJyAgAF5eXla/3mKx4MKFCzhy5AhOnTqFvLw8q8saDAaEhoaiSZMmaNiwIVxcXISErDkZGRk4dOgQjh07htzc3Hu+7sbTb1ZWFpKTk7F//34A5UlebGwsmjRpYldbbe6loKAA+/fvx5EjR5CZmWlVmZycHOTkxIF3DQAAIABJREFU5ODcuXP4448/4O3tjSZNmqB58+ZVOkHSEjE3kur0OsS90vlm5w8Anq7KJPvBDWug57Nt8csUYUf82vrfLep9AvB6zea3df4A4Oou/+hrqLc3XomLw5u7dwsqb0831t76yXsAQKTQiiIjIxEREWH16xcuXGj1l15lAgIC0KpVK1k7f1dXV6uvMTabzUhMTMS2bduQnp4uqL2ysjIkJSUhKSkJ7u7uiI+PR8uWLeHuLl/mK6e0tDRs2bIFp06dElVPeno61q1bh02bNqFp06Zo27YtPD09JYpSOUVFRdi2bRv27duHEoFPGTfk5ORg+/bt2LVrF2JiYtCpUyebElWyXUFBgeCyHrV94BZwe/Lq5qzc6aH1Wwqe4bXpIQYov1hIqGoGN9RxuftzbHBRZvq1tcBr6wFx/91KuzUBeFhMRd27d7f6tSUlJZLc8Gc0GtGiRQvZj9+tVauWVfP+ly5dwurVq/HXX39J1nZhYSG2bNmCPXv2oGPHjoiPj7ebNQiFhYX4/fffceDAAUlXApeWlmL37t04fPgwOnXqhObNm9vNe3L8+HGsXbvW5i/T+zGZTDh48CD+/PNPdO7cGfHx8ZwakImY6bmy/LsTvjKTcicJFmQLn9u2df2JmPUqheYymGGB/o4NaWazMjsKsouLBZe1p+nbWyPtLLQSnU6Hrl27Wv36devWiX76NxgMaN26NVxdXUXVcz9Go/G+T1RmsxmbN2/G9u3bZdvyUlRUhLVr1+LkyZPo27cvvL29ZWlHKmlpaViyZAmuXbsmWxtFRUVYs2YNTpw4gX79+mn6ybesrAwbNmzAnj17ZG2nuLgYa9aswalTp9C3b1+7HCHROjHvaVFWAS7vTEHN1qH//LtSZRIAi8WCzfOEn8hn698vMe9TgbkMG3JS0c379hGLsmJl3qvZJ08KLqv17+Zb3XhscgLQQWglMTExqFWrltWvl+K436ioKEXe6KCgoEqfpAoLCzFv3jxs27ZNkf2uKSkpmDFjhqYvTzl8+DC+//57WTv/W6WkpODbb7/F5cuXFWnPVoWFhZg7d67snf+tzp07h++//16SaTa6XZ06dUSVP/jRJmQnXb35z9cKxU0DWcNituCn9zfg+JazguuwdftzcHCwqJG5T9MP4s+i2z+/hflmyPk1awEw5dAhrExOFlyH2M+Hkm6MADSCiJv/OnSwPndITEwUfXVijRo1EB4eLqoOa3h5eVW6pTA3Nxfz58/HlStXZI/lVvn5+Zg/fz4GDBiA+vVFXdkgud27d2Pt2rWKt5ubm4s5c+YIuoNCTnl5eZgzZw6uXr16/xdL7Nq1a5g9ezaGDx9u85XcdG+BgYHw9fXF9evXBZUvyszH5qd/Qt1uDeBTLwB6FyeU1fKBq0GeaazczHzsXfknzh4UNzUZGWnbEjE3NzcEBwcLfljJNhXj6fMb0c07BA3dqsFVVz7Vu/WgmyyLAa8VF+PX5GTsFrh26wZb3yc13UgA4sVU0rRpU6tfu27dOjFNQa/XIyYmRlQd1qrs1KuioiIsWLBA8c7/htLSUixevBiDBw9GvXr1VInhTkeOHFGl87+hqKgICxcuxIgRI2wakZJLcXExfvjhB1U6/xvy8vIwf/58jBo1yqYtulS5li1bivqsm0tNSFn1z1kCh6QISmYtW7YUVEbMaKXJYsFv2Sn4LTvln3+pzYG+m1q1aqV2CFa7kUY1F1qB0WhEgwYNrHqtxWLBpk2bhDYFAIiIiFBkXtPFxeWec14mkwk//PCD4FX+UjGZTFiyZIlqScitzp07hxUrVqgdBoqLi7Fw4ULJF9nZymKx4Oeff8alS5dUjQMo3ymwePFilJWVqR1KldGxY0e1Q1CUj48PHnzwQZvLOdr75O7uLihRUsuNBMD23+zfYmNjrV6Ff+zYMVFfiAaDwepkQyx/f/97zv1v2LABFy5cUCSO+ykuLsbixYtRLGLVqlh5eXlYtmyZZu5Fz83Nxc8//6xqPLt27cLp06dVa/9Oly5dEj36Rv/o3bt3lTmfwxqPPfaYoFX93bt3d6iFqN27d5ftJFo56FF+5kJDoRXExcVZ/dpdu3YJbQZA+SIUpf7S3etQleTkZOwWeECEXDIzM7Fx40bV2l+9erXqT9x3uvUAIaVlZWWJHumSw759+5CSkqJ2GFWCr68vHn1U1LlpdkOn02HYsGGCyhqNRvTv31/iiLRr+PDhaodgEz2AYACCl9PHxsZa/drDhw8LbQYAFJvrdnV1rTDRMJlM+O233xSJwVb79+/HxYsXFW/3zJkzOHHihOLtWmPTpk2qJCZr167V7HD7mjVrNDNSY++ee+45uzl/QowuXbogOjpacPlx48Y5xB0WLVu2tKvhf6A8ARD89A+UX7trjbKyMhw/flxwO/7+/ooNJd1re+HBgwc1e8yjxWJRZRRg82Zhx4oqoaioSNANZmJcvHhRU0P/d0pPT3eoe+zlVL9+fTz55JNqhyErZ2dnvP3226LqCA4OxjPPPCNRRNqk1+vxzjvvqB2GzfQAQoUW9vb2tvr88ZMnT6KwsFBoUwgODhZc1lYVLf4zmUyKdya2Sk5OVvR8gDNnziAtLU2x9oQ4cOCAqKNbbWUPV4E64hWtcpk4cSKCgoLUDkM2zz33nCTb2l588UVFtm6rZcyYMYIWSapND0DwqQW2HAwhdu+/kn/JKjpz/9SpU4L3/Spp3z7hJ33ZSq05dluUlJTgyJEjirSVl5cn+dO/wWCQfPj08uXLmk/c7IWPjw+++eabKjnE3bZtW7zwwguS1GU0GvHtt9/Czc1Nkvq0JC4uDm+88YbaYQhiAGDb8U63sCUBELNq3sPDQ7GLcFxcXCrc1SBVJ+Lm5nbzrPbq1asjJycHp06dwtq1ayXZMnby5EkUFxfLfkRyQUGBZNdeduzYEY8++igaNGgAPz8/XLlyBfv27cPSpUsl6VCPHj2qyN7c48ePSzK/Hh4ejqeffhoPPfTQzdPU0tPTsWXLFnz//feSfBaPHj1apZ9clRQfH4/PP/8czz77bJVZX1G/fn3MnDlT0ntWoqKi8O2332LUqFGaXSNjq5CQEMyZM8duE0ADgOpCC9ty5KGYBCAgIEBwWVtVlKGWlpZK0tkNHDgQb7zxBmrUqHHXn02aNAkLFizA+++/L2rIurS0FGfOnEFUVJSYUO8rKSkJJpNJVB21a9fGV199ddfCmYiICLRq1QrPPvssfvjhB7z11luitjleunQJOTk5sh8dLfYzotPpMG7cOLzyyit3faHUqFEDAwcOxIABAzB79my88847ou6kP3PmjE0XeFHl+vTpg8LCQrz88sui/16o7YEHHsCiRYtkOTiqa9eu+OqrrzBu3DhRn18tCA8Px+LFi1G9uuAuVHV6ANWEFq6oI7sXMQmAkpcrVPTknJqaKvov9bvvvovPP//8nu+Zs7MzRo4ciZUrV8LPz09UW8kizrFWqo2wsDCsXbu20lWzTk5OePLJJ7F48WLRIxpyvycmk0n0+ovXX38db7zxRqVPEzqdDqNGjcJXX30l6ra/zMxM5OTkCC5Pd3viiScwZ84cq9dFaVHnzp2xfPlyq68/F+Kxxx7DokWLFH2wk1rr1q3x66+/2tW5/xURlQB4eHjc/0V/E7N6XsmDJCra/if20J8RI0Zg7NixVr02KioK3333nagvdyUOKRIzh+zs7Iw5c+ZYfT59y5Yt8f777wtuD4DsWyQzMzNRUiL8UpfOnTtj/PjxVr8+ISFB9J5jrV6eZM8efvhhbNy4EW3btlU7FJsYjUa88847+OGHHxRJYNq2bYuNGzeiS5cusrclJVdXV7z66qtYsmRJpUfF2ws9RFwCZMu8vJgdALYkGmJVtK9XzFnuvr6+mDhxok1l2rZtK+qQkaysLFnnIi0Wi6hb5gYPHmzziY5DhgwRdfGR3Ofxi71177XXXrO5zEsvvSRq7pE3BcqjTp06WLp0Kb799lvNXdZ1J4PBgIEDB2Lbtm3417/+JerBw1Y1a9bEggULMHfuXNmnLMVycnJC7969sWXLFrzwwguSro1Qkx6A4GWZ1h55aDKZRD0dKXnkZkUJQFZWluD6evfuLSijFnryFlB+5oKcw7t5eXmiFvEIORnMyckJffv2Fdym3Ds4xLzfoaGhaNKkic3lAgMDRS1u5BSAvBISEvDHH39gwYIFSEhIUPRB5n4iIiLwn//8B7t27cLnn3+O2rVrqxZLt27dsGHDBixevBj9+vW75x0saggJCcFzzz2Hbdu24ZtvvkFoaKjaIUnKAEDwI4S1CYDYfdgGg+H+L5JIRZldUVGR4PqEDgW2bNkSBoNBcEcrJub7EbMgT6/XC94v26xZM8Htyn1Xgpj6GzduLKrs1q1bBZVV8/4IR6HX69GlSxd06dIFpaWlOHjwIE6cOIGzZ88iKytL1IORLTw9PREUFIR69eqhefPmip6rYg2dTocOHTqgQ4cOKCsrw5EjR3D8+PGb75NSn1UPDw/UrFkTkZGRaNq0aZXr8O8kKgGwdgpA7GpPJY/brGgITMxfUqGLaZydnREYGCh4a6Ccf2HE/D69vb0FD1uLWTQk9xetmEWiYp54xCyQrSpbseyFs7MzWrRogRYtWqgdiqYZDAY0bdrUpmvmSRhRPau180ViD39QcltNRXPnYhIQMU/iYkZO5JyjEjMik5ubK/j3KWYYX+59umLqF7M+QcziWke6zY6I7qYHIPhxztoOyt3dXVQnquSTSkUJgJgtaEL3hmdkZCA7O1twu3J+uYt5P0wmE06ePCmorJi7JOQ+GElM/QcOHBD8GRdz8qPc7wkRaZsegOCxUWsTAJ1OJ+okP6XmyYCKRxvEbENcu3atouVukHPrpIeHh6gRhhUrVihaDpD/LAkxh6Zcu3YNGzZssLlcYmKiqKRIjoNeiMh+6AEIHqO2ZYhazApYJa90rehJTMx+zy1btuDAgQM2lSktLcVXX30luE2j0Wj1Ak0hnJycRB1WNGvWLKSnp9tUZv369aKeduU+dERs/R9++KFNW2XNZjPefvttWCwWwW3a80EsRCSeHsA1oYVtSQDEfNkomQBUNGcv5qhHi8WCCRMm2DSc//bbbyMlJUVwm7ac0ChUrVq1BJfNy8vDmDFjrB7ZSU1NFX0piZh4reHr6ysqyT1z5gzGjx9v1QJLi8WCSZMmibrVT6/Xy/6eEJG26QEIPg3Elo5ZzHYKMXPhtqqoUxK7FeTs2bPo37//fVf0l5WV4e2338bs2bNFtafE1hWxbezZswf9+vW773uyZ88ePProo6IPrQkLCxNV/n50Op3o92TVqlUYNGhQpclfRkYGnnnmGXzzzTei2goKCqqSN7MRkfUMAASfcmPLcbBivhzlPsXtVhVtnwsMDIS3t7eog1OOHTuGDh064N///jcGDRp029NXYWEhNm7ciE8//VTwArlbRUREiK7jfurVqwedTidqCHrfvn1o06YNhg8fjsceewwPPPAAXF1dkZOTg71792Lx4sVYtWqVqDYAoFq1aooc29mgQQP8+eefourYuXMn2rVrhx49eqBLly4ICQmBk5MT0tLS8Mcff2D58uXIz88XHavWT6gjIvkZAAg+JN2WYWpbrg6+U1FRkSK3uQHliwALCwtvW7So0+kQHR2NHTt2iKo7JycHkydPxkcffYS6devevA74/Pnzkh3c4+fnp8ipXj4+PggJCRE1VQGUTyNNnz4d06dPB1C+Ml3qMwyEnLInxI0ERmz8paWlWLFihahFj/cTHR0tW91EZB/0AARfYXb+/HmrX1uvXj2hzQBQ9uKSiqY2YmNjJavfYrHg/Pnz2LdvH06dOiXpqX2xsbGKnecdFxcneZ1Sd/56vV7S311lnJ2dERMTo0hbYkRGRoq+cZKI7J8BgPW9+B0uXLgAs9ls1R7/kJAQ+Pv7C57LTU1NVWzYMj8//66b6gIDA9GgQQOcOnVKkRiEcHFxQfPmzRVrLyoqCn/88YeouxLkFh0dreh2tzZt2uDAgQOavhO+Xbt2aofgcC5fvoytW7di7969SEpKwsWLFxW7i8FgMMDPzw+hoaFo3LgxWrVqhVatWmn2HAiz2YxDhw5hx44dOHr0KM6dO4fMzExZjze/ldFoRI0aNVCvXj3ExcWhXbt2iIyMVKRtpRkAnBVauKSkBJcuXbJqyFmn06FZs2ZYt26doLZycnJw/fp1Rb7M8/LyKkxs2rdvj9OnT4uek5ZLixYtZN3+dye9Xo/27dtj+fLlirVpCycnJ7Rv317RNn18fNC8eXPs3r1b0Xat1bBhQ1HTcWQ9s9mMVatWYd68edi5c6esN3TeT2ZmJpKSkrBx40ZMmzYNPj4+SEhIwOjRo22+mVMuGRkZmDVrFhYvXizqunGxsrOzcenSJRw+fBhLly4FADRq1AhDhgzB4MGDFf2OlZseQCIAwT2aLYvWxFzmApSvpleC2WyucOdB7dq1BV9kIzdvb29VnuxiYmI0e2FG69atVbmzu1OnTpq60ewGZ2dndOvWTe0wHMLGjRvRrl07jBkzBtu3b1e1869IdnY25s+fj06dOmHMmDGqdrj5+fmYNGkSmjdvjqlTp6oay70kJibijTfeQPPmzTF79mxNj/DZQg8gByLWAdhyOEt8fLzQZgCUTzmIvVnQWvc6d75Lly6a/HLv2bOnKme763Q61dquTPXq1RV/+r/B1dUVCQkJit6tbo1u3bpx7l9m2dnZGDNmDIYOHarYA4sYZrMZK1euRNu2bTFv3jzF29+xYwfatm2Lr7/+WrEhfjEyMzMxceJE9OzZE8nJyWqHI9qNMe5jQivYv3+/1a+tXbs2GjVqJLQpmM1mxebgc3NzKzyUxWg0ol+/foreUHg/LVu2VHUYLzAwED169FCt/Tu5uLhgwIABsl8AVJnIyEjBV0HLITo6WvQIHFUuKSkJXbt2xcqVK9UOxWYFBQV45ZVXrD6MSgpff/01Bg4cKPjGUzUdPnwYXbt2xaZNm9QORZQbvdheoRWkpKTgypUrVr++Z8+eQpu62Z5Si87uddNaaGioZoZSw8PD8fDDD6sdBmJjY9GmTRu1w4Ber0efPn3uWsSphs6dOyu2A6EyoaGheOyxx9QOo0o7duwYEhISbNoZpUVLlizBsGHDZH8anzRpEiZNmmTXQ+m5ubkYPnw4fvnlF7VDEexGAiBqxZItowDdu3cX9WRmsVhw+PBhRRbiZWZm3jMbbtGihWpDzDcEBQVh0KBBsl79a4suXbqoeoe3Xq+/eaCQFuh0Ojz66KOqxlOnTh08/vjjoq5wpsqdO3cOgwcP1vRuGFv88ccfGDt2rGyd89SpU/H111/LUrfSSktLMWHCBPz+++9qhyLIrSMAgn/btqx49vHxQevWrYU2BaB8fl6JqQCLxVLptsXOnTuje/fussdRkdDQUDz55JOa2sqj0+nQq1cvdOzYUfG2DQYD+vXrp7l9+E5OThgwYICi2zNvaNCgAZ588kke+SujgoICjBgxQtHTSpWwdu1afPLJJ5LXu3HjRnz88ceS16um0tJSjBkzxi7WfNzpRgKQDeCg0Eo2b95s0+K8IUOGCG3qphMnTtg09SDU1atXK720pmXLlujfv7+iHXGzZs0wdOhQTX6x63Q6dOzYEX369FFsYaCvry9GjBiBxo0bK9KerfR6PXr27KnYe6LX69GxY0c8/vjjqq6DcATvvvsuTp8+rXYYsvj888+xa9cuyeq7cuUKxo0bp9lt1GLk5+fj3//+t91Nady6km290EoKCwuxefNmq18fFxcnejudxWLB/v37Zd8VYDabcfFi5aclR0VFYcyYMbLvr/b09MSAAQPQq1cvzQ/pxsTE4Omnn0ZISIhsbeh0OjRt2hRjx45FcHCwbO1IJSYmBmPHjhV9KmZlateujdGjR6Njx46a24VQ1ezfvx8LFixQOwzZmM1mvPrqq5ItCpw0adI9d1dVBUeOHMHcuXPVDsMmt04emwCMEFpRQUGBTQv8AgMDsWbNGqHNASi/PS89PR3BwcGydoglJSVwc3Or9InbaDQiNjYWvr6+uHTpkqRH2hoMBjRv3hyDBg1CUFCQZPXKzcPDA7GxsfD398eVK1dsuu/+fsLDw9G/f380a9ZM88nQrdzd3dGkSRMEBQUhKysLubm5ktQbEBCAbt264ZFHHlHkzgwpZWZm4tgxYRuR/P390b9/f4kjupvRaLzrc/bss8/iwoULsretpszMTAQHB4u+T+PPP//ExIkTJYpKuw4ePIiRI0cqNvqZm5uLGTNmCC5/6yd6B8qvBhZ0csr+/fuRnp5u9V30rVq1QuPGjUXfnpabm4udO3eiTZs2sr7paWlpMBqNlQ6p6nQ6PPjgg2jSpAkOHz6Mffv2ibrDwMPDAzExMWjZsqXdfanfoNPp0KRJE0RFRSExMRGHDh1CcnKyoINRXFxc0KhRIzRr1swunvgrU79+fdSvXx/nz5/HkSNHkJiYaPPKa2dnZ9SvXx8xMTGIjIzkE7+CDhw4IOnwuJZ98cUXGDx4sKitz19++WWVHPq/07Vr17Bw4UI8/fTTaodilTu/MWZDxCjA2LFjMXr0aKtff/ToUYwePVqSU7K8vLzQpk0bWY9p9PT0RFhYmE1ftOnp6Th16hSSk5Nx8eLFStcT6PV6BAQEICwsDPXq1UN4eLhmVvhLKS8vD2fPnkVycjIuX758z90WRqMRAQEBqF27NsLCwhAWFlZl57TNZjPS0tKQkpKCjIwMZGVlIS8vDyUlJTCbzXBzc4O7uzuqVauGwMBA1K1bF3Xq1LGr0Y97OX36NBYuXCiobGRkJBYtWiRxRHcLCAi4bQTwxRdfFByzPVq2bJngxdvZ2dmIjo6u9LuvKmnYsCH++OMPRdpKS0sTdSnbnd8eyyAiAfjxxx8xZMiQ267SrUyTJk2QkJAgyVnyubm52LJlC1q0aIFq1aqJrq8ieXl5yMjIQPXq1a0uU6NGDdSoUePmlsHs7Gxcu3YNxcXFKCsrg06ng5ubG7y8vFCtWrUq2eHfydPTEzExMTdX7FssFhQVFaGoqAhmsxkGgwFubm6a2uEgN71ej+DgYLsf2XAEZWVlWL16tdphKGrFihWCE4A1a9Y4TOcPlB+Pf+bMGbu4QOjOBGAdgKsAAoRUdv36dSxbtsymVf4TJkzAli1bcO3aNSFN3qawsBBbtmxBw4YN0bBhQ1mGRC9fvgwXFxfBlxL5+PjAx8dH4qjsm06ng7u7u9WJI5Gajh49WuFdIVXZ1q1bBZfdtm2bhJHYh23bttllAlAC4EcA44RWuGDBAgwYMMDq+Xhvb288//zzeOedd4Q2eRuLxYITJ04gIyMDsbGxssydX7hwAXq93m7n5YlIuEOHDokqr9PrEN4nGsFd6sPN34hwfw80qiHPd0lZqQlppzPw8+SNOHeo8t1MlUlOTkZWVpag0dWDBwXvMAcABBjc8UxANBq7+8NN74TIGE+4uMszUppdUoINFy7gvwcOIE/E7ocDBw5g1KhREkYmj4omEOdCRAKQkZGBlStX2rQyt2fPnti7d6+kw2pXr17F77//joiICDRo0EDS4WSLxYLU1FSEhYXBw8NDsnqJSPvOnDkjqnz8e91Ru9M/W0EbRQaihqd801216wcirntD/G/oAuz7Vfii66SkJJsvdCspKUFqquC75lDHxQuzQh6Gt1P5A6Wr0QkNZEqWbogNCEBCWBhaLV0qOAlISkqSOCp5VLSscz+AA2IqnT17ts3781977TWEhYWJafYuFosFSUlJWLt2LY4cOYL8/HzJ6jabzUhOTna4oUAiRyfmALKgDhG3df4A4OUi/7ofJ4Mez3zZD65G4Yto09PTbS6TmZkp6nCc12o2u9n5A4CbuzKXsDXw9cXrIo41F/JeqeFe7+aXYipNT0/HzJkzbSrj7u6OyZMny3K6nclkwtmzZ7Fu3Tps3boVKSkpklx2YTabkZqaWmXOACei+xPzIFG9WZ3b/lkHHdycldnJ4R3ggfA44YtM8/LyFClzg4tOj6bG27eVG1yUu4X14Tp17v+iexDz362ke72bPwKo+Co8Ky1cuBDnzp2zqUxERAQ+/PBDWVfCX716FQcPHsRvv/2GjRs34siRI0hJScHVq1dRVFRk815Vi8WCv/76CxcvXpRkOyMRaZuY/fDm0tufhi2wwGxWbn98WbHwp3Eh/91i3isTLDBZbv9OVfIsgWIRIxdaui6+MvdKPYsAfAFgktCKy8rKMHnyZMyYMcOm1fjt27fHG2+8gffff1/2X3ZOTg5ycnLu+vdOTk4wGAw277HW6XQwGAw8kIXIBkrdPy8VMet+Lm5OQkT/GOj0/3xHFJaZ4OUk/yjApaSrOHfoL8HlPT09bS4j5r0yWSzYlHsBXb3/OU68rFi5h6yfRMzjC3mv1FDZp+4LAC8BELxn7caTti1HBANAQkICrl27hi+++EJo06KYTCaYTCZJj/Mloqqhdu3agstmHruEk3P24oGRLW4ew5ZTVAovV3kTgNysAnw5ejFMZcI7UCFnVAQGBsLFxUXwOQD/Sz+I+m5+CHUpX/hXWKBMAvDb+fP4SuDx1ICw90oNlX3qrgP4CsDrYhr45JNPEBMTY/MbMnz4cJhMJkyfPt0hjpAkIvsg9jKnE7P24uqhi6jTvSGcjS7YtC8V9QLke2JMT87Cmq+349pl4fdO6PV6RERE2FzOyckJ4eHhOHnypKB2r5mK8WTyOvT3i8QDbtWg1+lw9Lg7XGVaDFhqNmNdaioWnj4NMb2OnBd+Sel+aedHAJ4CYN0B/xXIy8vDyy+/jDlz5ti8FW/UqFGoUaMGJk2aZHfXLBJR1WTrVriKZBy6iAwR+/KV1qhRI8HD2s2bNxecAABAscWEH7JuKW8Hb5sUnxEl3C+NygHwrthGzpw5g2nTpgkq27NnT3zVh8UEAAAXq0lEQVT88ccOdSwsEWlX/fr1UatWLbXDUNSNo8yF6NChg4SRaJ9OpxP1finJmnGU7wAInwz5208//YSNGzcKKtuhQwfMmjULdevWFRsGEZEoOp0Offr0UTsMRfXt21dw2Ycfftihjj+Pj4+3m2vbrUkATACel6Kxd999F0ePHhVUtkGDBliwYAG6desmRShERIINGTLEbrZ6iRUbG4uoqCjB5V1dXdGvXz8JI9K2YcOGqR2C1az9BG8CsEJsY0VFRXjxxRdx/vx5QeWNRiP+7//+D6+//rrdbLMgoqonIiLC5t1N9ur558U//z377LNV9irvW4WEhKB3795qh2E1W1LYlwCIPkv3+vXrGDdunKjjNPv27YulS5eie/fuYsMhIhLk9ddfr/Jrk1q0aCHJqGvt2rUxZswYCSLStrffftvm82PUZEsCcBbAf6Ro9NKlSxg/fnyFh/BYKyAgAB988AGmT5+O8PBwKcIiIrJaWFiYJE/HWuXm5oZPPvlEsoPNXnrpJYSEhNz/hXaqa9eudjcqZOsk1jcAVknR8NmzZzF69GhRIwFA+RaTH3/8Ef/73//QqFEjKUIjIrLKhAkT0LZtW7XDkMUHH3yA+vXrS1af0WjEt99+a/VV8fYkKCgIn332mdph2EzIKpbREHlPwA3nzp3D6NGjRV0XCZQfUtG+fXvMnTsXU6dORVxcHI/jJSLZOTk54bvvvkNkZKTaoUhq5MiRGDp0qOT1xsTE4PPPP69SCyi9vLwwd+5cVKtWTe1QbCbkt5CO8iRAEmlpaRgxYoTg3QG30ul0aNeuHb799lusWrUK48eP59ZBIpKVn58ffvrpJ7s5/e1+hg8fjg8//FC2+nv37o0pU6bIeumbUnx8fLBgwQJER0erHYogQn8DpwAEARB+YfItiouLsWHDBoSFhSE0NFSKKuHp6YnY2FgMGjQIbdu2RVBQEPR6PTIzM1FWViZJG0SkLn9/f/Tv31/2doxGY6WLu7y8vNC7d28cPHgQf/0l/MIdNTk5OWHixIl48803ZR9BjY6ORlRUFDZt2mS3d66EhoZi8eLFiI2NVS2G3NxczJgxQ3B5Mb9lVwAbALQTUcdtdDodBg8ejPHjx8u2ZaSkpATHjx9HUlISUlJSkJqaitTUVFy6dIl3DhDZmcjISCxatEj2dgICAuDm5nbf15lMJkydOhXTpk2zq1sO69Spg2nTpqF169aKtpuSkoLx48dj3759irYrVt++fTF58mR4e3urGkdaWhri4uIElxeb5gUA2A3A9lsiKtGoUSNMnjxZ0dOUPD094eTkhPz8/Js/RCS/PXv24K233hJUVmsJwA1JSUl4//33sX79ek0/WHh7e2PMmDEYN26cTf99UrJYLFi8eDGmTJmi+dGTmJgYvPnmm2jXTrLnXlHUTgAA4AEAOwH4SlDXTV5eXnjttdcUPfnPw8MDfn5+irVHRMDGjRsFLzjTagJwQ2JiIubPn4/ly5fj2rVrMkQmTHR0NPr374/HH39cM8f0lpaWYuXKlVi8eDF27NihmQvg3Nzc0K1bNwwePBgdO3ZUO5zbaCEBAICHAfyG+98uaLOmTZvi1VdfVWyvv9FohJ+fH3cRECmkKicAN5hMJhw7dgy7d+9GUlIS/vrrL+Tm5ioyTWA0GuHj44OIiAg0bNgQ7dq10/xlRtnZ2di5cyeOHDmCs2fP4tq1a6LOjbGWTqeDj48Pqlevjnr16iEuLg7x8fGqjY7cj1YSAAB4GsAMiesEALi4uGDo0KEYNWqUIr8IFxcXBAQEVKmtKkRa5QgJAJEcxCYAUvZw3wH4NwDJJ7xKSkowa9YsDBw4EL/++qvsq/hLSkpw5coVu1rEQ0REZAupH3G/QflIgFniegGUZzvvvfceevfujUWLFsm6faSsrAxXrlzhYkAiIqqS5Bjj/h4yJgEAcPnyZXz66ad47LHHMH/+fNkW11gsFly7dg3Xr1/X9EpeIiIiW8k1yT0LwCgAsi7jvHr1KqZNm4ZHHnkEL774In7//XeUlJRI3k5eXh7S09NlqZvI0YlZcMvEnEg4Oe8tnAsgC8APALxkbAdlZWXYunUrtm7dCm9vb3Tp0gVt2rRBXFwcvLykabqsrAwZGRnw9PTUzLYZoqrA3d1dcFmlTpFjokFaVFBQIKZ4odwXF/8KoDWAFQAU2ceXk5ODZcuWYdmyZdDr9WjYsCGaNWuG5s2bo3HjxqJObrJYLMjNzUVhYSF8fX25KphIAp6enoLLKrE1DADMZtlmNIkEEzn9nS93AgAAxwHEA1gCoJMC7d1kNpuRmJiIxMREzJs3DwDg6+uL0NBQhISEICQkBMHBwfD09ISXlxeMRiPc3d1hNBor/VIqKyvD1atX4ebmBl9f30rPCCeiynl4eAgum52djZycHNmPZGUCQFqUnJwspni2Uj1XJoCuAD4A8KpCbVbo+vXrOHz4MA4fPqxmGEQkkRMnTqBFixaytsEtwaRFIvux80qedFMG4DUAQ1C+NoCISLQ9e/bI3gYTANKiLVu2iCmerMZRdwsBRANYo0LbRFTFrF+/XvYh+tLSUi4EJE05duwYzp49K6aKRLXOuk0D0BPAGAC5KsVARFXA5cuXsX37dtnbKSoqkr0NImvNnj1bbBW71Tzs3oLy44ObANioYhxEZOdmzpwp+ygAEwDSivPnz2PJkiViqigGcFALt92koPw2wUcBnFA3FCKyR4mJiVixYoWsbRQWFnI3AGnCm2++KXZdyh8AirSQANywCkAUgOEALqscCxHZmSlTpuDECfmeIcxms9iDV4hEmz9/PjZs2CC2muWADFf3SsQL5dsFnwcgfJMwETmUWrVqYe7cuahWrZos9RsMBtSsWVOWuonuZ/fu3Rg0aJDYEzBLAdQFcNlJmrAkVwJgE4AZAPJRvmvAqGpERKR5eXl5OHjwIB566CG4urpKXr/ZbIZOp5OlbqLK7N+/H8OGDZPihtrlKL+vB1pNAG4oBLAFwNcAzgOoA4DpNxHdU0ZGBrZu3Yr4+Hj4+vpKXn9JSQk8PDyg12tpBpWqsuXLl+Opp55CXl6eFNVNAJAMaD8BuKEUwAGUjwisR/lVwxEAeBg/Ed3l+vXrWLVqFYxGIxo1aiTqxsGKlJWVwWjkoCTJKzMzExMnTsRHH32EsrIyKarcDeCNG/+g1TUA1nAF0AvAAADdAfCKPiK6S3h4OEaNGoWHHnoIzs7OktXr7e0t+x0E5JiysrIwa9as/2/v7mOsOhM6jn+HGdqZcd4Ay7IM0dYQsZhlt2tZXLuJKTFZt4mvoQ21lmo0jYm7salrbWLSLDHRRDcxqf/UlKJtGrZdaw3pSmBNIaW4VaRAsVB06HSAaYa3CwPMy2Uu917/OAxbXu7MnXPunTP3PN9Pcv6Ae54zz3l5nvu75+U5vPjii1y8eLGWi/5VYMfkPxo5AHzWHcAvA98geuHQKsDzc5Ku6+npYe3ataxevZp7772XpUuXJj6Nv2jRokSvM5YgGmPi2LFj7Nu3j127drFz5856DD+9neg78rqsBICbLQK+Bqy+Nt0P1Oe2YEkNad68eXR0dNDR0ZHoEkFzc3PNLzEoDBMTE4yOjs7Ga63zRI/Z3zB2cEhH7eeAe4EVwN1AL9GjEF8BjPCSpKz6M+C7N/9nSAGgkoPAF+MUXL16dcVngleuXJmkTuRyOTZt2hSrbGtray3GiZZSNTw8zLPPPlvra6BSaH5IdOr/lmEsW2a/LtnR0tJS8aai1tbWRKcFkzxn3NTUREdHR+zy0lzQ0dHBM888w3PPPUexWEy7OlIjOg5s4DZf/uCNcpLmsFWrVvHkk0+mXQ2pEQ0DDwGnK81gAJA0pz300EM88cQTaVdDaiQjwK8DR6aayQAgac5bt24djz/+uHfbS9O7TPS8/7vTzWgAkNQQHnnkEZ566ilaWrx1SargU2At8B/VzGwAkNQw1q5dy8aNG1mwYEHaVZHmmh8RjXmzr9oCBgBJDWXVqlU8//zz3HfffWlXRZoLrgIbiUbDPTWTggYASQ2np6eHjRs38vTTT9Pd7WtAFKy9wC8B3yEKAjNiAJDUkJqamnjwwQd54YUXePjhh2lt9eWgCkY/8PvAV4H/jrsQA4CkhtbR0cGGDRt46aWXWL9+PQsX+toPZdYB4AmiIe3/iQoD/FTL22klZUJXVxePPfYY69evZ9++fezevZv9+/czMjKSdtWkJPqBt4CXiQJAzRgAJGVKc3Mza9asYc2aNRSLRbZu3eq7MdSovgR8UK+FGwAkZVZzc3PFF3ZVo6uri/vvv3/Kedrb21m6dGms5e/YsYPjx4/HKrtu3ToeeOCBWGWzZtOmTRw+fDhW2RUrVtDb2zvlPEuWLIn1fpV8Ps8rr7wSq17X/G+SwtMxAEhSBc3NzfT09Ew5T2dnZ+wAkOSlX3fddRfLly+PXT5L2tvbY5dta2ubdh8vXrx42nluZ3R0NG61ZoU3AUqSFCADgCRJATIASJIUIAOAJEkBMgBIkhQgA4AkSQEyAEiSFCADgCRJATIASJIUIAOAJEkBMgBIkhQg3wWQQeVy2VegStfk8/m0q1AXV65csZ1fUywW065CQzIAZFA+n+fRRx9NuxqS6mjz5s1s3rw57WqogXkJQJKkABkAJEkKkAFAkqQAGQAkSQqQAUCSpAAZACRJCpABQJKkABkAJEkKkAFAkqQAGQAkSQqQAUCSpAAZACRJCpABQJKkABkAJEkKkK8DzqYR4KfSroQ0R/wa8HLalaiDbwO+DzjyPeDraVei0RgAsqkMXEi7EtIcMZp2BepkDNv5pELaFWhEXgKQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJkgJkAJAkKUAGAEmSAmQAkCQpQAYASZICZACQJClABgBJakzltCugxmYAgCtxCxYKhYqflUqluIsFYHx8PEnxfKI/LmVL7PZw9erVaedJ0tbz+URN1Xb+Y3XpxycVi8VYy064f0vARJIFTMcAAJfjFrxypfIxF/eAmTQyMpKkeOx1kjIodmOqpgOvJiRUYjuvmbr045PihryE+3eUKATUjQEgwYEzNjZW8bOkAeDSpUuJiif641K2xG4PhUJh2l+Icb8cSqUSly8n+g43APxYXfrxSXH784sXL8Yqd03d+3EDAJyIW/Ds2bMVP5uYSHbm5pNPPklS/HiiPy5lS+w2DlO3c4hCQpyzACdPnqzq9PMUBpIUzpjY+/jcuXOUy1PfThH3VP5c78cNAPB/cQteunSp4rX60dHR2BUqFotJD5y+JIWljMkB5+MWPn369LTzxLln5+OPP45TnUlXgUSdRMbE7scnJia4cOHClPPE2b/lcjnpPq57P24AgKNJCg8MDNz2/6s5rVTJoUOHkp5BSLROUgZ9FLfg4ODgtL/UZ/oFcfXqVQ4ePBi3SgAfA4lOH2RMXfrxSYVCYcZ9cl9fX9JLuXXvxw0A8F8kaEjHjh27becwPj4e6/ReqVRiz549casz6d2kC5Ay5kdxCxYKhWl/yc30Wu+BAweSfjkk7iQypg84E7fwiRMnpj1rO9P99c4778StzqS69+MGgOgO4f1xCxcKBQ4fPnzL/5fLZYaHh2e8vPfee49cLhe3OgCnSHA6TMqoRL1xX1/flF8Q4+PjVd1NDtGd4TX4ctiddAEZUybBNimVShw6dGjKeWbSnx88eJBPP/00bnUAxoF9SRZQDQNAZEeSwv39/bfd2dNdV7rZ4OAgO3fuTFIVSLguUkbtJupUYykUCuzdu3fKO/7Pn5/+NoNyucybb76Z9PGwIvDvSRaQUYn6vqGhIY4dO1bx87GxsapuBjx79izbtm1LUhWAXSQY26BaBoDI95Iu4P333+fMmRvPQOXz+apPDQ4NDfHaa68lfnwQeC3pAqQMugz8IMkCLly4MGUIyOVy0w4OtnXrVvr7+5NUA6KzGUNJF5JB/0LCgXM+/PBDTp48WfHzm/v4m+VyObZs2ZL4KTBmqR9vno0/0gDOAb8BfD7uAkqlEoODg7S1tdHT03P9//P5PIsWLaKpqali2b6+PrZs2ZJ09D+IroF9kzoPHiE1qAKwPskCLl++TC6XY8mSJbS0tNzw2eSjZJ2dnbeUGx8f54033rjt5cIY/ooEly0zLA+sBlbEXUC5XGZoaIiWlhYWLlx4S7+dz+fp6upi/vz5t5Q9ceIEr776atJ7OwDGgD+kzqMAggHgsyaIQkBskwdPLpejp6eHO++8k2KxSEtLC+3t7bfMPzw8zFtvvcXbb79di1/+AN8FEl9DkDLqGLAB6JluxqmMjY0xMDDA/Pnz6e7uvuFLYnx8nM7OzutfEKVSiQMHDvD6669z6tSpJH920jngD/AJgErOEe3jRM6cOcPp06fp7u6mra3ths/y+TwLFiy4vt9HRkbYvn0727ZtSzquw6QXgX+txYKmU/lnaXjuIHqudmmtFrhgwQJ6e3vp7u5mxYoVtLW1cfHiRXK5HB999BHHjx+fdgCKGRgDfpqoAUi6vW8Bz9dqYfPnz6e3t5fFixfT1tZGa2srpVKJ7u5uBgYGOHLkSKJHgm9jI/CdWi4wg/YD99VqYV1dXSxbtozu7m7a29uZN28era2tlMtljh49Sn9/f+J3v3xGEfhZIPF1Is3ct4juJm3E6W/qsD2krPkJYJD022uc6TywqPabJHN+k/T3VdzpH+uwPVSlFuAQ6R8EM51OAd112B5SFj1G+m02zvTNemyMjNpO+vtrptMlEtyHptpYS3QTXdoHw0ymxNe8pIA0ET0WmHa7ncn0AdEPFFXn54luCkx7v81k+tO6bAnN2N+R/sFQ7fRmnbaBlGX3ABdJv/1WM+WBVfXZDJn2bdLfd9VOu/Gm/DnjTuAA6R8U000ngIV12gZS1v0O6bfhaqY/rtcGyLh5RIMDpb3/ppvOAcvqtA0UUy9wkvQPjkrTJeBLdVt7KQx/TfpteappU/1WPQjdwP+Q/n6sNF0huuysOejLzM3ThBPAN+q43lIomoAtpN+mbzdtw+v+tXAP0ciJae/Pm6ci0VkozWG/AJwl/YNlcsoTPeYiqTaaiR6/Srttf3b6AXDjCDRK4h6iZ+vT3q+T01Xg9+q5wqqdVUTX29M+aHLAg3VeVylE84C/J/02XgZeBm4da1ZJ3Q0cIf39O0LCUWc1+34S+CHpHTQHgZ+p+1pKYftdYJR02ngB+PP6r2LQOoDvk14/3gd8oe5rqbpoAZ4lGnZ3NjuFv8XTgdJsWQXsZXa/GD4AvjIbKyeagD8Chpm9/VsC/gEHbMuE5UTX6Op90OyhhmNaS6paM/AnRI9o1bONXyD61e8p/9m3lOhV8EXqu4/3A1+bpXXSLPpFojt1a30A7QG+PovrIen2OoG/AE5T2zZ+HvhLYMHsrYoq+ALwz0RnW2u5j98Hfgtfupd5dxO9oSvJDSb9RK/zXTmrNZdUjTuA3wa2Et3EFaeNjwH/BqwHWme3+qrC54nOxhwg/nDwg0Q3k355lusei8mk9pYBv0J0HXEl0Y17PUS/JJqJBvAZBgaAo0QvH9pJ9K5ySXPfHcADwFeJxpz/OeAuojbeQzR2yGWiywdHiX4Y/CfwLtFjvJr7PkfUj3+RqB9fTnS2ppPocs1loss3J4j28YfALqJ9LUmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJEmSJElSCv4fhWk4qtZ7psEAAAAASUVORK5CYII='
machine_image_id = system.db.runPrepUpdate('INSERT INTO machine_image (machine_image_id, machine_image,time_stamp) VALUES (NEWID(), CAST(? AS VARBINARY(MAX)), GETDATE())', [encode], getKey=True, skipAudit = True)
print machine_image_id

the data:

I believe I should be able to get around this by creating a stored procedure that returns the ID generated and call it from a named query.

If anyone could confirm if the above behaviour is expected or if it is a bug then we can look at getting it into a future release.

Regards,
Tim

It's not supported, if you look at the function signature you can see the return type is currently Integer.

It isn't fundamentally unimplementable. Once must use Statement.execute(String,int), followed by Statement.getGeneratedKeys(). That latter yields a ResultSet that can contain any supported column type, and can have multiple columns for multi-column keys.

Seems to me a feature request is in order.

1 Like

I have added this as a feature request.

Thanks everyone.

1 Like

So, I managed to nerd-snipe myself. And in the process, added another reason to avoid MS SQL Server like the plague.

1 Like