Access vs PH (was Is there a place for 4GLs anymore?)

Bruce Schuck Bruce@Schuck.com
Tue, 6 May 2003 22:56:29 -0700


 
6 days?

About a month ago I was given the task of creating a password keeper. 

I wrote it in Delphi. 5 fields. SQL Server backend. Twofish encryption I got
from libraries on the net. Data comes in, gets decrypted. Data gets saved,
encrypted before sending to SQL.

Add/Delete/Cancel/Print etc.

2 days tops.

And I'm not that good a Delphi programmer (but I do know how to find example
code on the net real good).

I coulda done it Access in 1 day, but I used Delphi because no runtimes
needed. Just ADO which is on all our workstations I needed to worry about.

And I wouldn't have tried it in Powerhouse. And I used Powerhouse for 13
years.

Time passes. Powerhouse.Net would have been a great product. But then again
PC Powerhouse was a great product too ... But at 2000$ it was overpriced.
They could have had the Dbase market. Or a chunk of it.


> 
> -----Original Message-----
> From: powerh-l-admin@cube.swau.edu 
> [mailto:powerh-l-admin@cube.swau.edu] On Behalf Of Olmos, 
> Fernando (Sericon at Alcoa)
> Sent: Tuesday, May 06, 2003 3:53 PM
> To: Powerh-L (E-mail)
> 
> >  In some ways it is similar to Powerhouse. If you use the 
> adp option 
> > where you set you backend as SQL Server (or the runtime 
> version of SQL 
> > server that comes with Access 2000 or Access 2002) you get a tool 
> > with:
> > 
> > A stored procedure designer
> > A view designer
> > A trigger designer
> > A report writer
> > A form writer
> > Reports and forms can be based on stored procedures The ability to 
> > make external windows call via the API A code repository 
> that can be 
> > called from reports and forms
> 
> Put it this way... and take my experience as an example...
> 
> A client recently asked us to produce a simple VB application 
> for which they would use to enter in data. The form was only 
> to hold 5 or 6 fields and it was to cater for all the usual 
> data manipulation methodologies of ADD/MODIFY/DELETE and 
> FIND. In other words we were asked to produce a "simple" VB 
> application that would tap into an SQL server database, 
> access 2 or 3 tables and allow the user to do the above 
> functions. Do you know how long it took for us to do this? 
> drum roll ............... 6 days!!!!
> Unfortunately for us, our client was also a programmer and 
> knew (and was
> able) to do exactly the same thing with Powerhouse. Do you 
> know how long it took him? (oohhh this is good).... 30 minutes!!!!
> 
> The power of 4GL speaks volumes in examples like above, but 
> Microsoft are the world software leaders so... hey.... a 
> company has to weight the pros and the cons and if they want 
> VB applications.... we'll do it... but pleeeeeeeease if I 
> hear anyone bag a 4GL like powerhouse (or even question 
> it)... I'll track and hunt you down like a dog pal! LOL
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to 
> powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe <password>" in message body to 
> powerh-l-request@lists.swau.edu 
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a 
> subscriber.
> 
>