Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swapnamandava
Starting Member
2 Posts |
 Posted - 2008-04-26 : 17:37:38
|
| Hi All,I've a .sql file to execute my view. If any one of you have the syntax of that file, please share that to me. In my MessageVolume.sql file I've the following definitions.The UI is dynamically loaded. When I select 'queue' from the UI combo box, then it checks the 'CONDITIONS' in the MessageVolume.sql file and if the same name is mentioned, then it will enable the Queue field.Similarly for the user field.My requirement is: after selecting the 'User' from the UI combo box, Not only the user field but also the queue field should be enabled. Let me know what exact changes I need to do in the .sql file.NAME={queue}CONDITIONS= QueueVALUE=LABEL=Queue:DESCRIPTION=Name of queueVIEW=queue treeSQL={connector} {ObjectVolumeDateView}.OBJECTID in ({queue})NAME={user_name}CONDITIONS= User QueueVALUE=LABEL=User Name:DESCRIPTION=Name of user who handled messageVIEW=user treeSQL={connector} {ObjectVolumeDateView}.OBJECTID in ({user_name})%% Thanks in advance |
|
|
|
|
|
How to write .sql file for executing views?