This relates to my recent question: http://stackoverflow.com/questions/2835663/force-oracle-error-on-fetch I am now able to reproduce a scenario where using ADO with the Oracle OLEDB Provider, I can force an error such as ORA-01722: invalid number to occur on calling Recordset.MoveNext However, this is not the error that is returned to ...
I've been working on sending text to an input element in Chrome and I noticed that, unlike in IE or FF, calling .focus() does not put the cursor in the text area. So does anyone know of an alternative for placing the cursor on a Chrome input element? ...
Hi Stackers In my VB.NET program, I need to save a bitmap as a .CUR cursor file. BitMap.Save provides facilities to save as .BMP, .ICO etc e.g.: (*) MyBitMap.Save(MyFileName, ImageFormat.Bmp) (*) MyBitMap.Save(MyFileName, ImageFormat.Icon) but not as a .CUR cursor file. How can I do this please ? TIA Patrick ...
I have this scenario onResume of an activity: @Override protected void onResume() { if (adapter1!=null) adapter1.notifyDataSetChanged(); if (adapter2!=null) adapter2.notifyDataSetChanged(); if (adapter3!=null) adapter3.notifyDataSetChanged(); super.onResume(); } Adapter has been defined as: pu...
I have a database that logs when an employee has attended a course and when they are next due to attend the course (courses tend to be annual). As an example, the following employee attended course '1' on 1st Jan 2010 and, as the course is annual, is due to attend next on the 1st Jan 2011. As today is 20th May 2010 the course status rea...
I've got a strange issue that I'm hoping someone might have experienced/have some suggestions on. I'm using a 3rd party library (GoDiagram), which having reflected it briefly I don't think is the cause of the problem. What happens is that I drag a file onto a background canvas which inherits from the Control class. At the point of dragg...
Hi, I am trying to see if its possible to perform Update within a cursor loop and this updated data gets reflected during the second iteration in the loop. DECLARE cur CURSOR FOR SELECT [Product], [Customer], [Date], [Event] FROM MyTable WHERE [Event] IS NULL OPEN cur FETCH NEXT INTO @Product, @Customer, @Date, @Event WHILE @@FETCH_STA...
I am try to set the caret/cursor position to the end of the string value in my WPF textbox when I open my window for the first time. I use the FocusManager to set the focus on my textbox when my window opens. Nothing seems to work. Any ideas? Note, I am using the MVVM pattern, and I included only a portion of the XAML from my code. ...
I'm building a password box that holds three text areas. Each text area has one character. After I type the first character of the password, I have to press tab or use the mouse to get to the second text area to type the second character of the password. I would like to make this happen automatically (cursor movement) just right after I ...
I'm working on a stored procedure that uses a cursor on a temporary table (I have read a bit about why cursors are undesirable, but in this situation I believe I still need to use one). In my procedure I need to step through the rows of the table twice. Having declared the cursor, already stepped through the temporary table once and c...
Below is what I'm trying to do with by iterating through the records. I would like to have a more elegant solution if possible since I'm sure this is not the best way to do it in sql. set @counter = 1 declare @totalhrs dec(9,3), @lastemp char(7), @othrs dec(9,3) while @counter <= @maxrecs begin if exists(select emp_num from #tt...
How can I change the cursor when it's over an NSButton? ...
Anyone know why .focus() makes the cursor go away but it comes back when you click in the text input box? ...
Can I use Cursor with stored procedure in MySQL? And can I receive the output values from it? ...
I need to run a stored procedure on a bunch of records. The code I have now iterates through the record stored in a temp table. The stored procedure returns a table of records. I was wondering what I can do to avoid the iteration if anything. set @counter = 1 set @empnum = null set @lname = null set @fname = null --...
I've been checking around online and there are limited resources for creating a .cur file and next to nothing that works on a Mac. If anyone has suggestions on how to do this I'd love some help. Thanks! ...
We can declare a cursor like this DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1; Can we use a join query instead of a simple query? ...
Hi all, I am trying to do a simple task: I have an editable text field, two buttons (titles: make editable/ make un-editable) over a window. Idea is: when user clicks "make editable" button, text field should become editable and when he/she clicks "make un-editable", it should become un-editable. In action of "make un-editable" I am ...
I want to show the wait cursor before my WPF application, composed using CAL, fully loads. In the constructor of the main window, I have the following code: public MainWindow([Dependency] IUnityContainer container) { InitializeComponent(); C...
Hi, I have a query which returns 2+ rows. In those results is a column which we can call columnX for now. Lets look at those example results: columnX 100 86 85 70 null null I get 6 rows for example, some of them are null, some of them are not null. Now I want to go through those results and stop as soon as I find a row which is <> null...