By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Small business application: best RAD tool

P: n/a
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox
7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.

Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as the
DB platform.

Low on time.

My knowledge: BASIC: good, C & C++: fair, Pascal: almost nothing;

Looking for a RAD tool:
- client application will be running on P4 with XP/2000 & 128MB RAM - Must
be FAST (light .exe)
- easy learning curve
- Hopefully with wizard: design tables for SQL Server 2000, create
relationships, build automatically forms & reports on existing tables.

Thanks


Jul 20 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
Hi,
learn and use CodeCharge...it is easy and cheap...it generates in ASP, PHP,
Cold Fusion, .NET...all you need to have is a Web Server on your machine
like IIS on Windows 2000 or XP Pro
remember CodeCharge.com, they have good examples

Fernand

"Atlas" <at*******@my-deja.com> a écrit dans le message de news:
CJ**************@tornado.fastwebnet.it...
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox 7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.

Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as the DB platform.

Low on time.

My knowledge: BASIC: good, C & C++: fair, Pascal: almost nothing;

Looking for a RAD tool:
- client application will be running on P4 with XP/2000 & 128MB RAM - Must
be FAST (light .exe)
- easy learning curve
- Hopefully with wizard: design tables for SQL Server 2000, create
relationships, build automatically forms & reports on existing tables.

Thanks

Jul 20 '05 #2

P: n/a
> Hi,
learn and use CodeCharge...it is easy and cheap...it generates in ASP, PHP, Cold Fusion, .NET...all you need to have is a Web Server on your

machine(cut)

Looks like a too-much web oriented tool.

I was thinking about some .exe stand alone, using something like VB, VFP or
Delphi........

Jul 20 '05 #3

P: n/a
"Atlas" <at*******@my-deja.com> wrote in message
news:CJ**************@tornado.fastwebnet.it...
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox 7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.

Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as the DB platform.

Low on time.

My knowledge: BASIC: good, C & C++: fair, Pascal: almost nothing;

Looking for a RAD tool:
- client application will be running on P4 with XP/2000 & 128MB RAM - Must
be FAST (light .exe)
- easy learning curve
- Hopefully with wizard: design tables for SQL Server 2000, create
relationships, build automatically forms & reports on existing tables.

How good are you with TSQL?

There is a tool called LittleSteps which enables a TSQL programmer
to develop client applications using TSQL alone. All coding is done
in TSQL in the form of stored procedures. A menu stored procedure
permits the organisational sensitive distribution of all component sp's
to the end-user.

The tool is the only user interface, and is the only object resident in
the client environment. All the organisational-specific intelligent
application-level code is in the RDBMS. Total applications can
thus be scripted.
More info at: www.mountainman.com.au/software

Demo software available soon upon request.

Pete Brown
Falls Creek
Oz
www.mountainman.com.au



Jul 20 '05 #4

P: n/a
> How good are you with TSQL?

Never heard of it.....

Jul 20 '05 #5

P: n/a
I use Clarion, a Windows based RAD.

http://www.softvelocity.com/

I create small apps in a day or so.

Tim

"Atlas" <at*******@my-deja.com> wrote in message
news:CJ**************@tornado.fastwebnet.it...
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox 7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.

Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as the DB platform.

Low on time.

My knowledge: BASIC: good, C & C++: fair, Pascal: almost nothing;

Looking for a RAD tool:
- client application will be running on P4 with XP/2000 & 128MB RAM - Must
be FAST (light .exe)
- easy learning curve
- Hopefully with wizard: design tables for SQL Server 2000, create
relationships, build automatically forms & reports on existing tables.

Thanks

Jul 20 '05 #6

P: n/a
Atlas (at*******@my-deja.com) writes:
How good are you with TSQL?

Never heard of it.....


Then you are in trouble if you are planning to port something to SQL
Server. T-SQL, or Transact-SQL, is the SQL dialect of SQL Server.
While you may come some part of the way with a RAD tool, you will
sooner or later have to master T-SQL to refine your applicaiton.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #7

P: n/a
RE/
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox
7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.


For use just in your own business.

Does it need to be accessible through a web browser?

If "Yes" and "No", I'd say MS Access. 1/3 to 1/5th the manhours development
time compared to VB6.
--
PeteCresswell
Jul 20 '05 #8

P: n/a
VB 6.0.

On Thu, 22 Jan 2004 13:56:42 +0100, "Atlas" <at*******@my-deja.com>
wrote:
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox
7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.

Seriuosly thinking rewriting it from scratch using MS SQL server 2000 as the
DB platform.

Low on time.

My knowledge: BASIC: good, C & C++: fair, Pascal: almost nothing;

Looking for a RAD tool:
- client application will be running on P4 with XP/2000 & 128MB RAM - Must
be FAST (light .exe)
- easy learning curve
- Hopefully with wizard: design tables for SQL Server 2000, create
relationships, build automatically forms & reports on existing tables.

Thanks


Jul 20 '05 #9

P: n/a
Having used a number of those mentioned here (Delphi, VB and Access)
for several years, realistically your experience as mentioned would
suggest you would be best off with Access initially. Don't use Paradox
as it's pants. :-)

Delphi (my preference) requires quite a good knowledge of SQL queries
and stored procedures etc... Depending on your ability, you could pick
this up quite quickly, but it would be beneficial to learn the basics
of T-SQL first. You would use SQL queries within your Delphi
application. VB is similar in a lot of ways.

With Access, you can build and design your app very quickly and if you
have a limited number of users, it should suffice (unless you need it
web based). It's also a good place to start as you can view SQL code
for queries within the app which is almost (but not 100%) what you
would use in SQL itself.

Personally, I started with Access, then learnt VBA within Access, SQL
(basics), then VB and then Delphi before getting stuck into SQL in
anger. I find each pretty quick to work with, and each has it's own
pro's and cons. The Google groups for each are good and helpful. Also
if you are looking for stuff on access have a look at
www.mvps.org/access as it is really helpful.

HTH

"(Pete Cresswell)" <x@y.z> wrote in message news:<l3********************************@4ax.com>. ..
RE/
I've developed years ago a small business application (about ten tables,
basic relationships, 10 forms, 3 reports a few queries) with Borland Paradox
7, most of it developed with wizards and little ObjectPAL coding.
Old'n'crappy.


For use just in your own business.

Does it need to be accessible through a web browser?

If "Yes" and "No", I'd say MS Access. 1/3 to 1/5th the manhours development
time compared to VB6.

Jul 20 '05 #10

P: n/a
> I use Clarion, a Windows based RAD.

Hua?!?! Still alive? I've been using it 15 years ago!!!!! (DOS) Version...
Jul 20 '05 #11

P: n/a
> If "Yes" and "No", I'd say MS Access. 1/3 to 1/5th the manhours
development
time compared to VB6.


Well yes it's certainly quicker to build forms around a table. Do you know
if it's possible to launch it and disable menus, letting it beheave as a
stand alone application?

No one talked about FoxPro...........
Jul 20 '05 #12

P: n/a
Very much alive... very good 3rd party add-on developers, which makes it
very easy to add features that someone else has written.

I make my living from it. All custom and commercial development is done with
Clarion.

Tim Morrison

"Atlas" <at*******@my-deja.com> wrote in message
news:OX****************@tornado.fastwebnet.it...
I use Clarion, a Windows based RAD.


Hua?!?! Still alive? I've been using it 15 years ago!!!!! (DOS) Version...

Jul 20 '05 #13

P: n/a
RE/
Well yes it's certainly quicker to build forms around a table. Do you know
if it's possible to launch it and disable menus, letting it beheave as a
stand alone application?


Yes but...

The simplest case would be Access 2.0. (i.e. 16-bit Access...Office 4.0).
In that case you'd just copy about 20 .DLLs to the user's box and execute
a special version of Access called "RunTime"..

Access 97 and Access 2000 are the only other ones I've worked with. They have
the same feature, but it's enough files/complexity that they need an Installer.

To me, a significant "gotcha" with MS Access is versioning. You develop
something in, say, Access 97; it runs for a year, two years; and one day IT
announces that all machines are going to be upgraded to Access 2000. Your app
can coexist with the new install, but IT has to leave 97 on the boxes and you
have to have taken some care as to how you deployed the execution means...but it
also means that if they do it while you're not around, your app bites the
dust...
--
PeteCresswell
Jul 20 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.