In the file that I have attached to this post, I have a few what I think are simple straightforward questions.
They use terms like tblHelpDeskTickets.lngTicketID. I am not sure what the lng prefix is all about.
It does define a new column in the tblHelpDeskTickets so maybe that explains it. Is there some kind of naming convention that I am missing here?
They also use tblHelpDeskTickets.ysnTicketAssigned. this one is much for difficult. There is no column in the tbl.HelpDeskTickets named
ysnTicketAsigned. If there is then I have not seen it. Yet from the syntax of the strSQL statement, it appears that to be a category of the
tbl.HelpDeskTickets. Again, is there some kind of naming convention that I am missing here?
That last one is truly confusing. I think I know what the tblHelpDeskTickets.lngTicketID is all about; but I do not have a clue what the tblHelpDeskTickets.ysnTicketAssigned
is about. Yet it is used in the strSQL update statement.
Also what does SET tblHelpDeskTickets.ysnTicketAssigned = -1 mean?
It seems confusing at least to me.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed