I have approximately 100 SQL views that are a variation of this: select * from RTC.dbo.MyTable ...now I find I need to change the name of the RTC table to something else. Rather than edit one view at a time, is there a way to script out all their drop/create statements to a text file so that I can do a global replacement? ...
Does anyone know how to implement a view similar to the iphone calendar day view? ...
I've created a sql view and I need to sort the results of select by using the ORDER BY on 4 fields, but I'm getting message that ORDER BY cannot be used in views unless I use TOP. Can someone explain why TOP is needed, and does someone have a workaround for sorting in a sql view? Thanks. ...
Hello Guys, i'm developing an app that requires caching web pages (completely) along with their CSS files and images. so after saving the entire Html of the page ( going through the links to store each file along with the Html file ) later on, while viewing the html file offline, UIWebView takes a long time to load the page, given tha...
Hey folks I was wondering if anyone can tip me on a painless way of invoking a modal view controller from a web link in a UIWebView. Is it possible to do this? I want the modal view controller to still be a part of the app as opposed to closing the main app and using a helper application instead. Any help would be greatly appreciated...
I am doing a game in iphone, suppose to change menu view to the game on touch single player. when the view change only the interface is shown but everything is not moving. i am suspecting that my codes only manage to call the view but not the game class. Is there anything i can call with other codes that anyone can help? -(IBAction) dis...
Hi. I undestand what indexed view are but i wonder what exactly happens when the data in underlaying table(s) has been changed? Is entire view cache discarded od just changed rows? I have very complex query on several tables(+5) which is used for searching hotels availability(+100k records) and IMHO indexed view could improves performan...
I am creating a android app using LunarLander as a example. Now I need to create a few buttons which are drawn over the view. I do not want them as a seperate layout above or below the view but in the custom view. Is this possible or am I going to have to programmatically show the button images then detect the touch. The buttons I create...
I am developing an RCP application based on Eclipse and use i18n to load message resources. My requirement is that I need to change the View title based on locale/i18n. I am using setPartName to do that. It does change it, but the issue is that it shows the title-changes only after the view has been clicked. So, in a way, it first disp...
Suppose I have a view that rolls up data via a GROUP BY clause: CREATE VIEW InvoiceAmountsByCustomer AS SELECT Customer.CustomerID, SUM(Invoice.TotalAmount) AS TotalInvoiceAmount FROM Customer LEFT OUTER JOIN Invoice ON Customer.CustomerID = Invoice.CustomerID GROUP BY Customer.CustomerID Now, suppose I want the view...
I have a webserver with XML files on it. I want to find an online application that I can put on that server that will give Users access to view the raw XML files without being able to edit them. Does anybody have any ideas? This is a Windows server. ...
Hello Guys, sorry for this dumb question, but i am really stuck... the thing is i am trying to create a todo list application on android. I am stuck because at the moment I dont know the way to create many todo lists. I have created the GUI for one list, using listview. entries of the list are added by the user when running the appli...
I can't seem to get the number of view controllers in the view controller stack. NSUInteger *viewControllerCount = self.navigationController.viewControllers.count; I can loop through the view controllers and NSLog the objects within but I can't do a simple count. If I try to access this pointer, the ap crashes... no Log, no error mess...
Reading that http://stackoverflow.com/questions/894610/how-to-do-hibernate-mapping-for-table-or-view-without-a-primary-key I am wondering how to add a primary key to my view as it is basically just a stored query...? PS: oracle 10g thx ...
hello sir Is possiple to store two values store in same column in datagrid view column, ie datagridview.item(0,1).value ="somu" somu id value is =1 i want to store this id(1) to same column id any idea to this value to store in grid? please help me. ...
I have an application which has 7 tabs with associated views and view controllers. I need a way to update each view when it is selected. I have searched and searched, but cannot find a way to do this. viewDidLoad will not work, as that only is fired the FIRST time a view is selected. Capturing the selected tab in didSelectViewContro...
I have a view that is built on multiple tables from different users schema. By virtue of the currently logged in user, he is able to see the table from different schema. When the view is created the table name becomes ambiguous as the user have access to the same tables from the different schema. Is there any way to specify to use the ta...
Ok I have a little php, application or whatever that opens a zip and reads the content. But it only works SOME of the time... sometimes when I upload the .zip and try to view contents, it works and echos back each file to me, but some other times ( yes i have a lot of .zip files ), it returns these errors: Warning: zip_read() expects pa...
Im bit confused so be patient if im trying to do something wrong : -) In some MVC frameworks you can call controller action from the view if you whish to execute some code and render some partial view. Im not sure what is the correct way to do it in Spring MV I want to have set of JSP templates. Some of them will be page layouts some o...
Hi, I am very new to Rails so this will probably seem basic to most of you. I am having trouble getting instance variables from one of my controller methods to show in my view. I am trying to get the first 10 entries of a MySQL table called Odds to show up in a table on my index view. Here is my Model: class Odds < ActiveRecord::B...