Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
Conversion v3 to v4 |
Tue, Aug 15 2006 3:07 PM | Permanent Link |
Jeff Cook | Hi
I'm sure that there was an article in the newsgroups listing all the things to look out for in converting from DBISAM v3 to v4, but I can't find it anywhere. A link would be appreciated. I've been putting things off waiting for ElevateDB, but have just got a gap in my work schedule and thought I'd quickly do the v3-v4 conversion and hopefully make the conversion to ElevateDB quicker and easier once it has bedded in. Cheers Jeff -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
Tue, Aug 15 2006 6:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jeff,
<< I'm sure that there was an article in the newsgroups listing all the things to look out for in converting from DBISAM v3 to v4, but I can't find it anywhere. A link would be appreciated. >> Do you mean besides this one ? http://www.elevatesoft.com/dbisam4d5_changes.htm << I've been putting things off waiting for ElevateDB, but have just got a gap in my work schedule and thought I'd quickly do the v3-v4 conversion and hopefully make the conversion to ElevateDB quicker and easier once it has bedded in. >> Good move. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Aug 15 2006 7:23 PM | Permanent Link |
Jeff Cook | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote on Tue, 15 Aug 2006 18:35:52 -0400
>http://www.elevatesoft.com/dbisam4d5_changes.htm Thanks Tim Yes, I've seen that one - just thought that I'd seen a step-by-step conversion write up somewhere. Anything to make it easy for me! I might be remembering such instruction for v2 to V3 Cheers Jeff -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
Wed, Aug 16 2006 9:49 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jeff,
<< Yes, I've seen that one - just thought that I'd seen a step-by-step conversion write up somewhere. Anything to make it easy for me! I might be remembering such instruction for v2 to V3 >> There was one around here somewhere. I tried searching the newsgroups, but it's such a common set of search terms that I couldn't find the exact message that I was looking for and gave up. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Aug 16 2006 10:54 AM | Permanent Link |
Jon Lloyd Duerdoth | I had a step by step log of what I did...
but seem to have lost it also If I find it I'll let you know. Jon Tim Young [Elevate Software] wrote: > Jeff, > > << Yes, I've seen that one - just thought that I'd seen a step-by-step > conversion write up somewhere. Anything to make it easy for me! I might be > remembering such instruction for v2 to V3 >> > > There was one around here somewhere. I tried searching the newsgroups, but > it's such a common set of search terms that I couldn't find the exact > message that I was looking for and gave up. > |
Wed, Aug 16 2006 5:02 PM | Permanent Link |
Jeff Cook | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote on Wed, 16 Aug 2006 09:49:14 -0400
> >There was one around here somewhere. I tried searching the newsgroups, but >it's such a common set of search terms that I couldn't find the exact >message that I was looking for and gave up. > Ditto However I'm blundering on - a GExperts search for double-quotes is pinpointing lots of changes, then I run the changed code and pick up errors as I go. Cheers Jeff -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
Wed, Aug 16 2006 6:26 PM | Permanent Link |
Pat | >I'm sure that there was an article in the newsgroups listing all the things to look out for in converting from DBISAM v3 to v4, but I can't find it anywhere. A link would be appreciated.
I will be doing the same thing in the near future. Any notes gratefully accepted Pat |
Wed, Aug 16 2006 9:32 PM | Permanent Link |
"Donat Hebert \(Worldsoft\)" | Here are my notes from Dec 2003 which may help. Upgrade went well on very
large system. Probably a few more but these were the main items. hth. Donat. Can modify in V3 prior to convertion: 1) AutoInc feeds must be null versus zero or any other value if we want the database to activate a new number 2) If AutoInc is exposed on the grid, ensure to disable the editor on Dxgrid as user could actually modify it. 3) Review to ensure double quotes used for directory/files within SQL's a. Change function in library Single quotes are string literals Doubles are identifiers such as filenames or filename with directories Require Version 4 prior to changes 1) Locale ID vs Language (Create table ..) 2) NoAutoInc and SuppressAutoIncValues removed. Only utility based routines 3) Auto Primary Index. If use a Select against a table that has a primary index, the primary is re-created in the target table (With No compression) 4) Review DBISAM_SIG as should modify and re-compile our 'own' DBSys for improved security. (Optional) 5) FieldDefs and RestructureFieldDefs have changed. 6) EmptyTable much faster than delete from Tablename. Also resets the next autoInc values correctly. 7) Concat available. (Supported #13#10 CRLF to provide space ) 8) Alter table new syntax as now supports ASC or DESC segments |
Thu, Aug 17 2006 1:12 AM | Permanent Link |
Jeff Cook | "Donat Hebert \(Worldsoft\)" <donat.hebert@worldsoft.ca> wrote on Wed, 16 Aug 2006 19:29:10 -0600
>Here are my notes from Dec 2003 which may help. Upgrade went well on very >large system. > >Probably a few more but these were the main items. hth. Donat. > > > >Can modify in V3 prior to convertion: > > > >1) AutoInc feeds must be null versus zero or any other >value if we want the database to activate a new number > >2) If AutoInc is exposed on the grid, ensure to disable the >editor on Dxgrid as user could actually modify it. > >3) Review to ensure double quotes used for directory/files >within SQL's > >a. Change function in library > > Single quotes are string literals > > Doubles are identifiers such as filenames or filename with directories > > > >Require Version 4 prior to changes > > >1) Locale ID vs Language (Create table ..) > >2) NoAutoInc and SuppressAutoIncValues removed. Only >utility based routines > >3) Auto Primary Index. If use a Select against a table >that has a primary index, the primary is re-created in the target table >(With No compression) > >4) Review DBISAM_SIG as should modify and re-compile our >'own' DBSys for improved security. (Optional) > >5) FieldDefs and RestructureFieldDefs have changed. > >6) EmptyTable much faster than delete from Tablename. Also >resets the next autoInc values correctly. > >7) Concat available. (Supported #13#10 CRLF to provide >space ) > >8) Alter table new syntax as now supports ASC or DESC >segments > > > Donat Thanks for the notes. Hopefully they will help keep me on track! Cheers Jeff -- Jeff Cook Aspect Systems Ltd Phone: +64-9-424 5388 Skype: jeffcooknz www.aspect.co.nz |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |