[BEU-Support] BeUp achievement!

Thanks for the kind words Tony, and for this info. It's a PITA that we can't
alter a field size in code - at least not in A97 which BEU has to support,
so it's interesting to hear how you overcame that.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: beu-support-bounces at databaseadvisors.com 
> [mailto:beu-support-bounces at databaseadvisors.com] On Behalf 
> Of Tony Jacoby
> Sent: 30 April 2004 01:11
> To: 'BEU-Support at databaseadvisors.com'
> Subject: [BEU-Support] BeUp achievement!
> 
> 
> Hi
> 
> I've been using BeUp for a year or so and I find it a great 
> tool and I'm continually amazed that it's free!
> 
> I just wanted to let you know what I achieved with a bit of 
> thought and effort, in case nobody has tried this before and 
> someone might ask in future.  
> 
> I have a database with several tables where I had to extend 
> the field size of a common field (which I'll call FieldX), 
> which was part of the Primary Key.  I found that I couldn't 
> do this simply with a Modify Field so I put together a 
> sequence of Adds, Modifys and Deletes, as follows:
> 
> 1. New version.
> 2. Field, Add, "FieldXNEW"
> 3. SQL, "UPDATE tblTableX SET tblTableX.FieldXNEW = 
> [FieldX];" 4. Index, Delete, PrimaryKey 5. Field, Delete, 
> "FieldX" 6. Apply the new version and modifications before 
> continuing. 7. New version. 8. Field, Modify, "FieldXNEW", 
> New Field Name: "FieldX" 9. Apply the new version again 
> before continuing. 10. New version. 11. Index, Add, add the 
> fields required, including "FieldX", Index Name: "PrimaryKey"
> 
> I followed the same steps for each table that contained 
> FieldX, and kept applying my changes each step of the way.  
> Then when I restored an old copy of the database, from before 
> I had applied any of the changes, each new version was 
> applied and it all worked perfectly.
> 
> Hopefully someone else will benefit from this in the future.
> 
> Regards,
> Tony
> 
> Tony Jacoby
> Solutions On Hand
> Level 1
> 86-90 Bay Street
> BROADWAY NSW 2007
> AUSTRALIA
> Telephone: +61 2 9281 8122
> Facsimile: +61 2 9211 7811
> Email: tonyj at solutionsonhand.com
> 
> Important Note
> ---------------------
> This e-mail is intended only for the use of the individual or 
> entity named above and may contain information that is 
> confidential and privileged.  If you are not the intended 
> recipient, you are hereby notified that dissemination, 
> distribution or copying of this e-mail and any attachments is 
> strictly prohibited.  When addressed to our clients, any 
> opinions or advice contained in this e-mail are subject to 
> the terms and conditions expressed in our engagement.  We 
> expressly deny any liability for unauthorised use and for 
> e-mail sent by our staff for private purposes.  If you have 
> received this e-mail in error, please notify us immediately 
> by return e-mail or by telephoning 
> +61 2 9211 5977 and destroy the original message.
> Thank you.
> 
> 
> 
> _______________________________________________
> BEU-Support mailing list
> BEU-Support at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/b> eu-support
> 
> Website: http://www.databaseadvisors.com
> 
>