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

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

"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

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

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.
>

"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

>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

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 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