[AccessD] BEU Enhancement

I have added tables like mad to some db's and never had a problem.  This
issue was covered in development (unless I don't understand what you are
saying).

There is a function to check what tables to relink or not relink
(beuDBACheckLink).

In my relinking code I have the following line:
If beuDBACheckLink(tdf.name, strFileName) Then

Are you sure you placed this call in the relinker as stated in the manual?
Re-Read PAGES 2 AND 3 of the BEU manual to see what to call and where to
place it.

I suggest we thoroughly explore the beuDBACheckLink module and the call from
the relinker before making any changes to code.

Reuben Cummings
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, April 08, 2004 12:12 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] BEU Enchancement
>
>
> I've ran across this problem, or one very similar, in the past couple of
> weeks.
>
> I won't say this is the prefered fix for it, since this is Reuben's
> function, but it's what I did to make it work. Please feel free to pass
> this on to the person using it:
>
> In the beuDBAValidateBEPathnction of the basbeuDBAisdbuptodate module:
>
> Maybe 15 lines down, or so, the line that starts, and continues on for
> 4 lines
> strSQL = "SELECT ....
>
> replace it with, and watch fro wrapping:
>
> strSQL = "SELECT tblDBAModifyDatabase.ParameterValue,
> tblDBAModifyDatabaseMods.HowCounter" _
>     & " FROM tblDBAModifyDatabaseMods INNER JOIN tblDBAModifyDatabase
> ON tblDBAModifyDatabaseMods.ModNumber = tblDBAModifyDatabase.ModNumber"
> _
>     & " WHERE tblDBAModifyDatabaseMods.WhatCounter=2 AND
> tblDBAModifyDatabaseMods.HowCounter=2" _
>     & " AND tblDBAModifyDatabaseMods.State<>-1;"
>
> What this does is allows the link validation to take place on a table
> added by the BEU as long as it's was added correctly and had it's mod
> state cahnged to True.
>
> Now, I am using an Alpha of V2, so (s)he *may* need to tweak it a bit
> for V 1.58, but I don't think it will be necessary.
>
> Bryan Carbonnell
> bryan_carbonnelL at cbc.ca
>
>
> >>> jimdettman at earthlink.net 08-Apr-04 12:49:34 PM >>>
> Reuben, Andy, Lembit, or Bryan
>
>   I recommended the BEU to someone and their using relinking code in
> their
> app.  The problem is, it quits the app if a relink cannot be performed
> on a
> table, which is the case when you add a new table via the BEU.  To
> help
> developers around that problem, I would suggest adding a function call
> that
> checks the BEU task list and returns True if it finds the table name.
> Example:
>
> ' In relink code
>
> If Not IsNewBEUTable(strTableName) then
>    ' Relink the table
> End If
>
>
> ' Function added to BEU.
> Public Function IsNewBEUTable(strTableName as string) as integer
>
>   ' Check BEU task table to see if strTableName is added
>   ' Pass back True if found or False if not.
>
> End Function
>
>   I'm not sure exactly what needs to be done to actually identifiy the
> table
> in the task list because I haven't dug deep enough, but I thought I'd
> pass
> along the suggestion at least.
>
> Jim Dettman
> President,
> Online Computer Services of WNY, Inc.
> (315) 699-3443
> jimdettman at earthlink.net
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>