11-26-2013 01:14 AM - edited 03-14-2019 12:47 PM
Hi People,
Does anyone know how to ignore the dollar sign in a table name during a db read operation. I performed a db read with the statement 'Select * from [CIC$Table]' but i get the error message 'Sql statement variable not defined: Table]'.
Any help would be appreciated. Thanks.
11-26-2013 01:16 AM
Hi,
what kind of database is that?
Did you try to escape the $ with a backslash [CIC\$Table]?
G.
11-26-2013 01:36 AM
Hi,
The database is MS SQL 2008.
I have tried with the backslash but i still get the 'Sql statement variable not defined' error message.
Tola.
11-26-2013 01:42 AM
Hm. Why the dollar sign.
Anyway, would it be possible to create a view (this time, the name without the dollar sign) just with a SELECT , , FROM [CIC$Table] ?
Then, of course, use this view from the UCCX scrript.
G.
11-26-2013 02:04 AM
Thanks for your reply.
I already created a view (CIC_Table) and i could successfully read the database. However, when i try to perform a db get operation using the database view table and map fields to variables, the fields on the db get disappear as soon as i save.
Tola
11-26-2013 02:09 AM
Hmm. Can you please give me the version of UCCX you are using, and also the version of the MS SQL Server. I would like to replicate the problem in my lab.
G.
11-26-2013 02:29 AM
The version of UCCX is 9.0.2 and the version of the MS Sql Server 2008.
Tola
11-26-2013 02:35 AM
Hi, all I have is UCCX 8 and MS SQL 2K5, so I can't test it.
Can you do another thing, just to be sure: run a query on a different table or view. Do you see the same issue?
G.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: