...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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.