Search results

  1. V

    INIT value

    Thank you, for answer and advice.
  2. V

    INIT value

    Hi, How can i set init value for variable to be some other variable, and how to set init for date var to be today + 1. DEF VAR a AS DATE INIT TODAY + 1. DEF VAR b AS DATE INIT a. OE 10.2.
  3. V

    Auto connect server database

    Thank you Rob, that is what i need.
  4. V

    Auto connect server database

    Yes server is started, i can connet to database from procedure editor with RUN comand. Im trying to start procedure with prowin32.exe, and i whant that procedure to RUN on click some .p file. Is that even posible? Sorry for my english, its my second language.
  5. V

    Auto connect server database

    Still got same error. With: CONNECT -db DB -ld DataBase -H 192.168.116.101 -S 5033 -U user -P pass. RUN D:\pro\test.p.
  6. V

    Auto connect server database

    When i RUN this code from client with "F2" key its all OK i got connect and output for test.p But when open with prowin32 i got error There is no server for database path to the file (1432). Any help? CONNECT -db //192.168.116.101/u/DB.db -ld DataBase -H 192.168.116.101 -S 5033...
  7. V

    Last change

    Is there any option to see what table/field has changed/update value last in DB?
  8. V

    Update fields X times.

    Thankyou , I just add if updatecounter > updatelimit then leave. So this work fine. Thankyou again very much.
  9. V

    Update fields X times.

    Exectly what I need, but this do it twice it dont stop on 150. it goes to 200, because second time when start update updatecounter is 100. i need after each update to count updatecounter. Thank you very much.
  10. V

    Update fields X times.

    Is it posible to update some fields X number of times. Let say I have 100 rows each row have field qty and i want to update that field by -1 150 times total, so i need procedure to go 1 time each row UPDATE qty = qty - 1, and second time to stop on 50th row so i got total qty = qty - 150. 150...
  11. V

    Accum total by...

    Thankyou very much, thats what i need. :)
  12. V

    Accum total by...

    Thx Osborne. I have one table orders with 3 columns: CustNo. ItemNo. ItemQTY. 1000 600 50 2000 500 45 3000 600 50 1000 600 50 2000 500 50 1000 500 30 what i...
  13. V

    Accum total by...

    Is it posible to display sum of all orders by Item No. by Customer No. Accumulate quantity (total by item no. by Customer No.) Display Accum total by item No. by customer No. (quantity). I need to get total of sold items group by each customer and each item. If you understand me, please...
  14. V

    FIND FIRST

    You are apsolute righ, i ended up with unsuported ERP software based on OE 10.1c and i try to learn some basic stuff by my self and google. Im not programmer i have some sql expirience but not even close to do some complicated stuff. My problem is: in store we have goods, let say 1500 pices...
  15. V

    FIND FIRST

    I need to update value on table2.field1 with (first found in table2) with conditions in table1 (table1.brnal = table2.brnal)
  16. V

    FIND FIRST

  17. V

    FIND FIRST

    Can you post code, i try this method and dont work for me DEF BUFFER rom FOR rromat. FOR EACH ralmat WHERE ralmat.brdok BEGINS "pft", EACH rromat WHERE romat.brnal = ralmat.brnal. FIND FIRST rom WHERE rom.izkol > 20. DISPLAY rom.izkol. END.
  18. V

    FIND FIRST

    Is it posible to get this work FOR EACH table1, EACH table 2 where table2.field1 = table1.field1. FIND FIRST table2 IF table2 AVAILABLE THEN UPDATE table2.field2 = somthing. I know this procedure dont work because cant use FIND after FOR EACH. I hope you guys understand...
  19. V

    Show SUM

    customer_table order_table item_table customer_id customer_name item_id item_amount customer_id ord_date item_id item_name...
  20. V

    Show SUM

    Thanks, EXPORT outside the loop did job done. Can you put Last ( ) or Last-OF () in my script, i dont know how to do it. Thx again.
Top