Re: Apps, etc., being made available



Hi Dave,

Thanks for the link. I think I can get going from that info as it seems to
cover most, if not all, of the things I was asking about. Of course, I will
need to purchase FM3 which I haven't done yet which is probably the reason I
did not know about that link. I went to the Microsoft SQL web site and it
tells there now to install their SQL stuff.

It seems to me that SQL is a lot more difficult to implement and use than
Clarion .tps stuff. And for the small business, SQL is IMNSHO overkill.

Thanks again.

--
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
kwiksys AT kwiksystems DOT net
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.com/clarion.htm (BigTamer(tm) Templates)





"David S. Beggs" <dosprinter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ZRROf.2848$z03.785@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Earl,
Capesoft have a pretty good explanation as part of the FM3 docs
http://www.capesoft.com/docs/fm3/fm3sql.htm
Cheers!
Dave Beggs
--
www.dsbglobal.com/d-icons
900 icons for $10


"Earl R Coker" <ksasales AT machlink DOT com> wrote in message
news:120ltk6cu3lia7e@xxxxxxxxxxxxxxxxxxxxx
Hi Dan,

Thanks for the quick reply.

Are you expecting this by tomorrow? :)

No but you seem to know a lot about it so I would think you could "bang
it out" rather quickly. <g>

Don't worry too much about SQL challenges in Clarion. Discussion of SQL
seems difficult, but that's only because it tends to center on a
relatively few things that stand out as differences in how you program
in Clarion.
Clarion apps using .tps files are so easy to develop, install and use,
especially by small businesses with "very" limited "computer experience",
is my take on what you are saying. The "biggie" reason for using SQL
seems to be file corruption but NONE of my customers have EVER had a file
corruption problem that was NOT caused by a hardware problem. Of course
the other reason is the size of the data in the database but that is not
a concern of mine.

There are even some things in my articles on SQL that I now wish I
hadn't said or hadn't emphasized so much.

Along this same line, I looked at the "print book" that is for sale by
ClarionMag as a possibility for a reference guide for doing what I want.
It's 600 or more pages. akkkk... Waaay overkill for what I need
"information" wise. However, I guess I could use it as reference
material while using the quick reference guide if necessary. Although I
did look at the table of contents and the index and it does seem to be
pretty well organized.

I can assure you that 95-99% of what you do in Clarion with SQL will be
exactly the same as you would do with TPS files, unless you are
deterimined to do something very weird.

Yes, I am aware of that. All of my apps are "standard" Clarion with no
"wierd" stuff at all in them that I am aware of. I think they will work
just fine in SQL after "conversion".

I'll be putting together some more how-to's. I'll focus on starting
from scratch--no dictionary, no app, no database, go from there.

That's even more than I am asking for. I am not interested in doing any
apps from scratch. I will already have the existing ".tps app" converted
to SQL. I just need to have a "how-to" quick reference guide for
installing MS-SQL on a PC, then installing the apps, making the
connections, and a discussion about any ideosyncracies with respect to
using the system. There seems to be quite a bit of newsgroup chatter
about doing the "SQL thing" here lately so I think this kind of a quick
reference guide would be well received.

I'm thinking of using Camtasia to make video walkthroughs and give them
away, but I haven't decided whether to spend that much money yet on
something that won't make a penny for me. (What will my wife think!)

This is a good idea but I think doing it would be a much bigger job than
what I am asking for.

--
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
kwiksys AT kwiksystems DOT net
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.com/clarion.htm (BigTamer(tm) Templates)







.


Loading