Right, but I said with or without the ? mark I still got the same Syntax Error message.
I edited my last message to wonder if it wasn't allowed to have a function begin with a number, because i tried to stick a letter in front of it and now it seems to be running. Well, it runs to the point of telling me the login credentials for the database are incorrect, but that's good compared to what it's been doing. At least I know it's trying to work now.
>>The command is this now:
>>
>>
cmd = [exec InTransit ?']+ALLTRIM(user.cclientcd)+[']
>>
>>I tried running SQL Profiler, but the code doesn't even actually get to do anything, it gives me the error at the start of the function before it has a chance to start. I've never used Profiler before though so maybe I did something wrong.
>>
>>>What is the command now?
>>>
>
>
>It should be
>
>
cmd = [exec InTransit ']+ALLTRIM(user.cclientcd)+[']
>
>NO ? mark.