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

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

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

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

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.

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]