Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. holdemfoldem

    Ordering using poorly formatted column data...

    ...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...
  2. holdemfoldem

    Determining the .dbf file version

    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...
  3. holdemfoldem

    Determining the .dbf file version

    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...
  4. holdemfoldem

    Determining the .dbf file version

    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!
  5. holdemfoldem

    I need something similar to "Sum()" but for strings.

    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...
  6. holdemfoldem

    I need something similar to "Sum()" but for strings.

    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! :^\
  7. holdemfoldem

    I need something similar to "Sum()" but for strings.

    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...
  8. holdemfoldem

    I need something similar to "Sum()" but for strings.

    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...

Part and Inventory Search

Back
Top