I am running this Case Statement in Visual Basic and i am getting this error message. Incorrect syntax near keyword 'Case'. Any help is greatly appreciated.
Select HPD_HelpDesk.Priority Case Priority ==1 Then 'Low' End
The full statement is this:
Adodc1.RecordSource = "SELECT...
Mr. CajunCenturion thank you for your post of a possible solution, it sounds great and i will look into it. My question is if i do not have the value description and just have values and i have to place in descriptions for the values when the data gets pulled into the grid, how might i be able...
I am running a select statement in a visual basic program. I pull in the information in an adodc into a data grid. I have 6 columns and in one of the columns the infromation that is being pulled in is in a number format (0,1,2,3,4). They represent a level of urgency 0 = Low and 1 = Medium and so...
