Other people in the office are OK with it? Put a microphone there and amplify the singing so everyone can enjoy it.

I already have a PhD -- Permanent Head Damage. I feel dizzy now. I also believe this can be solved by a simple expression.

I noticed the "Joke" icon. I give you a 5. It is tricky so I think the original post is a pretty good beginner's question. My daughter asks "why" a lot. It's a learning process.

I think d@nish's solution is better for your case, even though you found my inner join to be new and helpful to you. I am sorry I don't have a book or website to recommend to you on SQL. I learned something about SQL by reading an Oracle manual on SQL*Plus (which has lots of very interesting examples) about 20 years ago (in 1990) when I was working on a project for a friend. I moved a few times (to different countries) ever since and lost that manual. It was for an old version of Oracle anyway (which ran on VMS with no graphical user interface.) The new Oracle manuals seem to have nothing similar to the one I read. Your best bet is to find a good book on SQL.

You can use a join similar to this one:

select a.ticker from table as a inner join table as b
on a.ticker=b.ticker and a.price>b.price
where a.date='11/20/2009' and b.date='11/17/2009'
group by a.ticker;

There are information on dbf file structures available on the web. I suggest you do a search to find the info.

I am glad I could help. I like sqlite. My electronic document manager uses sqlite and it is much faster than my previous version (which used Microsoft Access).

AVE is wrong. You should use AVG.

It looks like you created this file using some other editor, and you used some text encoding that the editor you are using now cannot understand. You need to open it in your previously used editor and clean up the offending text to solve the problem.

If you tell us that the fourth field is the parent's ID (and the first field is its ID), then we will have an easier time trying to figure out what you want.

modified on Tuesday, December 15, 2009 10:57 AM

I have no idea what nitrous oxide is but it's in the piece of news (the link in the original message). It says "A hybrid rocket motor burning solid propellant with nitrous oxide then will boost SpaceShipTwo onto a steep trajectory to an altitude of more than 62 miles." Looks like it's not the liquid fuel that's used in space shuttle.

I suggest you merge the two dialog boxes into one model dialog box, for example, in a side-by-side way. When you want to "dismiss" any one of the original dialog boxes, just hide the appropriate side (by using some resizing and/or moving tricks).

One solution is to build an index to the records in the file.

You can listen to the other peoples' advice to use ExecuteNonQuery(), etc. However, I am going to just talk about your piece of code. The adapter maintains four different query commands internally. One of them is the update query you implicitly called when you call myDataAdapter.Update(...). However, in order for it to work, the adapter has to know how to correctly construct the update query internally. What you need to make this program to work is to add the following line to tell the adapter how to construct the query internally: OleDbCommandBuilder builder=new OleDbCommandBuilder(myDataAdapter); Add the above line right after the line: myDataAdapter = new OleDbDataAdapter(myAccessCommand); After that, your Update(...) call should work.

There is not even a combobox involved. Read the original question carefully before you give an answer!

Your program ran without a problem on my system. It never reached the break point.

First of all, thanks for all who replied. I was given those Access tables and was asked to do that "horizontal join". I did not design the database, so I have no control over the design of the tables. For example, there is no primary key in those tables. Had I designed them, I would probably put a rowid field there as the primary key. The person who asked me to do this needed the result table "so that he can load the table in GeoMedia to map the points." I don't know the details about GeoMedia. I just do whatever he asks me to do. He is my boss. The real requirement is more than what I presented here. He actually asked me to horizontally join more than two tables. Actually the number of tables are unknown at design time. I am actually writing a program to do this. However, I want a query to simplify my program. I was hoping that I can avoid the result table creation part because I don't want to deal with Access data types. If a query is possible, I will just use "select ... into ..." to create the result table, instead of using "create table ..." because to construct the create command I have to find out the fields' info (name and type) for the result table. Thanks again for all your replies.

Is part of your project's files on a different computer (a network drive)? If so, is your computers time much different from the remote computer? Just a thought.

My friend called his wife at work one day telling her that his fingers were cut by the mower blades because he was trying to clear the clogged discharge port while it was running -- he tied the handle with a rope to keep it running. The doctors had to try to reconnect the broken fingers. Now do you think the sign is necessary? This person has a PhD degree in computer engineering, and works for a big computer company in Houston, TX.

Regarding SP2 and SP3: I did install SP3 first, believing that it contains SP2. However, for some reason SP3 could not be successfully installed. The error message told me that SP2 had to be installed first (which is contrary to what I thought). That's why I installed SP2, then SP3. I have USB2 working. I just wanted to save a copy of the driver so later if it happens again, I just need to pull out the archive to install the driver, instead of relying on a network connection and the availability of the driver somewhere in Microsoft's web site. Not a big deal. Thanks for your help.