Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Float Data Type
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01089757
Message ID:
01089821
Views:
36
In short, the SQLEXEC() is SPT.

>I understand, althought I'm not totaly sure how SPT works. Can you elaborate?
>
>Thanks
>
>
>
>
>>In addition, you will have to double single quotes in the strings, if ther are any, or you will get syntax error. SPT parameters allow to avoid this problem.
>>
>>>ohh, I see now. Thanks!
>>>
>>>
>>>>If you want to build SQL command as string, use TEXTMERGE (see below). It makes code readable. The string values have to be enclosed in single quotes. You may consider using SPT parameters ('?') instead.
>>>>
>>>>>Ok, I have another problem with this code.
>>>>>
>>>>>SWL is reporting "The name 'JVILLAGOMEZ' is not permitted in this context. Only constants, expressions,
>>>>>or variables allowed here. Column names are not permitted."
>>>>>
>>>>>It must be referencing the 'user_name' column, but I don't see why.
>>>>>
>>>>>Here's the CREATE TABLE code again:
>>>>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform