Search results

  1. B

    Answered Browse Open Query on temp table or bare table?

    in fact yes you are totally right. I will try to build it that way :) Thank you I consider my Question Answered :) Thank you all for your help as always
  2. B

    Answered Browse Open Query on temp table or bare table?

    Thank you @Rob Fitzpatrick for the idea of field list. @TomBascom, I have another question on the matter that is related to the fact of using a temp-table or to be directly using the DB. In term of user flow for using the app, when I'm directly connected to the DB the loading time of the data...
  3. B

    Answered Browse Open Query on temp table or bare table?

    Yes sorry, I miss led you. The application I'm working on is a dashboard for sales management. I will display data about ordre quantity stock etc... this value are updated other time by other user action. It's that kind of dynamic data that could change other time and be refreshed while...
  4. B

    Answered Browse Open Query on temp table or bare table?

    Hello, I missed this info. I'm only reading and didn't planned to let the user update the data so all the request will be in NO-LOCK.
  5. B

    Answered Browse Open Query on temp table or bare table?

    Hello Guys, I have a performance/best practice question: When doing an open-query for a browse I choose to go with my database table directly instead of compiling all the data in a temp-table first and display them after. It allows me the following: 1. No loading time 2. live update of data...
  6. B

    barcode 128

    I don't use a printer i use it to generate the chain of character to translate a standard text to a 128 code and then in a reporting product like Crystal Report I use a barcode 128 font for this value. After that the printer I selected by the user
  7. B

    barcode 128

    I have a function ready to go that is working for us to generate barcode 128
  8. B

    Question Realese Buffer

    I miss this part. I did an app to transfert stock that work following this steps: 1. The user keyed a product reference -> I load the product BUFFER 2. The user select a stock value to be transfered -> I load the line in a BUFFER 3. The user select an area an place -> I load the line in buffers...
  9. B

    Question Realese Buffer

    Hello Guys, Another question for today . I maked a program with global BUFFER . On a certain button I want to release the buffer like if I tryed an available myBuffer i want to get a NO . I for now use the RELEASE statement . Thanks in advance.
  10. B

    Answered Change Browse column format at runtime

    Thanks @Osborne, I understand the issue and I will go for the row-display event :D
  11. B

    Answered Change Browse column format at runtime

    Hello guys, I want to change at runtime a colonne format for my browse. At the start I set in my BROWSE Display: myTable.myfield FORMAT ">>>>>>>9,99" At runtime I need to display data that are only integer. I tried to do this: DEFINE VARIABLE hCol as HANDLE. hCol =...
  12. B

    ABL DatePicker

    Hello Cecil, I would be really happy to saw that :)
  13. B

    Answered Is it possible to trigger a popup-menu

    thank you @Osborne. I might use this trick. I foud another way to do what I was needed. But I will continue to look on that. If I were able to generate the popup-menu at the start of the main window, it wouldn't be an issue, but i'm not so show must go on :)
  14. B

    Answered Is it possible to trigger a popup-menu

    Hello guys, I'm back with another question. Is it possible to open a popup-menu without a right click on a widget? To be more precised, I have a main windows and don't have her source code. But I'm able to add a buton and to launch a procedure by this button. In this procedure (that you will...
  15. B

    Answered Query performance

    I see and thank you for the point made it gives me more idea Thank you @TomBascom for the detailled answer as always. Also I understand why taking this automatism is important. Thank you all :)
  16. B

    Answered Query performance

    Yeah true I was aming for Andre42. Missing some sleep on this one. So by convention keywords should be in lower case ? Yeah my question was mainly about the querys . @TomBascom what would you do instead of embedding a call of NUM-ENTRIES() in a DO loop for this cases ?
  17. B

    Answered Query performance

    @Cringer what is the difference between what you wrote and what @andre42 wrote ? I usually go with a for each loop than creating a query and navigate through it ? What is it changing ? Thank you in advance :)
  18. B

    Answered Query performance

    Hello everyone, It's been a while. I hope you are all doing well. While making some new app, I was asking my self this: I have a table of purchase order that as the type of purchase ordre in index. I want to display 3 differrent purchase order. So I was thinking of two solution: 1. DEF VAR...
  19. B

    Answered Saving a structuref procedure take to much time

    Hello, good news @Patrice Perrot is the winner. I found one procedure where I was calling temp-table field without the temp-table name before. After correcting it, it compile perfectly well. Thank you again for all your help :) I will work on rebuilding my code with POO . Best Regards,
  20. B

    Answered Saving a structuref procedure take to much time

    thank you @tamhas for your advice. I will tried to do it
Back
Top