Search results

Hi to all. I have not a good experience in consuming web services. I have a quite good basis in 4GL. I use Progress 10.2.b version in Unix Environment. Reading some articles in www.progress.com and in this useful site, i was able to create a custom demo.p that consume a web service. In this...

Thanks for your kind reply. My post is very old but i appreciate your answer. So i have a different way (it seems very performant) to do that. Thanks again.

Thanks for yoir kind reply.

Thanks a lot for your answer. I will try to rewrite an old .p with write-xml ... Will see , records envolved are not so much ... I will inform you about it. Thanks.

Thanks for your answer. I think i will rewrite an old procedure wrutten in X-DOM with WRITE-XML method. I think it should be better . it is easier to do that.

Hi to all. I need to create an XML document , reading data from a DB Progress 10.2.b version. I read tutorial and i learn there are 3 ways to create an XML file inside 4Gl or WebSpeed Program. (I need to create an XML via WEBSTREAM with a series of WEBSPEED programs.) 1) SAX PARSER (I have...

Hi Cj_Brandt. Thanks for your kind reply. Yes i read that IFNULL is used to determine if a filed is NULL or NOT. I need to use IFNULL to force a value of a field but without doing an UPDATE.. I am using SSIS 2008 r2 to pull data from a Progress DB.. I have some date fileds with NULL value and i...

Hi to all. I need to pull data from PROGRESS DB versione 10.2.b to a SQL SERVER Table using SSIS of MICROSOFT. I connect using ODBC Driver Client Access 10.2.b All is ok but i need an help to do the SQL Query. I need to obtain ONLY one row from multiple records. I need to obtain ONLY the...

Hi to all of you. I need an help about SQL Function IFNULL I need to test if a date is NULL, if not i need to obatin that date in the field, otherwise i need to put a dummy date.. Ex. IFNULL (prezzi.duc , '2000-01-01') I write from Italy , is it correct to put '2000-01-01' to have...

Hi Rob. Many thanks for your kind reply. I think you are right and the best solution is to store all products images in our file system (We have a good NAS Serverthat can do it). So we need to store images in a table for example named 'Images' with fields as ProductId,,Description...Path...

Thanks to all of you for your kind reply. Yes Cringer ,,,my code was terrible ...it was only a pseudo code...to have an example how to store an image..only this !!! You are really right !!!! Yes i think the best solution is to create a table with only path and name of images (as Post of Rob...

Hi to all. I need to import a thirdy party products catalogue. I did not have This catalogue yet...but thirdy party told me it will contain product code, ean code , product image. I read about BLOB field ...so i will prepare a progress table (Versione 10.2.b i have) with a Blob field. I read...

In short words , i'd like to do the same SQL Command (sql server) in SQL ODBC Progress OpenEdge ..IS IT POSSIBILE ??? WHILE EXISTS ( SELECT * FROM table WHERE <condition to update>) BEGIN SET ROWCOUNT 1000 UPDATE Table WHERE <Condition to update> SET ROWCOUNT 0 END. Many thanks.

Hi Tom. I did tests with 10.2B ...the same ..i got error i posted. I read documentation (the same you kindly posted) but i did not find anything of useful to solve my problem. My problem is to find a way to read only a number of records , doing a loop , to override the problem of LOCK ...

Hi RealHeavyDude thanks for your answer. Yes i know with ABL how to use TRANSACTIONS. My problem is with ODBC ...i will read attachment you sent me. It is a third part company that try to use an UPDATE over our DB Progress..and they cannot o different way to update data. I 'd like to learn...

Hi Mr To Bascom. I have 10.2.b OpenEdge Version...is it possibile according your opinion ??? Do you know where can i find useful examples or guide about it ??? Regards.

In short words , i'd like to do the same SQL Command (sql server) in SQL ODBC Progress OpenEdge ..IS IT POSSIBILE ??? WHILE EXISTS ( SELECT * FROM table WHERE <condition to update>) BEGIN SET ROWCOUNT 1000 UPDATE Table WHERE <Condition to update> SET ROWCOUNT 0 END. Many thanks.

Hi to all... What about if i need to update 1000.000 records in one time by SQL via ODBC ??? I was not able to do ... A thirdy part program need to execute UPDATE table SET field = 'value' over our table.. If they do that , they receive a LOCK ERROR, even if -L parameter on DB is high value...

Good morning Mr. TAMHAS .. I have a similar problem with numer of rows .. My problem is to UPDATE only a certain numbers of rows of a PROGRESS Table of 1.000.000 records... A third party program need to connect to our DB Progress and update a Progress Table .. update table set field =...

Hi Stefan. Thanks for your advice...i do not know anything about SAX Parser ..i 'll try to study it.. Thanks again ..have a good day.