Recent content by holdemfoldem

...I'm writing an app in VB 6 connecting to a main frame DB2 data base and wish to order the results of a select statement by two fields, SCHLYEAR and TERM, corresponding to the school year and the term, (ie: Fall, Spring, or Summer). What keeps me from simply using: "SELECT FIELD1, FIELD2...

Thanks, dbMark! Based on what you listed, I am working with either dBase IV or V files. Hopefully this should be sufficient for my supervisor. Just in case, though, is there a way to distinguish between dBase IV and dBase V files, once you've established you have one of the above? Thanks for...

Thanks for the reply, Tviman. I have opened several .dbf files in VB and displayed the asci representation of the first 4 bytes of the files. I've had varied results as follows: 139 - 100 - 4 - 6 3 - 100 - 3 - 19 3 - 100 - 4 - 25 139 - 100 - 1 - 31 When you refer to the first byte of the...

I am working with some .dbf files and my supervisor wants to know what version they are. Presumably they're dBase IV, but is there some sort of utility I can run which will open the files and determine what version of dBase they represent? Thanks ahead for help!

TomasDill, Thanks! Now - this is really embarassing! How do you access the FAQ? I can't find any links for it, just links for forums. I have tried typing in, "How to organize SUM() for character field in SQL Server SELECT query", "sum()", and "faq" in their...

Whoops! I said, "item name unique" in my last post. Obviously, this is NOT the case, since the whole point is to group the rows with the same item name! My bad! :^\

First, let me thank one and all for your replies! This is my first post to this board, and I am very impressed with the eagerness and technical expertise expressed. Second, let me applogize if I posted to the wrong board. I don't think I did, but let me explain a bit further: I am currently...

To get the sum of a given column for a group of rows sharing the same column value, you do the following: SELECT ccustno, sum(nbalance) as totalbalance FROM arinvc GROUP BY ccustno My question: How do you concatenate the string values of a given column for a group of rows? I...