2003.3 -> 2004.7 update problems

[Dave Halbert]

I have a 2003.3 database which is happily running on a  Mac G4. On
attempting to upgrade to 2004.7 on an Intel Mac and all is not well.

It is our business database and the big problem is in the invoice
section. I have an "Invoice Header" form with a subform containing the
"Invoice Lines".

When a new invoice is created if the customer has goods "on account"
then these should automatically be entered into the "invoice lines"
before it is possible to start entering the current purchase(s).

These "on account" items are called from the [onac] table (which is in
effect a copy of the [Invoice Line] table) using a method in the
"Invoice Line" form method called by the case statement (Form Event = On
Load).

Putting a TRACE in this Form Event I can see in the Debugger that the
various fields are copied across however when running under Custom Menu
however nothing appears  on screen or is saved on closing the "Invoice
Header" form.

If it gives any pointers as to what may be happening - in the case
statement I have the following IF statement to supply a line number.

    If ([InvLine]ItemNo=0)
                       
        [InvLine]ItemNo:=Records in selection([InvLine])
                       
    End if


Putting a TRACE in this shows me that it is "working" but it returns a
zero in each line.

Similarly in the "Invoice Line" form method case statement ( this time
Form Event = On Data Change) I have the following

                Case of
                        : ([Stock]StockCode="CBR@")
                                SET ENTERABLE(Processing;True)
                        Else
                               
                                SET ENTERABLE(Processing;False)
                End case


While a TRACE in this shows that it runs "correctly" as far as the data
entry is concerned the "processing" field is always "Enterable" - if the
Stockcode starts CBR.. a list is called to show the various processing
options.

There are similar problems with other methods which deal with standing
orders and monthly accounts.

The database was "updated" by 4D2004 before it would run and I've run
Tools over the "updated" version and all would appear to be OK.

Can anybody offer any hints, tips or obvious gotcha's that I've overlooked.

--
Dave Halbert
The Better Beverage Company
204 Morrison Street
Edinburgh  EH3 8EA
Telephone [phone]
Facsimile 0131 228 2838
http://www.betterbeverage.co.uk
**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************

[Spencer Hinsdale]

On 8/12/08 7:21 AM, "Dave Halbert" <dave@...> wrote:
>
> These "on account" items are called from the [onac] table (which is in
> effect a copy of the [Invoice Line] table) using a method in the
> "Invoice Line" form method called by the case statement (Form Event = On
> Load).
>

Dave,

Try enabling the On Load Record event and changing your case to use this
event when writing data to new subform records.

-spencer

**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************