Recent content by nix1016

I have another question in regards to this, after I convert the version 10 DB to UTF-8, I'm loading the ICU-UCA.df collation file to replace the basic collation. I can't seem to get rid of the warning that pops up after loading the collation file telling me to rebuild the index. Is there a way...

Thank you for that, it seems I need to use idxbuild regardless of which method I choose to convert to UTF-8? Unfortunately most of our old clients (the ones with the big databases) are currently on 10.1C04. Yes I had hoped that there was a VST that could tell me the code-page but dbcodepage...

We're upgrading all of our clients from version 10.2B to 11.6 and one of the processes involved is to convert the databases from ISO8859-1 to UTF-8. The process I'm currently doing is: 1. Convert version 10 DB to UTF-8 2. Binary dump version 10 DB 3. Load .bd to empty version 11 UTF-8 DB The...

Yes we plan to use it for notes field only, no documents storage as of now and by the sound of it, probably ever! Thanks for your suggestions Tom, it sounds like LOB might be the easier way to go for us. Cheers!

Thanks Rob, I was missing the part that the data retrieve would not contain records of other types so it makes perfect sense to me now as to why grouping by functionality would not work. With the cluster size, does the size of the records affect it as I was told to use a cluster size of 1 for...

Thanks Rob and Tom for theses detailed explanations and yes I meant mean record size when I said RPB. It makes a lot more sense to me now. The reason I asked was that I thought that grouping by functionality would help in that when it retrieves clusters of record blocks of the first table that...

I was wondering what the reason it is that when designing Type II storage areas that we have to group the tables with similar RPB into the same storage area and not consider their relationships instead? For example if I have invoice headers and invoice charges which will most likely always be...

Thanks for that, that's the issue we have too... however, instead of identifying and fixing the data (which is way too much work) we found a way around it by converting the DB to 1252 and then converting to UTF-8 :)

Thanks, but how do I find out which characters are not in line with the databases' code page? I tried using proutil convchar charscan prior to a conversion and it simply lists the fields that requires translation but doesn't tell me the exact records. Most of the time the translation to UTF-8...

Thanks, I will give that a go. However, we've had issues in the past where certain 1252 characters aren't converted properly which is why I thought doing an ASCII dump would get around the issue

I'm upgrading from Openedge 10 to 11 and doing a dump and load to a new version 11 db as I need to convert to Type II storage area and add additional tables/fields/indexes in the process. I also need to convert the DB from iso8859 to utf-8 so I assume that I can't do a binary dump? I started...

The browse.w isn't a window container unfortunately, so I think we would have to embed the entire main screen in the .NET form. I think this is too much work to just replace just the treeview control... we'll probably have to have a look at other methods! Thanks for your help!

Thanks for your reply. The issue I have is that the .w which currently has the OCX is a browse .w file that is embedded into another frame .w which is a complex screen that has multiple folders/tabs calling different files. If I'm to use the .NET treeview, then do I need to embed the browse .w...

Hi All, This is probably something basic but I just need a hand with starting it off. We used to have a ABL screen with a TreeView OCX used in progress OE 10.1. We have recently upgrade to 11.5 64bit and therefore can no longer use the OCX as there is no 64 bit as far as I'm aware. I'm trying...