From tonyj at solutionsonhand.com Thu Apr 29 19:10:44 2004 From: tonyj at solutionsonhand.com (Tony Jacoby) Date: Fri, 30 Apr 2004 10:10:44 +1000 Subject: [BEU-Support] BeUp achievement! Message-ID: 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. From andy at minstersystems.co.uk Fri Apr 30 01:44:14 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Fri, 30 Apr 2004 07:44:14 +0100 Subject: [BEU-Support] BeUp achievement! In-Reply-To: Message-ID: <000b01c42e7e$8d7f1750$b274d0d5@minster33c3r25> 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 > > From tonyj at solutionsonhand.com Mon May 24 19:04:56 2004 From: tonyj at solutionsonhand.com (Tony Jacoby) Date: Tue, 25 May 2004 10:04:56 +1000 Subject: [BEU-Support] Can't add OLE Object field? Message-ID: Hi guys, Looks like it's not possible to add an OLE Object field through BEU. Is there a workaround for this? I'm just curious to know why this isn't an option? Regards, Tony Tony Jacoby Solutions On Hand From andy at minstersystems.co.uk Tue May 25 12:01:30 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Tue, 25 May 2004 18:01:30 +0100 Subject: [BEU-Support] Can't add OLE Object field? In-Reply-To: Message-ID: <00a401c44279$ed06ac10$b274d0d5@minster33c3r25> Hi Tony Well the only reason it's not there is that we had to draw a line somewhere so we could get a version out. We could add this as a v2 request, but to be perfectly frank there's no saying there'll be a v2 soon if ever. As volunteers working long distance and trying to fit in free work with our day jobs it was a struggle. A well worthwhile one which we all got a lot out of, but I'm not sure we'd all be up for a second dose. So if you can't live without it and want to have a go at implementing it in your copy feel free, and we'd love the code when you're done. And if you'd like some pointers as to what needs altering come back to us and we can probably do that too. Anyway, nice to hear from another user. Hope you like BEU despite the OLE omossion. Cheers -- 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: 25 May 2004 01:05 > To: 'beu-support at databaseadvisors.com' > Subject: [BEU-Support] Can't add OLE Object field? > > > Hi guys, > > Looks like it's not possible to add an OLE Object field > through BEU. Is there a workaround for this? > > I'm just curious to know why this isn't an option? > > Regards, > Tony > > Tony Jacoby > Solutions On Hand > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From tonyj at solutionsonhand.com Tue May 25 19:45:36 2004 From: tonyj at solutionsonhand.com (Tony Jacoby) Date: Wed, 26 May 2004 10:45:36 +1000 Subject: [BEU-Support] Can't add OLE Object field? Message-ID: Thanks Andy and Reuben for your replies. I wasn't sure that anyone was monitoring the forum. And yes, I REALLY like BEU!! I've been digging into the forms and code a little and I tried adding the OLE Object choice to the frmDBASub_FieldAdd!cboType, with value 11. Then I added a new Version/Mod, selecting this choice but I got an error in beuDBAfieldadd when I tried the update. So obviously there is more to it than just adding the choice. Other than the more obvious UI mods that I need (hiding Size, Format, etc. on the form), if you can direct me to the functions that I would need to work on, I'd be keen to have a go. And if I make it work, I'll send you the mods to incorporate into the next release - if there is one ;). (BTW - is the forum only available via the Archive page, http://databaseadvisors.com/pipermail/beu-support/? I can't see a way of replying to a post, other than through an email, such as this one.) Regards, Tony -----Original Message----- From: Andy Lacey [mailto:andy at minstersystems.co.uk] Sent: Wednesday, 26 May 2004 3:02 AM To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com Subject: RE: [BEU-Support] Can't add OLE Object field? Hi Tony Well the only reason it's not there is that we had to draw a line somewhere so we could get a version out. We could add this as a v2 request, but to be perfectly frank there's no saying there'll be a v2 soon if ever. As volunteers working long distance and trying to fit in free work with our day jobs it was a struggle. A well worthwhile one which we all got a lot out of, but I'm not sure we'd all be up for a second dose. So if you can't live without it and want to have a go at implementing it in your copy feel free, and we'd love the code when you're done. And if you'd like some pointers as to what needs altering come back to us and we can probably do that too. Anyway, nice to hear from another user. Hope you like BEU despite the OLE omossion. Cheers -- 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: 25 May 2004 01:05 > To: 'beu-support at databaseadvisors.com' > Subject: [BEU-Support] Can't add OLE Object field? > > > Hi guys, > > Looks like it's not possible to add an OLE Object field through BEU. > Is there a workaround for this? > > I'm just curious to know why this isn't an option? > > Regards, > Tony > > Tony Jacoby > Solutions On Hand > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From andy at minstersystems.co.uk Wed May 26 02:08:04 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Wed, 26 May 2004 08:08:04 +0100 Subject: [BEU-Support] Can't add OLE Object field? In-Reply-To: Message-ID: <00c101c442f0$30c35b30$b274d0d5@minster33c3r25> Hi Tony I'll take a look when I can. Pls let me know if Reuben beats me to it. He's the king of the update side, the FE is my better area. And the forums were used for a while but never kicked off again after dba moved host and redesigned the web site. -- 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: 26 May 2004 01:46 > To: BEU-Support at databaseadvisors.com > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > Thanks Andy and Reuben for your replies. I wasn't sure that > anyone was monitoring the forum. And yes, I REALLY like BEU!! > > I've been digging into the forms and code a little and I > tried adding the OLE Object choice to the > frmDBASub_FieldAdd!cboType, with value 11. Then I added a > new Version/Mod, selecting this choice but I got an error in > beuDBAfieldadd when I tried the update. > > So obviously there is more to it than just adding the choice. > Other than the more obvious UI mods that I need (hiding > Size, Format, etc. on the form), if you can direct me to the > functions that I would need to work on, I'd be keen to have a > go. And if I make it work, I'll send you the mods to > incorporate into the next release - if there is one ;). > > (BTW - is the forum only available via the Archive page, > http://databaseadvisors.com/pipermail/beu-support/? I can't > see a way of replying to a post, other than through an email, > such as this one.) > > Regards, > Tony > > -----Original Message----- > From: Andy Lacey [mailto:andy at minstersystems.co.uk] > Sent: Wednesday, 26 May 2004 3:02 AM > To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > Hi Tony > Well the only reason it's not there is that we had to draw a > line somewhere so we could get a version out. We could add > this as a v2 request, but to be perfectly frank there's no > saying there'll be a v2 soon if ever. As volunteers working > long distance and trying to fit in free work with our day > jobs it was a struggle. A well worthwhile one which we all > got a lot out of, but I'm not sure we'd all be up for a second dose. > > So if you can't live without it and want to have a go at > implementing it in your copy feel free, and we'd love the > code when you're done. And if you'd like some pointers as to > what needs altering come back to us and we can probably do that too. > > Anyway, nice to hear from another user. Hope you like BEU > despite the OLE omossion. > > Cheers > > -- 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: 25 May 2004 01:05 > > To: 'beu-support at databaseadvisors.com' > > Subject: [BEU-Support] Can't add OLE Object field? > > > > > > Hi guys, > > > > Looks like it's not possible to add an OLE Object field through BEU. > > Is there a workaround for this? > > > > I'm just curious to know why this isn't an option? > > > > Regards, > > Tony > > > > Tony Jacoby > > Solutions On Hand > > > > _______________________________________________ > > BEU-Support mailing list > > BEU-Support at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > > > Website: http://www.databaseadvisors.com > > > > > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From andy at minstersystems.co.uk Wed May 26 11:39:58 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Wed, 26 May 2004 17:39:58 +0100 Subject: [BEU-Support] Can't add OLE Object field? In-Reply-To: <00c101c442f0$30c35b30$b274d0d5@minster33c3r25> Message-ID: <00f501c44340$150f51f0$b274d0d5@minster33c3r25> Have sent Tony the code to do this. Doesn't need any changes in your bit Reuben. andy > -----Original Message----- > From: beu-support-bounces at databaseadvisors.com > [mailto:beu-support-bounces at databaseadvisors.com] On Behalf > Of Andy Lacey > Sent: 26 May 2004 08:08 > To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > Hi Tony > > I'll take a look when I can. Pls let me know if Reuben beats > me to it. He's the king of the update side, the FE is my better area. > > And the forums were used for a while but never kicked off > again after dba moved host and redesigned the web site. > > -- 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: 26 May 2004 01:46 > > To: BEU-Support at databaseadvisors.com > > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > > > > Thanks Andy and Reuben for your replies. I wasn't sure that > > anyone was monitoring the forum. And yes, I REALLY like BEU!! > > > > I've been digging into the forms and code a little and I > > tried adding the OLE Object choice to the > > frmDBASub_FieldAdd!cboType, with value 11. Then I added a > > new Version/Mod, selecting this choice but I got an error in > > beuDBAfieldadd when I tried the update. > > > > So obviously there is more to it than just adding the choice. > > Other than the more obvious UI mods that I need (hiding > > Size, Format, etc. on the form), if you can direct me to the > > functions that I would need to work on, I'd be keen to have a > > go. And if I make it work, I'll send you the mods to > > incorporate into the next release - if there is one ;). > > > > (BTW - is the forum only available via the Archive page, > > http://databaseadvisors.com/pipermail/beu-support/? I can't > > see a way of replying to a post, other than through an email, > > such as this one.) > > > > Regards, > > Tony > > > > -----Original Message----- > > From: Andy Lacey [mailto:andy at minstersystems.co.uk] > > Sent: Wednesday, 26 May 2004 3:02 AM > > To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com > > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > > > > Hi Tony > > Well the only reason it's not there is that we had to draw a > > line somewhere so we could get a version out. We could add > > this as a v2 request, but to be perfectly frank there's no > > saying there'll be a v2 soon if ever. As volunteers working > > long distance and trying to fit in free work with our day > > jobs it was a struggle. A well worthwhile one which we all > > got a lot out of, but I'm not sure we'd all be up for a second dose. > > > > So if you can't live without it and want to have a go at > > implementing it in your copy feel free, and we'd love the > > code when you're done. And if you'd like some pointers as to > > what needs altering come back to us and we can probably do that too. > > > > Anyway, nice to hear from another user. Hope you like BEU > > despite the OLE omossion. > > > > Cheers > > > > -- 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: 25 May 2004 01:05 > > > To: 'beu-support at databaseadvisors.com' > > > Subject: [BEU-Support] Can't add OLE Object field? > > > > > > > > > Hi guys, > > > > > > Looks like it's not possible to add an OLE Object field > through BEU. > > > Is there a workaround for this? > > > > > > I'm just curious to know why this isn't an option? > > > > > > Regards, > > > Tony > > > > > > Tony Jacoby > > > Solutions On Hand > > > > > > _______________________________________________ > > > BEU-Support mailing list > > > BEU-Support at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > > > > > Website: http://www.databaseadvisors.com > > > > > > > > > > _______________________________________________ > > BEU-Support mailing list > > BEU-Support at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > > > Website: http://www.databaseadvisors.com > > > > > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From tonyj at solutionsonhand.com Thu Apr 29 19:10:44 2004 From: tonyj at solutionsonhand.com (Tony Jacoby) Date: Fri, 30 Apr 2004 10:10:44 +1000 Subject: [BEU-Support] BeUp achievement! Message-ID: 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. From andy at minstersystems.co.uk Fri Apr 30 01:44:14 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Fri, 30 Apr 2004 07:44:14 +0100 Subject: [BEU-Support] BeUp achievement! In-Reply-To: Message-ID: <000b01c42e7e$8d7f1750$b274d0d5@minster33c3r25> 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 > > From tonyj at solutionsonhand.com Mon May 24 19:04:56 2004 From: tonyj at solutionsonhand.com (Tony Jacoby) Date: Tue, 25 May 2004 10:04:56 +1000 Subject: [BEU-Support] Can't add OLE Object field? Message-ID: Hi guys, Looks like it's not possible to add an OLE Object field through BEU. Is there a workaround for this? I'm just curious to know why this isn't an option? Regards, Tony Tony Jacoby Solutions On Hand From andy at minstersystems.co.uk Tue May 25 12:01:30 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Tue, 25 May 2004 18:01:30 +0100 Subject: [BEU-Support] Can't add OLE Object field? In-Reply-To: Message-ID: <00a401c44279$ed06ac10$b274d0d5@minster33c3r25> Hi Tony Well the only reason it's not there is that we had to draw a line somewhere so we could get a version out. We could add this as a v2 request, but to be perfectly frank there's no saying there'll be a v2 soon if ever. As volunteers working long distance and trying to fit in free work with our day jobs it was a struggle. A well worthwhile one which we all got a lot out of, but I'm not sure we'd all be up for a second dose. So if you can't live without it and want to have a go at implementing it in your copy feel free, and we'd love the code when you're done. And if you'd like some pointers as to what needs altering come back to us and we can probably do that too. Anyway, nice to hear from another user. Hope you like BEU despite the OLE omossion. Cheers -- 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: 25 May 2004 01:05 > To: 'beu-support at databaseadvisors.com' > Subject: [BEU-Support] Can't add OLE Object field? > > > Hi guys, > > Looks like it's not possible to add an OLE Object field > through BEU. Is there a workaround for this? > > I'm just curious to know why this isn't an option? > > Regards, > Tony > > Tony Jacoby > Solutions On Hand > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From tonyj at solutionsonhand.com Tue May 25 19:45:36 2004 From: tonyj at solutionsonhand.com (Tony Jacoby) Date: Wed, 26 May 2004 10:45:36 +1000 Subject: [BEU-Support] Can't add OLE Object field? Message-ID: Thanks Andy and Reuben for your replies. I wasn't sure that anyone was monitoring the forum. And yes, I REALLY like BEU!! I've been digging into the forms and code a little and I tried adding the OLE Object choice to the frmDBASub_FieldAdd!cboType, with value 11. Then I added a new Version/Mod, selecting this choice but I got an error in beuDBAfieldadd when I tried the update. So obviously there is more to it than just adding the choice. Other than the more obvious UI mods that I need (hiding Size, Format, etc. on the form), if you can direct me to the functions that I would need to work on, I'd be keen to have a go. And if I make it work, I'll send you the mods to incorporate into the next release - if there is one ;). (BTW - is the forum only available via the Archive page, http://databaseadvisors.com/pipermail/beu-support/? I can't see a way of replying to a post, other than through an email, such as this one.) Regards, Tony -----Original Message----- From: Andy Lacey [mailto:andy at minstersystems.co.uk] Sent: Wednesday, 26 May 2004 3:02 AM To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com Subject: RE: [BEU-Support] Can't add OLE Object field? Hi Tony Well the only reason it's not there is that we had to draw a line somewhere so we could get a version out. We could add this as a v2 request, but to be perfectly frank there's no saying there'll be a v2 soon if ever. As volunteers working long distance and trying to fit in free work with our day jobs it was a struggle. A well worthwhile one which we all got a lot out of, but I'm not sure we'd all be up for a second dose. So if you can't live without it and want to have a go at implementing it in your copy feel free, and we'd love the code when you're done. And if you'd like some pointers as to what needs altering come back to us and we can probably do that too. Anyway, nice to hear from another user. Hope you like BEU despite the OLE omossion. Cheers -- 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: 25 May 2004 01:05 > To: 'beu-support at databaseadvisors.com' > Subject: [BEU-Support] Can't add OLE Object field? > > > Hi guys, > > Looks like it's not possible to add an OLE Object field through BEU. > Is there a workaround for this? > > I'm just curious to know why this isn't an option? > > Regards, > Tony > > Tony Jacoby > Solutions On Hand > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From andy at minstersystems.co.uk Wed May 26 02:08:04 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Wed, 26 May 2004 08:08:04 +0100 Subject: [BEU-Support] Can't add OLE Object field? In-Reply-To: Message-ID: <00c101c442f0$30c35b30$b274d0d5@minster33c3r25> Hi Tony I'll take a look when I can. Pls let me know if Reuben beats me to it. He's the king of the update side, the FE is my better area. And the forums were used for a while but never kicked off again after dba moved host and redesigned the web site. -- 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: 26 May 2004 01:46 > To: BEU-Support at databaseadvisors.com > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > Thanks Andy and Reuben for your replies. I wasn't sure that > anyone was monitoring the forum. And yes, I REALLY like BEU!! > > I've been digging into the forms and code a little and I > tried adding the OLE Object choice to the > frmDBASub_FieldAdd!cboType, with value 11. Then I added a > new Version/Mod, selecting this choice but I got an error in > beuDBAfieldadd when I tried the update. > > So obviously there is more to it than just adding the choice. > Other than the more obvious UI mods that I need (hiding > Size, Format, etc. on the form), if you can direct me to the > functions that I would need to work on, I'd be keen to have a > go. And if I make it work, I'll send you the mods to > incorporate into the next release - if there is one ;). > > (BTW - is the forum only available via the Archive page, > http://databaseadvisors.com/pipermail/beu-support/? I can't > see a way of replying to a post, other than through an email, > such as this one.) > > Regards, > Tony > > -----Original Message----- > From: Andy Lacey [mailto:andy at minstersystems.co.uk] > Sent: Wednesday, 26 May 2004 3:02 AM > To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > Hi Tony > Well the only reason it's not there is that we had to draw a > line somewhere so we could get a version out. We could add > this as a v2 request, but to be perfectly frank there's no > saying there'll be a v2 soon if ever. As volunteers working > long distance and trying to fit in free work with our day > jobs it was a struggle. A well worthwhile one which we all > got a lot out of, but I'm not sure we'd all be up for a second dose. > > So if you can't live without it and want to have a go at > implementing it in your copy feel free, and we'd love the > code when you're done. And if you'd like some pointers as to > what needs altering come back to us and we can probably do that too. > > Anyway, nice to hear from another user. Hope you like BEU > despite the OLE omossion. > > Cheers > > -- 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: 25 May 2004 01:05 > > To: 'beu-support at databaseadvisors.com' > > Subject: [BEU-Support] Can't add OLE Object field? > > > > > > Hi guys, > > > > Looks like it's not possible to add an OLE Object field through BEU. > > Is there a workaround for this? > > > > I'm just curious to know why this isn't an option? > > > > Regards, > > Tony > > > > Tony Jacoby > > Solutions On Hand > > > > _______________________________________________ > > BEU-Support mailing list > > BEU-Support at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > > > Website: http://www.databaseadvisors.com > > > > > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > > From andy at minstersystems.co.uk Wed May 26 11:39:58 2004 From: andy at minstersystems.co.uk (Andy Lacey) Date: Wed, 26 May 2004 17:39:58 +0100 Subject: [BEU-Support] Can't add OLE Object field? In-Reply-To: <00c101c442f0$30c35b30$b274d0d5@minster33c3r25> Message-ID: <00f501c44340$150f51f0$b274d0d5@minster33c3r25> Have sent Tony the code to do this. Doesn't need any changes in your bit Reuben. andy > -----Original Message----- > From: beu-support-bounces at databaseadvisors.com > [mailto:beu-support-bounces at databaseadvisors.com] On Behalf > Of Andy Lacey > Sent: 26 May 2004 08:08 > To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > Hi Tony > > I'll take a look when I can. Pls let me know if Reuben beats > me to it. He's the king of the update side, the FE is my better area. > > And the forums were used for a while but never kicked off > again after dba moved host and redesigned the web site. > > -- 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: 26 May 2004 01:46 > > To: BEU-Support at databaseadvisors.com > > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > > > > Thanks Andy and Reuben for your replies. I wasn't sure that > > anyone was monitoring the forum. And yes, I REALLY like BEU!! > > > > I've been digging into the forms and code a little and I > > tried adding the OLE Object choice to the > > frmDBASub_FieldAdd!cboType, with value 11. Then I added a > > new Version/Mod, selecting this choice but I got an error in > > beuDBAfieldadd when I tried the update. > > > > So obviously there is more to it than just adding the choice. > > Other than the more obvious UI mods that I need (hiding > > Size, Format, etc. on the form), if you can direct me to the > > functions that I would need to work on, I'd be keen to have a > > go. And if I make it work, I'll send you the mods to > > incorporate into the next release - if there is one ;). > > > > (BTW - is the forum only available via the Archive page, > > http://databaseadvisors.com/pipermail/beu-support/? I can't > > see a way of replying to a post, other than through an email, > > such as this one.) > > > > Regards, > > Tony > > > > -----Original Message----- > > From: Andy Lacey [mailto:andy at minstersystems.co.uk] > > Sent: Wednesday, 26 May 2004 3:02 AM > > To: 'Tony Jacoby'; BEU-Support at databaseadvisors.com > > Subject: RE: [BEU-Support] Can't add OLE Object field? > > > > > > Hi Tony > > Well the only reason it's not there is that we had to draw a > > line somewhere so we could get a version out. We could add > > this as a v2 request, but to be perfectly frank there's no > > saying there'll be a v2 soon if ever. As volunteers working > > long distance and trying to fit in free work with our day > > jobs it was a struggle. A well worthwhile one which we all > > got a lot out of, but I'm not sure we'd all be up for a second dose. > > > > So if you can't live without it and want to have a go at > > implementing it in your copy feel free, and we'd love the > > code when you're done. And if you'd like some pointers as to > > what needs altering come back to us and we can probably do that too. > > > > Anyway, nice to hear from another user. Hope you like BEU > > despite the OLE omossion. > > > > Cheers > > > > -- 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: 25 May 2004 01:05 > > > To: 'beu-support at databaseadvisors.com' > > > Subject: [BEU-Support] Can't add OLE Object field? > > > > > > > > > Hi guys, > > > > > > Looks like it's not possible to add an OLE Object field > through BEU. > > > Is there a workaround for this? > > > > > > I'm just curious to know why this isn't an option? > > > > > > Regards, > > > Tony > > > > > > Tony Jacoby > > > Solutions On Hand > > > > > > _______________________________________________ > > > BEU-Support mailing list > > > BEU-Support at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > > > > > Website: http://www.databaseadvisors.com > > > > > > > > > > _______________________________________________ > > BEU-Support mailing list > > BEU-Support at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > > > Website: http://www.databaseadvisors.com > > > > > > _______________________________________________ > BEU-Support mailing list > BEU-Support at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/b> eu-support > > Website: http://www.databaseadvisors.com > >