tag:blogger.com,1999:blog-14934996.post8474548559276831286..comments2023-08-26T01:35:40.671-07:00Comments on Bruce Armstrong's blog: Reading and writing a blob in chunksBruce Armstronghttp://www.blogger.com/profile/06531990923901345957noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-14934996.post-9748878981102351142017-05-01T13:34:53.112-07:002017-05-01T13:34:53.112-07:00Sorry, I haven't. You might want to post over...Sorry, I haven't. You might want to post over on Appeon's forums and see if someone there has:<br /><br />https://community.appeon.com/homeBruce Armstronghttps://www.blogger.com/profile/06531990923901345957noreply@blogger.comtag:blogger.com,1999:blog-14934996.post-79343572091218427792017-05-01T12:50:51.938-07:002017-05-01T12:50:51.938-07:00Bruce, Have you every converted this code to work ...Bruce, Have you every converted this code to work with APPEON? I tried to use it the way it is and it does not work. I like that it chucks up the data so I can display what has been read back to the user. I have to deal with 400+ meg files. (Using Oracle 12c, PB12.6 and APPEON 2015)<br /><br />Regards,<br />RonAnonymoushttps://www.blogger.com/profile/14538475231895288824noreply@blogger.comtag:blogger.com,1999:blog-14934996.post-81055818745556669742010-06-22T14:57:35.000-07:002010-06-22T14:57:35.000-07:00Mi problema es el siguiente, quiero leer la huella...Mi problema es el siguiente, quiero leer la huella dactilar y guardar la informacion en un la BD para su futura identificacion.<br><br>Utilizo SQL Server 2005, estoy programando en Power Builder 11.2.<br><br>Ya tengo resuelto la extracion de informacion de la huella y la comparacion entre 2 lecturas, mi problema es guardar esa informacion en la BD.<br><br>La informacion de la huella la tengo en un arreglo Blob de 10000 y ese es el que ocupo guardar en la BD y despues obtenerlo para realizar la comparacion.<br><br>En este ejemplo que muestran esta para Oracle y una variable Blob, y lo que ocupo es hacerlo con un arreglo de Blob y en SQL Server 2005.<br><br>Gracias de antemanoAlfredonoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-76534877511509298782010-06-22T17:57:26.000-07:002010-06-22T17:57:26.000-07:00Unfortunately, the technique I'm showing is ve...Unfortunately, the technique I'm showing is very specific to Oracle. It really is only to address limiting the memory impact of handling very large blobs. That doesn't appear to be an issue in your case.brucearmstrongnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-24943896820421084122011-06-08T12:40:58.000-07:002011-06-08T12:40:58.000-07:00Mr Armstrong,I liked your "Reading and writin...Mr Armstrong,<br><br>I liked your "Reading and writing a blob in chunks" article, i have a question.<br>If i have in a database a blob that contains a text file (txt extension), how is possible read it and inserted in a Rich text control?<br><br>Thanks and regardsByron Salashttp://www.bpzenergy.comnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-52854234376172716122009-11-01T07:01:32.000-08:002009-11-01T07:01:32.000-08:00i have confused using the code. i new in power bui...i have confused using the code. i new in power builder. can you give the sample project(pbt and pbl) of this blob.<br>thanks.denynoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-6384682635270253492009-04-22T03:17:47.000-07:002009-04-22T03:17:47.000-07:00i want to write and read image into sybase sql any...i want to write and read image into sybase sql anywhere but always failure, can you explaine script in pb 9 how to solve that problems?<br><br>thanks anywaykuclukhttp://kucluk.comnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-62740372532677739462009-07-07T15:52:10.000-07:002009-07-07T15:52:10.000-07:00Hello,This way to read and write blobs is very int...Hello,<br><br>This way to read and write blobs is very interesting.<br><br>Do you know a way to read a blob that contains text and put its content to a rich text box or similar control?<br><br>Thank you very much for your help...Johnnhttp://www.bpzenergy.comnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-71043314695574579752009-07-08T06:31:23.000-07:002009-07-08T06:31:23.000-07:00What format is the text in? You can always just d...What format is the text in? You can always just do a Paste or PasteRTF on the edit control if it's text or RTF. Or an InsertDocument if it's another format (DOC, HTML).<br><br>I still use the RichTextControl rather than the rich text edit control in the DataWindow because of the size limitations on the field in the latter.brucearmstrongnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-25954734937870469162009-02-10T15:48:51.000-08:002009-02-10T15:48:51.000-08:00ah, D'Oh. Got it. Thanks again.ah, D'Oh. Got it. Thanks again.J Buellnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-84297653242389000322009-02-10T15:41:12.000-08:002009-02-10T15:41:12.000-08:00The Open, New, Read and Write methods in the packa...The Open, New, Read and Write methods in the package are declared as local external functions in the transaction object. If you then use that class for SQLCA, those become methods of SQLCA. As a result, I'm calling those stored procedures through those methods.brucearmstrongnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-46717102104552049072009-02-10T15:33:19.000-08:002009-02-10T15:33:19.000-08:00Thanks Bruce for the quick reply. This post was o...Thanks Bruce for the quick reply. This post was outstanding and extremely helpful. I searched your blog but couldn't find anything on the transaction object you are using. What are the new(i), open(i) and write() methods doing? Do you extend the PFC n_tr object?J Buellnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-36928827413912226222009-02-10T15:26:17.000-08:002009-02-10T15:26:17.000-08:00Yes. Guess I forgot to include that in the sample...Yes. Guess I forgot to include that in the sample. It has to match whatever you set the value to in the package.brucearmstrongnoreply@blogger.comtag:blogger.com,1999:blog-14934996.post-62088254186254845592009-02-10T15:18:58.000-08:002009-02-10T15:18:58.000-08:00Bruce, are your setting the value of the instance ...Bruce, are your setting the value of the instance var il_buflen to 32000?J Buellnoreply@blogger.com