Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Enjoying EDB but want to jump-start myself. Looking for a trainer |
Sun, May 1 2011 5:39 PM | Permanent Link |
Adam Brett Orixa Systems | Hi. I am a London-based EDB programmer with lots of DBISAM & Delphi knowledge.
I would really like to find someone who has been using EDB extensively for a decent amount of time to give me something like a days training. I know I can learn to use the product in time ... but I would rather get as much extra knowledge as I can as quickly as possible ... I am happy to pay a reasonable amount + travel ... Adam |
Mon, May 2 2011 2:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
I think you'd be wasting your money. There's a little bit of learning to do with configuration / catalog and a lot more learning to do with the move to the 20whatever standard. There's also an awful lot of unlearning to do in terms of DBISAMthink but that's a matter of time. A good example of teh latter two points is the use of subSELECTs rather than JOINs in things like DELETE statements. Two suggestions - one find a good general SQL course covering the standard ElevateDB is written to. It won't cover the ElevateDB extensions but it will give you the necessary syntax. The second one is the normal post problems here. Roy Lambert |
Wed, May 4 2011 4:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< I would really like to find someone who has been using EDB extensively for a decent amount of time to give me something like a days training. >> If you want to do a remote desktop session where we cover any questions you may have, it's no problem for me to do so. Just allow me about 3 days notice, and we can set something up. Plus, remember that you can always use Skype chat or calling to contact me with any questions you may have: elevate.software.inc -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 5 2011 2:53 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>If you want to do a remote desktop session where we cover any questions you >may have, it's no problem for me to do so. Just allow me about 3 days >notice, and we can set something up. Its the figuring out what these questions are that made me say its a waste of time Roy Lambert |
Mon, May 9 2011 4:49 AM | Permanent Link |
Adam Brett Orixa Systems | Thanks for both of these suggestions & sorry to be so slow responding. Not sure I can really express my needs clearly enough for something like SKYPE to be useful & I wouldn't really want to waste your valuable time Tim!
I guess you're right Roy face-to-face is probably a waste of money, I just have a good Delphi group that meets from time to time & I find it really useful to actually chat with people about the best ways to do stuff. I also find I save a lot of time with fairly simply stuff they suggest. Something similar to that with EDB felt worth it at a moment when I was pulling my hair out a bit. But you're right ... I have a couple of SQL200X books from my local library & I am feeling my way into it. For the time being I am pulling a few of my bad habits from DBISAM with me ... though they are errors of simplification rather than really bad habits. An issue for me is that I have quite a lot of Delphi stuff written to work with DBISAM which effectively duplicates in the application stuff I could now choose to control at the database with EDB. On the other hand I could be lazy & keep the control in the application. I see some advantages with it both ways & really don't know what to pick. -- I am curious about what you said about sub-selects and joins with deletes? I'm not exactly sure what you meant & would be curious for an example. |
Mon, May 9 2011 9:20 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>Thanks for both of these suggestions & sorry to be so slow responding. Not sure I can really express my needs clearly enough for something like SKYPE to be useful & I wouldn't really want to waste your valuable time Tim! > >I guess you're right Roy face-to-face is probably a waste of money, I just have a good Delphi group that meets from time to time & I find it really useful to actually chat with people about the best ways to do stuff. I also find I save a lot of time with fairly simply stuff they suggest. Something similar to that with EDB felt worth it at a moment when I was pulling my hair out a bit. If you think that's bad try living at the arse end of nowhere I wonder if Tim's sold enough licences in the UK to make it worthwhile setting up a user group? >But you're right ... I have a couple of SQL200X books from my local library & I am feeling my way into it. > >For the time being I am pulling a few of my bad habits from DBISAM with me ... though they are errors of simplification rather than really bad habits. I'd actually say good habits but its about on a par with trying to use good habits generated whilst riding a bike into driving a car - some transfer some don't. >An issue for me is that I have quite a lot of Delphi stuff written to work with DBISAM which effectively duplicates in the application stuff I could now choose to control at the database with EDB. On the other hand I could be lazy & keep the control in the application. I see some advantages with it both ways & really don't know what to pick. For me a part of it is what the application is. The sql standard approach seems to me to be based on the concept of one big central database with lots of different apps accessing it. In those circumstances it makes sense to build as much as possible into the database. For apps where its one app to one database (or as sone of my stuff one app to many copies of a database) it makes as much, or more sense to stuff it into the executable. Security is one of the very gray areas. I'm using ElevateDB to control logon (because I want to use CURRENT_USER as much as anything) but all other aspects of security are controlled via the app. >I am curious about what you said about sub-selects and joins with deletes? I'm not exactly sure what you meant & would be curious for an example. Searching the newsgroups gave me these DBISAM delete from table1 a left outer join table2 b on (b.idx1 = a.idx1) and (b.idx2 = a.idx2) where b.idx3 = null ElevateDB delete from table1 where (select idx3 from table2 where table1.idx2 = table2.idx2 and table1.idx1 = table2.idx1 ) is null Roy Lambert [Team Elevate] |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |