<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>Thanks Bryan and Reuben - I've been
swamped today - I'll go through this and try again in the next day or
so.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=reuben@gfconsultants.com
href="mailto:reuben@gfconsultants.com">Reuben Cummings</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 13, 2003 1:15 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] BEU Updater</DIV>
<DIV><BR></DIV>Bryan has mentioned the best first step. That is to
change the from and to<BR>version numbers of the 2nd mod.<BR><BR>If the BEU
doens't see any mods with a version number greater than the<BR>version of the
BE then it doesn't do anything. Changing the version numbers<BR>will
force the BEU to attemp the 2nd mod. Then if it fails look at
the<BR>error log.<BR><BR>Reuben Cummings<BR>Director of Software
Development<BR>GFC, LLC<BR>phone: 812.523.1017<BR>email: <A
href="mailto:reuben@gfconsultants.com">reuben@gfconsultants.com</A><BR><BR>>
-----Original Message-----<BR>> From: <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A><BR>>
[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Bryan<BR>>
Carbonnell<BR>> Sent: Thursday, June 12, 2003 7:01 AM<BR>> To: <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR>>
Subject: Re: [AccessD] BEU Updater<BR>><BR>><BR>>
Kath,<BR>><BR>> Did you run beuDBAisDBUptodate before you added the
second mod?<BR>><BR>> If so, you need to increase the version number for
the second mod.<BR>><BR>> Once the BEU hits the first mod in a version
that is marked as<BR>> being applied it determines that the upgrade for
that version has<BR>> already been done.<BR>><BR>> If it you tried to
do both mods at the same time and it didn't do<BR>> the second mods, have a
look at the error log in the FE<BR>> directory. THat may give you some
clues as to why it didn't work.<BR>><BR>> Failing all that, if you want,
you can send me the error log, the<BR>> following two tables:
tblDBAModifyDatabase<BR>> tblDBAModifyDatabaseMods, and the version number
in tblDBAversion<BR>> and I'll see what I can see.<BR>><BR>> You can
send them to <A
href="mailto:bryan_carbonnell@cbc.ca">bryan_carbonnell@cbc.ca</A><BR>><BR>>
Bryan Carbonnell<BR>> <A
href="mailto:bryan_carbonnell@cbc.ca">bryan_carbonnell@cbc.ca</A><BR>><BR>>
>>> <A
href="mailto:SDSSoftware@Optusnet.com.au">SDSSoftware@Optusnet.com.au</A>
11-Jun-03 7:42:03 PM >>><BR>> Hi everybody -<BR>><BR>> I
have just started using the BEU tool. I clicked on 'Insert mod'<BR>> and
added my first modification, which was table, add field.<BR>> field =
directorname<BR>> txt, size 75 to tblx.<BR>><BR>> I then clicked on
'new mod' to add the same modification for a<BR>> different table, ie. to
insert a new field of the same name.<BR>><BR>> I made a call to the
beuDBAIsDBUpToDate routine and now find that<BR>> it only made the first
modification, not the second.<BR>><BR>> When I go back into frmdbamain
it shows the first modification as<BR>> applied, but the second not. Now I
cannot get that second<BR>> modification to happen. When I re trigger the
beuDBAIsDBUpToDate<BR>> routine it appears to ignore the 2nd
mod.<BR>><BR>> (I have manually added the field myself to check that the
field<BR>> name / size etc is Ok and then undone that manual
change).<BR>><BR>> Since these 2 mods have to go into my production
version early<BR>> next week, any tips?<BR>><BR>>
_______________________________________________<BR>> AccessD mailing
list<BR>> <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR>>
<A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>>
Website: <A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR>><BR>><BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>