Search results

  1. 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...
  2. 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
  3. B

    barcode 128

    I have a function ready to go that is working for us to generate barcode 128
  4. 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...
  5. 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.
  6. B

    Answered Change Browse column format at runtime

    Thanks @Osborne, I understand the issue and I will go for the row-display event :D
  7. 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 =...
  8. B

    ABL DatePicker

    Hello Cecil, I would be really happy to saw that :)
  9. 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 :)
  10. 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...
  11. 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 :)
  12. 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 ?
  13. 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 :)
  14. 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...
  15. 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,
  16. B

    Answered Saving a structuref procedure take to much time

    thank you @tamhas for your advice. I will tried to do it
  17. B

    Answered Saving a structuref procedure take to much time

    Hello, I will keep this in mind and changed them if I found them. Best Regards
  18. B

    Answered Saving a structuref procedure take to much time

    Thank you for your answer and your help on this matter @Rob Fitzpatrick Best Regards
  19. B

    Answered Saving a structuref procedure take to much time

    I understand for the runtime and will see what I can do. For the number of temp table I was thinking of separating the application in multiple procedure one for each output file. I will correct this part. Why is it to avoid ? Best Regards and thank you for helping as always .
  20. B

    Answered Saving a structuref procedure take to much time

    So the check syntax inside a procedure of this procedure is pretty fast, instantaeous if i can say. I think it could be related to the number of temp-table I use (more than 10) and maybe the enormous quantity of data I charge inside. I never did such a program with this much of temp-table...
Back
Top