Search results

  1. V

    Question For Each {1} - Pass table name as argument

    Thank you it's work... I need your opinion on my project. It's in Syteline ERP. "Item" field is a primary key in the system. This field is on hundred table. So we can't change item name as soon as a transaction is made. My program does this: - Search all table that have the field "item" -...
  2. V

    Question For Each {1} - Pass table name as argument

    I try b:buffer-field('CustNum'):buffer-value() = "FOO". but I've always got a NO-LOCK error ...?
  3. V

    Question For Each {1} - Pass table name as argument

    Is exist a static way to past a table name as a variable?
  4. V

    Question For Each {1} - Pass table name as argument

    How do you update a value in this case?
  5. V

    Change item name ine Syteline

    Ok I'll try it in my dev server. Thank
  6. V

    Change item name ine Syteline

    So to build my script I need to find all table who include "item" field. The user enter the old name and the new name my script look in every table for this old name and change it for the new one. What did you put exactly in your txt file? Only the Item table data or all the tables data?
  7. V

    Change item name ine Syteline

    Thank you Darren, Our need is more drastic, I want to change the master name itself. In fact we want to implement a new nomenclature and keept all the history. Example, we have the item master "Item01" we want to call it "Product01" and all the order or job history are now "Product01". Vincent
  8. V

    Change item name ine Syteline

    Hi, I want to change the name of items on my Syteline ERP. But I can't because the name is liked every where in the progress database. I'm asking if I found all the table with item field and change the name on each table is that can work? Thank
  9. V

    Question Past Temp-table between files

    Yes that is... Thank you guys. It's the first time I have to play with handle, I learn a lot with this case. I hope all will work find for the rest of my procedure. Thanks
  10. V

    Question Past Temp-table between files

    Why only "MESSAGE" work. I try to stock value on variable and Display it and that don't work. here the code... test.p DEFINE VAR h-table AS HANDLE. DEF NEW GLOBAL SHARED TEMP-TABLE t-test FIELD c-test AS CHAR. CREATE t-test . ASSIGN t-test.c-test ="eee". CREATE t-test . ASSIGN...
  11. V

    Question Past Temp-table between files

    Ok it's work... I use MESSAGE instead Display.
  12. V

    Question Past Temp-table between files

    The do-while only loop 1 time but in the call procedure I add 2 entry on the temp table. As if the table are empty.
  13. V

    Question Past Temp-table between files

    Everything seems to work but how do I get the values? I try DISPLAY lv-Buffer:BUFFER-FIELD(1):BUFFER-VALUE. But it's empty?
  14. V

    Question Past Temp-table between files

    The TABLE-HANDLE passes the HANDLE of the Temp-table but how can I use it... This Handle only alow me to add fields not to query the temp table?
  15. V

    Question Past Temp-table between files

    Do I need to use handle or something like that?
  16. V

    Question Past Temp-table between files

    Hi Here my need, I want to create a file (eg proc.p) with in input parameter a temporary table. So I can call this file in another program. The table that is passed as a parameter can be different depending of the program that call it. The only thing I got is to pass table in parameter but it...
  17. V

    Error Getting error 98 with Errno 13 when using an OUTPUT TO statement

    Probably my Progress version is to old (9.1D) because it don't understand CATCH.
  18. V

    Error Getting error 98 with Errno 13 when using an OUTPUT TO statement

    Sorry guys I don't recive email from the forum to notify me new post... What you mean Stefan by "You can CATCH errors from OUTPUT TO". How?
  19. V

    Error Getting error 98 with Errno 13 when using an OUTPUT TO statement

    Hi, I've got this error: Error 98 errno 13 when I using output to. I know why, it's because the file is open by someone and he propably lock it. What I want it's be able to output to an other file in case the file is already open. Can some one help me? Thank
  20. V

    Importe CSV file

    thank you
Back
Top