I've been creating imports that use SSIS to import data into a temp table, then using a stored procedure, steps through the data one by one with a cursor to process the data and insert information into 3 different tables. The inserts in the first 2 tables are complicated because if there is a record that already exists with the same dat...
I have 2 Android Databases in my app. For the sake of an example, lets say Database #1 is called JOBS and has the following columns: "Jobs Primary Key" - "Job Title" - "Job Description" Database #2 is called PEOPLE and has the following columns: "People Primary Key" - "First Name" - "Last Name" - "Jobs ID Key" (Yes I know these are n...
I'm trying to build a form that works in a manner similar to the Google Search page, as well as Gmail and several other pages (including the this page - see the "Tags" input on the Ask Question page). As text is input, a list of options will appear, and the user can use up and down arrows to select the option they want. The problem I a...
I have a grid view of buttons that is generated by a CursorAdapter. When the CursorAdapter is passed to the Gridview the view renders correctly however the first item in the grid does not fire the OnClickListener event. If I select another button in the grid, the event fires correctly however if I selected the first button then another ...
Hi, I got following problem, I need to use a Content Provider to read a Database of an other App. first I want all rows, and after analyzing the data only e.g. the rows from _id = 1, 3 and 5. how can I call a Content provider and select only these rows? or is it possible to create a subset Cursor form an given Cursor? Thanks in advan...
This is my code, it always falls into the else even when I know that the value going in (via debugger) is emtpy. name = cursor.getString(cursor.getColumnIndex("Genus")) + " " + cursor.getString(cursor.getColumnIndex("Species")); if(name != "" && name != null) tv.setText(name); else tv.setText("Error"); ...
Hi all, I have an app that will query a database and attempt to output results in a list format. my first attempt was to use a simpleCursorAdapter, which worked fine for string outputs such as name and status, but would not display the time field from my cursor. My time field in my data base is of type Timestamp. the query for the ti...
Hi all, Im working on stored procedure where I need to retrieve a set of results and process each element individually and then return the entire result.(using 3 different tables) Im not too familiar with databases, but heres what I was able to come up with.. create or replace procedure GET_EMP_RSLT IS CURSOR ecursor IS select emp...
Ive read through the docs and searched on here, but Im not quite understanding how all the pieces fit together. Was wondering if anyone has a clear explanation of how to grab a single column of data from Contacts and have it populate an autocomplete box. ...
ok im trying to create cursor using gdi. i can't even find tutorial how to use customize cursor, i can find so many tutorials for c#. all i know that i use these two functions to set cursor,setcursor and loadcursor that is it thanks Rami ...
I have a html form with three inputs for phone number input. I want a cursor to move to next input after the current one is filled. Like you entered 3 digits in first box than cursor moves to second and after it is filled moves to 3rd. Is it possible to accomplish this without javascript? ...
EDIT: changed the title to fit the code below. I'm trying to retrieve a list of acceptable values from an Oracle table, then performing a SELECT against another while comparing some fields against said list. I was trying to do this with cursors (like below), but this fails. DECLARE TYPE gcur IS REF CURSOR; TYPE list_record IS ...
Hi all, Cocoa app, SnowLeopard I have a WebView in to which I'm loading HTML (essentially for application UI purposes). In the html, I've added: <body onselectstart="return false" ondragstart="return false"> This prevents text from being selected, which is what I want for this job. However, whenever the cursor is moved over any te...
I'm trying to get the cursor position inside a NSTextField but so far unsuccessfully. Tried using [[myWindow fieldEditor:FALSE forObject:myTextField] selectedRange].location but no luck. Any ideas? ...
I have an transparent .PNG image that I need to convert into an .CUR file. Does anyone know of good online software for converting .CUR or free-inexpensive downloadable softare? Thanks in advance! ...
People seem to love to answer this question everywhere online while ignoring the CONTENTEDITABLE div requirement. Using code that seems to only work on input fields or textareas and not divs. Additionally, most questions people have wanted to put the cursor caret INSIDE the newly inserted HTML... which is weird, because it does it autom...
I need to display results from a SQL join in a ListView/ListActivity. I've created a cursor: Cursor cursor = db.rawQuery(LIST_JOIN_SQL, null); and if I iterate through the cursor, the results are exactly what I expect. However when I try and use a SimpleCursorAdapter to display these results in a ListView I get a runtime exception b...
I have this Windows Forms application with a simple balloon tooltip. Depending on the application's window location on the desktop and the mouse cursor location, the balloon 'tip' (or balloon pointing arrow) may or may not be pointing to the location I want. For instance, my app snaps to the desktop sides and when it's snapped to the ri...
Hi all, Cocoa, Snow Leopard, Tiger compatibility needed. I have a WebView containing some HTML. The HTML contains links, and is used mostly as a UI replacement for Cocoa. Question: how do I prevent the 'hand' cursor from appearing when the mouse is moved over a link? For aesthetic reasons with this particular UI, I need it to stay as ...
I have an HIViewRef created using HIObjectCreate. This is basically a window in which I draw something. I want a hand cursor on this Window. I am working on a legacy code and use Carbon, so please no Cocoa. Any ideas on how can I associate a hand cursor on the window. ...