Software help desk

Published: August 29. 2010 4:00AM PST FOR THE WEEK ENDING AUG. 28, 1910 HAMPTON COUNTRY DRAWS The Hampton Butte country is developing remarkably, according to V. Schrader, one of the pioneer homesteaders of Hampton Valley, who drove in to Bend Monday with a four-horse team to get wheat and rye seed, with which he will plant 40 acres this fall. In Hampton Valley alone there are now 40 houses and tents. many miles of fence have been built, several hundred acres plowed and many more cleared, and dozens of wells dug, all reaching good water at slight depths. indeed, mr. Schrader says everything is highly promising, that new families are moving on to their claims each week, and that thousands of acres as good as any now occupied remain to be taken up under the 320-acre homestead act. The new settlers are working hard not only to tame the raw land but to build up a community. two petitions have been signed by practically every resident in the valley, one for the establishment of a school and the second for a post-office. In June there were 26 children of school age in the valley. the school, says mr. Schrader, is practically assured. The settlers desire that the new Prineville-Fife mail route, which has been in existence but a few weeks, be operated from Prineville to Fife, thence to Hampton and thence back to Prineville via Held, instead of doubling back on the Prineville-Fife route as now. the proposed change would make the weekly mail trip but two miles longer. Mr. Schrader, who is a Bend enthusiast, was particularly anxious that Bend people understand the opportunities they are losing. “Bend is but a very few miles farther from us than is Prineville,” said mr. Schrader. “Coming this way there are absolutely no hills while the Prineville road is excessively hilly. But Bend people don’t seem to care, while Prineville is working hard to get and keep the fast increasing trade of the Hampton country. A very little money could put the Bend road into splendid shape and a very little trouble could bring Bend a lot of trade. of course when the railroad gets to Bend all of our country will trade here. And the building of the east-west line will center all of the new country on Bend. Nevertheless, Bend is letting a lot of money get away by being asleep now.” Mr. Schrader came to this country from Davenport, Wash. His daughter Emily, will come in to Bend to attend high school this winter. FOR THE WEEK ENDING AUG. 28, 1935 VETERANS ENJOY ANNUAL OUTING Men who served their country in the Army, Navy and Marines at home, abroad and on the high seas gathered yesterday for their second annual picnic, at Shevlin Park, with veterans present from many parts of Central Oregon. the veterans were joined by their families, and children probably had a bit more fun than the grown-ups. In addition to the program of sports and a ball game, there were a number of short addresses by commanders of the Veterans of Foreign Wars and the United Spanish War Veterans. The Army was “hot” yesterday in the inter-service contests and won both the tug of war and the ball game. last year the Navy, aided by a few good Marines, won the tug of war from bill Baer and his husky pullers. the Army “kids,” of which McFadden was the star with his home runs and spectacular catches, defeated the Navy 31 to 3. Leon Devereaux did the chucking for the winners, with Bretano behind bat. Bishop represented the Navy on the mound and Sprout caught. Winners in the foot races were Albert Curtis, Lorraine Devereaux, Leon Devereaux Jr., Jean Huber, Rufus Biggs, mrs. O.F. Anderson, Shorty McFadden, and McArthy. In a feature race, mrs. C. Rhodes, Dordene Crandle, Tom Cook and J. Jackson all caught their chickens. the baseball throw was won by mrs. O.F. Anderson and Bud Bishop. MONKEY INVADES HOUSE IN BEND There is at least one wild monkey in Central Oregon, according to reports from the G.S. Vergeer home at 720 East fifth street. he is a brown monkey, about 18 inches tall, and he likes biscuit dough. Mrs. Vergeer was preparing lunch this morning. the biscuits were in the pan on top of the range and she went into the other room to care for her baby. When she came back there sat the monkey, one of the unbaked biscuits clutched in a paw. She screamed and the monkey skipped out through a loose screen on the door. Foot prints, or “hand prints,” if you like, showed he had made himself at home in the few minutes at his disposal. When the monkey left, he was seen by Rev. George H. Redden and the Redden children. mrs. Vergeer is glad someone else saw the same kind of monkey she did. it makes it so much easier to believe — easier for her, and others too. FOR THE WEEK ENDING AUG. 28, 1960 OPEN BEACHES OSWALD WEST’S MEMORIAL Oswald West, who served as Governor of Oregon from 1911 to 1915, is dead at the age of 87. Death came quietly as he slept. But Oswald West’s life, especially in his active political years, were far from quiet. Few governors in Oregon’s more than 100 years of statehood left such a mark on the state’s history as he did. he was fearless. he was a fighter.

he made contributions to the State of Oregon that will benefit its people for generations. He kept the political scene spirited with his pungent observations and by his unpredictable actions. consider the Copperfield incident of 1914. Copperfield was a little mining town on the west bank of the Snake River in Oregon, with a history dating to 1900. Around 1914, when Oswald West was governor of Oregon, Copperfield’s reputation as a wide open town with bad morals was a sore spot in the political picture. Fact is, little Copperfield virtually defied the great state of Oregon. Governor West did not send in his strong men to quell the Copperfield insurrection. With the entire town on the Snake alerted, it was a girl, miss Fern Hobbs, who showed up. she was Governor West’s secretary. she was double armed with determination and a signed declaration of martial law to clean up morals of the place. Of course, historians do not fully agree as to her success: A series of fires in the little town about cleaned up the entire place in a short time. But the incident brought Governor Oswald West of Oregon into the national spotlight. Governor West, as he was known to his friends even in the sunset years of his eventful life, was no stranger to Central Oregon, or to Bend. His association with the temporary ill-fated North Canal Company in constructing the original Crane Prairie Dam on the upper Deschutes River brought him to Bend on many occasions. In later years he continued to visit Bend, and frequently dropped into the Bulletin office, generally to chat about conservation matters. Oswald West sought no memorial for his long service to Oregon. But events have shaped such a memorial. That memorial will forever be the broad expanse of public beaches on the beautiful Oregon coast. he preserved those beaches for this generation, and for generations of Oregonians yet unborn. Friendly Oswald West’s deeds will long live to inspire those who follow his example of generous public service. FOR THE WEEK ENDING AUG. 28, 1985 I guess I’ll always have a soft spot in my heart for the Bend High School Class of 1965. Members of the class enlarged the spot a little more a few days ago. Our daughter Janet was a member of the class, so Nancy and I knew a large number of its members. we lived in two different sections of Bend by the time graduation ceremonies came around in 1965. Lots of members of the graduating class had been in our home at one time or another. we knew them, and knew the parents of many of them. (The Bend area was not so large in those days.) When the class held its 20th reunion in mid-August it invited the parents. I went. I had a good time. no I had a bal-l-l-l-l-l-l. And it was obvious the graduates enjoyed themselves as much. I had a good time because I saw so many fine young men and women I had not seen for such a long time. the young women were attractive. the young men, or a surprising number of them, were handsome. It’s obviously much more fun for me to attend a 20th class reunion than it would be to attend a 50th, which I will do in three years. Members of the Class of 1965 came from all over. Some of them live in the Central Oregon area, of course. And a number live in the Portland area, or down the Willamette Valley. But others came from Washington and California and Idaho. One came from Saudi Arabia. Some of the teachers came. I had a chance to visit with Tom Winbigler and Ken Cooper and Laurie Smith Frye, none of whom I had seen for many years. Those graduates were involved in a variety of activities. Half a dozen were medical doctors. there were lawyers and CPAs and contractors and sawmill workers and housewives and secretaries and bankers and people who ran their own businesses. There were other ways n which they varied. One of the members — perhaps more — was a grandmother. two others were mothers of children less than a year old. One member — he wasn’t able to come — was in prison in California. Some were military veterans of the early Vietnam days. others had developed religious principles which kept them out of that war. Some were political conservatives, surprisingly conservative I thought for men and women so young. One unreconstructed liberal whose ideas had not changed much in 20 years must have been lonely; his pleas for action fell mostly on deaf ears. few wanted to talk about serious matters. Instead they dwelt on memories, memories of the good old days. there must have been bad days 20 years ago but no one remembered them. they remembered the fun things and the funny things. Sometimes it seems as if the world is nothing but misery and trouble. But sometimes, too, we can go back in time, back to happier days when misery and trouble and problems must have existed, but which we cannot now remember. That’s what the class of 1965 did that August evening. And I was delighted that its members let me share some of their joy. Compiled by Don Hoiness from archived copies of the Bulletin at the Des Chutes Historical Museum. comments powered by Disqus 100 YEARS AGO

Hi, this is my code Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDb.OleDbConnection 'Create connection with DB Dim sSQL As String 'SQL Query Dim cmd As OleDbCommand 'To execute SQL command Dim chk As DataTable 'Check whether table exists or not. 'Creating connection con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = D:\bill.mdb" con.Open() 'Opening connection to DB MsgBox("A Connection to the Database is now open") sSQL = "DROP TABLE itemcount" cmd = New OleDbCommand(sSQL, con) cmd.ExecuteNonQuery() 'Creating a new Table '***** START ***** sSQL = "CREATE TABLE itemcount([itemname] TEXT(5), [itemcnt] NUMBER)" cmd = New OleDbCommand(sSQL, con) cmd.ExecuteNonQuery() '***** END ***** 'Code to check whether the table exists or not '***** START ***** chk = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, "itemcount"}) If chk.Rows.Count <> 0 Then MsgBox("Table " & chk.Rows(0)!TABLE_NAME.ToString & " Exists") Else MsgBox("Table does not exist") End If '***** END ***** ('Code for selecting a particular data from database '***** START ***** sSQL = "SELECT itemcnt from itemcount WHERE itemname = 'a'" cmd = New OleDbCommand(sSQL, con) cmd.ExecuteNonQuery() MsgBox(sSQL) '***** END *****) con.Close() MsgBox("The Connection to the Database is now Closed") End Sub End Class My Database name is bill.mdb stored in d:\ drive table1 name:menu schema : (item_id NUMBER, item_name TEXT) table2 name:trans schema: (billno NUMBER, name TEXT, qty NUMBER) i have to create a new table itemcount (that i have done in my coding above) Table 3 name:itemcount schema:(itemname TEXT, itemcnt NUMBER) In this all i want is READ the TRANS table and from it read the first record of field NAME and take that in a temp string if temp name already has that name in its itemname then icrement the itemcount by 1 else insert new record in itemname field and set the itemcnt = 1 All this in VB.NET PLZ PLZ PLZ HELP ME OUT Thanks in advance. oh come on these comments are written by me only and this a small part of my project where no marks will be gained. stop giving such stupid replies.

---

hi all can u find out whats the problem with the following code as update query is not working in line number : Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDb.OleDbConnection 'Create connection with DB Dim sSQL As String 'SQL Query Dim cmd As OleDbCommand 'To execute SQL command Dim chk As DataTable 'Check whether table exists or not. 'Creating connection con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = D:\bill.mdb" con.Open() 'Opening connection to DB MsgBox("A Connection to the Database is now open") sSQL = "DROP TABLE itemcount" cmd = New OleDbCommand(sSQL, con) cmd.ExecuteNonQuery() 'Creating a new Table '***** START ***** sSQL = "CREATE TABLE itemcount([itemname] TEXT(5), [itemcnt] NUMBER)" cmd = New OleDbCommand(sSQL, con) cmd.ExecuteNonQuery() '***** END ***** 'Code to check whether the table exists or not '***** START ***** chk = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, "itemcount"}) If chk.Rows.Count <> 0 Then MsgBox("Table " & chk.Rows(0)!TABLE_NAME.ToString & " Exists") Else MsgBox("Table does not exist") End If '***** END ***** 'Code for selecting a particular data from database '***** START ***** sSQL = "SELECT name FROM trans" cmd = New OleDbCommand(sSQL, con) Dim reader As OleDbDataReader = cmd.ExecuteReader() While reader.Read() Dim tempitem As String tempitem = reader.GetString(0) sSQL = "SELECT itemname = '" + tempitem + "' FROM itemcount" cmd = New OleDbCommand(sSQL, con) Dim itemFound As Integer itemFound = cmd.ExecuteNonQuery() MsgBox("Temp Item : '" + tempitem + "' ") If (itemFound = 0) Then 'INSERTION QUERY MsgBox(" In the insertion area ") Dim sSQL2 As String 'PROBLEM AREA STARTS sSQL2 = "INSERT INTO itemcount(itemname, itemcnt) VALUES ('" + tempitem + "',1)" cmd = New OleDbCommand(sSQL, con) Dim chek As Integer = cmd.ExecuteNonQuery() If (chek > 0) Then MsgBox("Sucess") Else MsgBox("Failure") End If 'PROBLEM AREA ENDS 'OUTPUT IS ALWAYS (FAILURE) HENCE IT NEVER GOES IN THE ELSE CONDITION Else 'UPDATE QUERY MsgBox(" In the Update area ") Dim sSQL2 As String sSQL2 = "SELECT qty FROM trans WHERE name = '" + tempitem + "'" cmd = New OleDbCommand(sSQL2, con) Dim val1 As OleDbDataReader = cmd.ExecuteReader() Dim val2 As Integer val2 = 1 Dim sSQL3 As String sSQL3 = "UPDATE itemcount SET itemcnt = '" + val2 + "' where itemname = '" + tempitem + "'" cmd = New OleDbCommand(sSQL3, con) cmd.ExecuteNonQuery() MsgBox(cmd) End If End While '***** END ***** reader.Close() con.Close() MsgBox("The Connection to the Database is now Closed") End Sub End Class Help me out guys

---

I have touched on VB.net and SQL back in school but it has been a long time since and i never really had an 'Introduction to programming' type course - i was pretty much thrown in at the deep-end and i don't fully understand the background and basics to it all. eg classes, standards and syntax. What kind of tools, websites and projects would people recommend using? Most of my lessons at school were things like creating a simple calculator, creating a food menu/bill total tool, etc. A great place to start (especially with .net being OO) but i want to try moving on from this.

---

The way I am filtering my (subform) datasheet is by manipulating its SourceRecord property. "SELECT x, y, z FROM [table] WHERE [filter]" I find it is easy to filter data that is organic to the table. For example: =TABLE 1= [ID], Project Name, ProjectStatus [1] Project A, Complete [2] Project B, In Progress [3] Project C, In Progress =TABLE2= [ID], PersonName [1], John [2], Bill =Table 3= 'relationship table [ProjectID], [PersonID] [2], [1] 'shows that john works both projects (B & C)) [3], [1] [2]. [2] 'bill works only project B. I find that I can filter the status of the projects because it is a part of the data. Yeah, I can define status by a value, but let's say I define it as text. I can filter it with WHERE ([table].ProjectStatus = 'Complete'). What if I want to filter by all the jobs that John has done? How do I do that? Now, I know I can create a recordlist "SELECT * FROM [Table3] WHERE PersonID = 1" This yields all the projects that John is affiliated with. But then how do I use this filtered Table 3 to filter Table 1? I want the result to show all the jobs that John has completed. If there is a different method, or I'm taking the long route, please let me know. Thank you.

---