Search results

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.

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

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

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

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

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

DEF STREAM velorob. OUTPUT STREAM velorob TO "d:\velo\veloroba.txt". DEFINE VARIABLE centrala AS INTEGER NO-UNDO. centrala = 0. FOR EACH komdet WHERE komdet.vrs = "centrala" AND komdet.opis = "0522", EACH komit WHERE komit.sifkom = komdet.sifkom, EACH rromat WHERE rromat.sifkom...

Hello, is it posible to selecto some rows with condition where, and delete rows until sum of specific colum in rows is reach defined value. FOR EACH tablename WHERE tablename.date EQ /mm/dd/yyyy AND tablename.somthing > 0. DELETE tablename (UNTIL sum of deleted tablename.somthing = X)...