[AccessD] BEU Updater

Bryan has mentioned the best first step.  That is to change the from and to
version numbers of the 2nd mod.

If the BEU doens't see any mods with a version number greater than the
version of the BE then it doesn't do anything.  Changing the version numbers
will force the BEU to attemp the 2nd mod.  Then if it fails look at the
error log.

Reuben Cummings
Director of Software Development
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bryan
> Carbonnell
> Sent: Thursday, June 12, 2003 7:01 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] BEU Updater
>
>
> Kath,
>
> Did you run beuDBAisDBUptodate before you added the second mod?
>
> If so, you need to increase the version number for the second mod.
>
> Once the BEU hits the first mod in a version that is marked as
> being applied it determines that the upgrade for that version has
> already been done.
>
> If it you tried to do both mods at the same time and it didn't do
> the second mods, have a look at the error log in the FE
> directory. THat may give you some clues as to why it didn't work.
>
> Failing all that, if you want, you can send me the error log, the
> following two tables: tblDBAModifyDatabase
> tblDBAModifyDatabaseMods, and the version number in tblDBAversion
> and I'll see what I can see.
>
> You can send them to bryan_carbonnell at cbc.ca
>
> Bryan Carbonnell
> bryan_carbonnell at cbc.ca
>
> >>> SDSSoftware at Optusnet.com.au 11-Jun-03 7:42:03 PM >>>
> Hi everybody -
>
> I have just started using the BEU tool. I clicked on 'Insert mod'
> and added my first modification, which was table, add field.
> field = directorname
> txt, size 75 to tblx.
>
> I then clicked on 'new mod' to add the same modification for a
> different table, ie. to insert a new field of the same name.
>
> I made a call to the beuDBAIsDBUpToDate routine and now find that
> it only made the first modification, not the second.
>
> When I go back into frmdbamain it shows the first modification as
> applied, but the second not. Now I cannot get that second
> modification to happen. When I re trigger the beuDBAIsDBUpToDate
> routine it appears to ignore the 2nd mod.
>
> (I have manually added the field myself to check that the field
> name / size etc is Ok and then undone that manual change).
>
> Since these 2 mods have to go into my production version early
> next week, any tips?
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>