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

    Select without an order by clause doesn't return the same order as the database

    Thank you all for all your tips. I ended up doing Mike's last suggestion and it works great! Thanks to all of you for taking some time to help me. I really appreciate it ! Melanie
  2. MelanieParent

    Select without an order by clause doesn't return the same order as the database

    You were correct, I was talking about a Foxpro DBF. When I try to order it by recno() it tells me that Queries of this type are not allowed. (It's a multiple table query). I tried to include the product database recno number into my query but it wouldn't work either (product.recno()as rec)...
  3. MelanieParent

    Select without an order by clause doesn't return the same order as the database

    Hello, I have a select command that gets all the products from an order and I want to list them in the order they were entered in the database. There is no ORDER BY clause. I'm wondering why it doesn't list them that way. When I print the order, it's correct, however when I print the invoice...
  4. MelanieParent

    Foxpro 2.6 tables

    Thank you so much for your help, I'll try to work on that today and make it work. And I know that I should switch over to the new versions... I do have have VFP 9.0 on my computer and haven't had time to look a lot into it. I tried converting one screen from 2.6 to VFP 9.0 and I think I'll be...
  5. MelanieParent

    Foxpro 2.6 tables

    Yes, it is in FoxPro 2.6. I'll try the browse window, I thought you couldn't add to it only see the content of the table that's why I didn't try browse (and not really familiar with it also). Thanks !!
  6. MelanieParent

    Foxpro 2.6 tables

    I have an order entry screen that looks a bit like that : prod(1) description (1) qty(1) price(1) prod(2) description(2) qty(2) price(2) ... For 13 lines. So I have quite a few arrays. The company wants to be able to enter up to 30 products on an order. So I would like to change it to...

Part and Inventory Search

Back
Top