Is it possible to define variables in List Manager?
DECLARE @the_date datetimeSET @the_date = getdate()SELECT DISTINCT a.customer_no FROM T_CUSTOMER a WHERE a.inactive = 1 AND a.cust_type = 1 and a.create_dt <= @the_dateI tried to create a list by manual edit, but the above script won't work.
The error message says, "Illegal SQL statement"
Any advice would be appreciated
I'm afraid multiple statements are prohibited in the SQL query editor; this is done as part of our effort to prevent "SQL injection attacks", which would allow malicious users to enter statements that might alter or delete data or objects from the database.
Hello Steven,
Thank you very much for your reply.
I tried to eleminate spaces in my query, but still I am running out of space in this Manual Edit text box..May I know how to increase the field Text LimitThank you very much in advance!
I'm afraid it's not possible for you to increase the text limit in that edit box; it's hard-coded to allow a maximum of 1,020 characters.
I just found that the criteria is in table T_LIST and the criteria is defined as Varchar (4000). Is it ok for me just change the varchar(4000) to varchar(max)?
Thank you and good night ^_^
No, we do not support changes to production tables that you have not created yourself because these changes may be reversed in future database update scripts. Further, that won't affect the length of the query you can enter in List Manager because the limit is set in the client application, and I cannot guarantee that entering your query directly into that column by another means will work properly.