PERVASIVE.SQL 7.0
Kelvin Chua
I had finally installed the Pervasive.SQL and everything seems fine except
the 'darn' irritating beautiful charming 'Pervasive Embeded SQL' splash
screen keep on popping up when ever the database opens. How to disable it
so that the 'darn' irritating facsinating 'Pervasive' Embeded SQL' splash
screen will be gone for ever??
Thanks.
Kelvin Chua
SINGAPORE
Don Redd
Find the BTI.INI (usally in the X:\Windows or X:\Winnt dir) and look for the
following:
[Btrieve Requester]
Embedded Spaces=no
chkparms=no
Splash Screen=Yes
then simply change the :Spash Screen=Yes to Splash Screen=No and that should
do it.
hth
Don
Don Redd
Don
Don Redd
Don
Kelvin Chua
Thank you ver much.
Kelvin Chua
SINGAPORE
Don Redd <dgr...@softhome.net> wrote in message
news:370f8...@tsnews.clarion.com...
Kelvin Chua
I had changed to BTI.INI to disable the Splash Screen but yet the Splash
Screen is still up. I am currently using the PERVASIVE.SQL 7.0 Workstation
and running it under WINDOWS NT WORKSTATION 4 SP4. I had also purchased the
ten-user license for the server but will only install it only when I am
certain that all my databases can run without any hiccups.
Any clues???
Thanks.
Kelvin Chua
SINGAPORE
Kelvin Chua
response time is 8.14AM.
Thanks.
Kelvin Chua
SINGAPORE
Don Redd <dgr...@softhome.net> wrote in message
news:370fe...@tsnews.clarion.com...
Kelvin Chua
Thanks to those who had emailed me to assist me in seting my PERVASIVE.SQL
7.0.
I had managed to OFF the Splash Screen by running the W32SSET.EXE program
and setting the default for the Btrieve Requester.
It is rather painless to port from TPS to Btrieve, and the speed of Btrieve
(may be I am prejudiced) and the feel, make me very very nervous. I created
2 million records within 28 minutes. I will play with it for a while and
basically I am very pleased with the PERVASIVE.SQL and had confirmed that I
will port all my databases to it (Mr SITAS, this is my answer to you).
Thanks.
Kelvin Chua
SINGAPORE
Dmitry Boulatov
Dmitry
euro...@mail.ru
Kelvin Chua wrote in message <370f4...@tsnews.clarion.com>...
Kelvin Chua
it is a darn stable database structure, I should have converted to it much
earlier.
Thanks.
Kelvin Chua
SINGAPORE
Dmitry Boulatov <euro...@mail.ru> wrote in message
news:37117...@news.ptt.ru...
ssehati
Please keep us up to date regarding Pervasive.SQL and how it is working
for you. If I remember correctly you said in one of your posts that you were
evaluating Sybase too. Any special reason you chose Pervasive over Sybase? I
will have to make decision pretty soon too.
Regards
Soheil Sehati
Kelvin Chua <kel...@accpro.com.sg> wrote in message
news:37124...@tsnews.clarion.com...
> Hi there,
>
> I am new to PERVASIVE.SQL 7.0 and was totally enchanted with the database
> structures. I had successfully ported from TPS to Btrieve 7.0. There are
> basically three reasons for porting to PERVASIVE.
>
> a. Wish to utilize the I*net Data Server from Pervasive.
> b. Wish to utilize the data when utilizing TANGO from Pervasive
> to design for E-Commerce.
> c. Wish to allow customers to link into data through ODBC for
> other report writers available from the market. I had also
> understand that CRYSTAL Reports provide native drivers to
> access PERVASIVE.SQL Data.
>
> Now back to the table again. What are the TODOs and NOTTODOs when I am
> using Btrieve 7.0?? Is there any special considerations?? What is the
> value to set for APPEND BUFFERS?? What is the value to set for the
PAGESIZE?
> 4096??
>
> I will be grateful if gurus out there can lend me your ears and lend me a
> hand, cause I would like to fully utilize PERVASIVE.SQL as part of my
> program.
>
> Thanks.
>
> Kelvin Chua
> SINGAPORE
>
> P.S. One of the reasons for me in selecting PERVASIVE.SQL is that I am
> utilizing it for our standard accounting package; ACCPAC, SOLOMAN, SCALA,
> THE GREAT PLAINS are some of those accounting systems out there who
utilize
> PERVASIVE.SQL as their database structure and furthermore this is
TOPSPEED's
> choice.
>
>
>
>
Don Redd
I can give my initial reason for not using Sybase - ERROR,ERROR,ERROR - out
of the box, so-to-speak. Pervasive out of the box - not one error. And the
speed is something to be experienced. I personally like PSQL over Sybase -
but remember, that's ONLY my opinion. And to move to a C/S file system is
painless if you use PSQL(Btrieve). True, it's not SQL, but it IS C/S and
that's all I'm after anyway. I'm also very happy w/PSQL and I too will
start posting my findings in the .Drivers forum.
PS: I want to add with respect to Sybase, my knowledge of SLQAnywhere is
about 2% of what I know about PSQL, I had to admit this - to be sure not to
step on any toes of some who ARE fluent with Sybase.
HTH
Don
ssehati
Thanks for the info. Couple of (actually a dozen)more questions:
- Does Pervasive.SQL support stored procedure & triggers
- Could I run Pervasive.SQL on NT Server and NetWare 4.xx, 5.xx
- Can Pervasive.SQL be installed on a workstation for development
- Can I use navigational processing in conjunction with SQL statements in
the same
module of the code to access the engine
- Are Pervasive.SQL and Btrieve incorporated in the same engine
- Does Pervasive.SQL integrate nicely with both legacy and ABC or do I need
a template to maximize productivity
- Is Pervasive.SQL ODBC compliant (we need ESRI's ArcView GIS to be able to
talk to
Pervasive through ODBC
Don, you mentioned that PSQL(Btrieve) is not SQL. I am under impression that
Pervasive.SQL
part of the engine is SQL driven, but the old Btrieve which is also included
is purely navigational. I remember very expensive health care systems were
written in Btrieve 11 years ago. One system that I recall was used by a
hospital here in town where I used to work. It supported all the nursing
floors and medical records department.
I will be looking for your posts and future findings. I will have to make a
decision fairly soon. We will be using whichever back-end we choose for
internal development, commercial development, as well as recommending it to
our clients as a part of a systems solution that we provide for them.
Best Regards
Soheil Sehati
Don Redd <dgr...@softhome.net> wrote in message
news:3712a...@tsnews.clarion.com...
ssehati
Thanks for the Info. I think I am ready to go for it. I need to know some
more info before
I go ahead and purchase. Posted some questions for Don, I will purchase as
soon as I get some answers from him. Pervasive really sounds like a very
good and dependable product. Would be nice if we could have a forum here,
sort of like TopSpeed.driver.pervasive, but I guess drivers forum will do.
Kelvin, our accountant just bought an accounting package called Wind2000
written in Foxpro, the cost of licensing and some data conversion was about
$30,000 USD. I was very unhappy, but it was too late and a done deal.
Best Regards
Soheil Sehati
Kelvin Chua <kel...@accpro.com.sg> wrote in message
news:3712a...@tsnews.clarion.com...
> Hi there,
>
> While being happy with PERVASIVE.SQL and we are also presently listed
under
> their website http://www.pervasive.com.sg as partner commercial developer,
> be very careful if you are still running your Clarion for DOS 3.102, I
think
> there is internal header problem on its program data file due to the
> differences between the version. If you face any problems in running
> Clarion for DOS 3.102, simply uninstall the PERVASIVE.SQL and everything
> should work as per normal.
>
> Reason of me in selecting? Well... Don had mentioned the crucial part of
it
> which I also will refrain from making much comments. One critical factor
is
> we are selling Accounting software and if companies like Computer
Associates
> selected PERVASIVE.SQL for ACCPAC, IBM selected PERVASIVE.SQL for the
Great
> Plains, SOLOMAN, SCALA to name another few... Certainly I believe these
big
> companies had made more than enough evaluations than what you and me.
>
> Just my opinion...
>
> Thanks.
>
> Kelvin Chua
> SINGAPORE
Don Redd
See Kelvins reposnse - Exact as mine. The difference I like IS if you want
to get on the C/S (Client/Server) bandwagon - not to be confused with the
SQL bandwagon, PSQL is the way to go. And IF you want to go SQL, still the
way to go. I've (being a person responsible for spending others peoples
money - an independent developer) learned to look at ALL options and not
just go with the "most popular" option. I'm assuming you know about
Pervasive's "60 Day trial edition (10 User - ten user)". Does Sybase do
this - hell no. Just call 1-800-287-4383 and find out for u-self.
Bottom Line - it's my choice after looking for over a year!!!!!!!!!!!!!!!!!!
HTH
Don
ssehati
I appreciate the info. It answered many of my questions. Couple of more
questions, Kelvin.:
> Yes, there is a Pervasive.SQL Workstation which supports standalone, works
> flawlessly, installed painlessly, you will certainly like it.
Is this the same engine that is cabable of being installed locally or on a
server -
or is the workstation eddition another purchase?
>It will be just running the setup, then go to the Clarion IDE, change the
data type to
> Pervasive.Btrieve, compile and run.
Does this mean that I can easily convert my existing apps that are using DAT
or TPS file format to Pervasive by just changing the file driver to Btrieve
and recompile?
> You create the database and you will be able to
> access the database with different microkernel, either to access it as
> Btrieve, as SQL or as JBC or ODBC and so on... Thus you may start with
> Btrieve 7.0 and when you have everything ready under ABC Templates, simply
> run your program which basically preferably written in ABC Template for
> optimization reason, and access the same database.
Can i use different microkernels in_the_same_app (if that is the appropriate
term)? To use Btrieve for OLTP and batch operations and SQL for reporting
and querying
> I would say I am currently only using my legacy to access the Btrieve 7.0
> and working towards using ABC Templates to access the Btrieve and SQL
within
> the same program, i.e. I am trying to convert the entire program to ABC
> Templates. I will utilize the Btrieve 7.0 for all the browses and update
> forms, and will utilize the SQL for reporting purposes only.
I guess this answers my question above. This would be fantastic, to be able
to use navigational methods for batch / oltp and SQL for reporting and
querying within the same app.
Kelvin, I remember from one of your earlier posts, you mentioned I*?? from
Pervasive company, either for Internet database connection or it was a layer
between the database and the IIS??? Could you please tell me about it and
let me know if you are happy with the product.
Thanks again
Regards
Soheil Sehati
Don Redd
Sorry about the mis-spelling of your name - please forgive.
Don
ssehati
ssehati
Hi don,
No problem. Believe it or not, sometimes i miss it too (not a very easy
name).
Don, thanks a lot for your input on Pervasive. You and Kelvin have been very
informative and helpful on this matter. Sometimes, it is best hearing these
kinds of info from fellow developers rather than business and advertising
channels. I guess I am ready to go ahead and order Pervasive tomorrow. I
have seen different pricing for Pervasive.SQL, will have to do some Kmart
type shopping tomorrow.
Regards
Soheil Sehati
Kelvin Chua
Kelvin Chua
While being happy with PERVASIVE.SQL and we are also presently listed under
their website http://www.pervasive.com.sg as partner commercial developer,
be very careful if you are still running your Clarion for DOS 3.102, I think
there is internal header problem on its program data file due to the
differences between the version. If you face any problems in running
Clarion for DOS 3.102, simply uninstall the PERVASIVE.SQL and everything
should work as per normal.
Reason of me in selecting? Well... Don had mentioned the crucial part of it
which I also will refrain from making much comments. One critical factor is
we are selling Accounting software and if companies like Computer Associates
selected PERVASIVE.SQL for ACCPAC, IBM selected PERVASIVE.SQL for the Great
Plains, SOLOMAN, SCALA to name another few... Certainly I believe these big
companies had made more than enough evaluations than what you and me.
Just my opinion...
Thanks.
Kelvin Chua
SINGAPORE
Don Redd <dgr...@softhome.net> wrote in message
Kelvin Chua
ssehati <sse...@email.msn.com> wrote in message
news:3712b...@tsnews.clarion.com...
> Don,
>
> Thanks for the info. Couple of (actually a dozen)more questions:
>
> - Does Pervasive.SQL support stored procedure & triggers
I am yet to conquer... still probing...
> - Could I run Pervasive.SQL on NT Server and NetWare 4.xx, 5.xx
No problem for all.
> - Can Pervasive.SQL be installed on a workstation for development
Yes, there is a Pervasive.SQL Workstation which supports standalone, works
flawlessly, installed painlessly, you will certainly like it. It will be
just running the setup, then go to the Clarion IDE, change the data type to
Pervasive.Btrieve, compile and run.
> - Can I use navigational processing in conjunction with SQL statements in
> the same
> module of the code to access the engine
Do not quite understand this.
> - Are Pervasive.SQL and Btrieve incorporated in the same engine
The answer is yes and no. You create the database and you will be able to
access the database with different microkernel, either to access it as
Btrieve, as SQL or as JBC or ODBC and so on... Thus you may start with
Btrieve 7.0 and when you have everything ready under ABC Templates, simply
run your program which basically preferably written in ABC Template for
optimization reason, and access the same database.
> - Does Pervasive.SQL integrate nicely with both legacy and ABC or do I
need a template to maximize productivity
I would say I am currently only using my legacy to access the Btrieve 7.0
and working towards using ABC Templates to access the Btrieve and SQL within
the same program, i.e. I am trying to convert the entire program to ABC
Templates. I will utilize the Btrieve 7.0 for all the browses and update
forms, and will utilize the SQL for reporting purposes only.
> - Is Pervasive.SQL ODBC compliant (we need ESRI's ArcView GIS to be able
to talk to Pervasive through ODBC
I should use the word 'No Sweat' it even supports ODBC 2.53 and basically
this set of ODBC really work as ODBC .
> Don, you mentioned that PSQL(Btrieve) is not SQL. I am under impression
that Pervasive.SQL part of the engine is SQL driven.
See above.
Thanks.
Kelvin Chua
SINGAPORE
Kelvin Chua
ssehati <sse...@email.msn.com> wrote in message
news:3712c...@tsnews.clarion.com...
> Is this the same engine that is cabable of being installed locally or on a
server - or is the workstation eddition another purchase?
Normally the PERVASIVE.SQL should only sell at USD49/- and the 5 user
license for the SERVER version should sell at USD595 and the 10 user license
for USD995. If one were to purchase the 5 user and eventually would like to
increase to 10 users, the price will be basically the cost of purchasing
another 5 users.
> Does this mean that I can easily convert my existing apps that are using
DAT or TPS file format to Pervasive by just changing the file driver to
Btrieve and recompile?
Precisely, and that is real hard part which makes me love Clarion, just this
feature is enough for me love it for quite a while.
> Can i use different microkernels in_the_same_app (if that is the
appropriate
> term)? To use Btrieve for OLTP and batch operations and SQL for reporting
> and querying
Well, this part will be easier to understand, within your dictionary, those
files which you intend to use and access the database as SQL, simply define
the file type as PERVASIVE.SQL, so if you want to kill two birds with one
stone, may be just copying one database to another name and redefine its
file type will do.
> Kelvin, I remember from one of your earlier posts, you mentioned I*?? from
> Pervasive company, either for Internet database connection or it was a
layer
> between the database and the IIS??? Could you please tell me about it and
> let me know if you are happy with the product.
The I*net Data Server need the PERVASIVE.SQL Server version to be installed.
The price for the I*net Data Server should be USD595 and the number of users
limited to log-in your NT Server is limited to the Number of users you
purchased for your NT Server license.
> Thanks again
You are always welcome.
Thanks.
Kelvin Chua
SINGAPORE
Kelvin Chua
Some typo errors...
Kelvin Chua <kel...@accpro.com.sg> wrote in message
news:3712d...@tsnews.clarion.com...
> Hi ssehati,
>
> Normally the PERVASIVE.SQL should only sell at USD49/- ...
should read as Normally the PERVASIVE.SQL Workstation version should only
sell at USD49/-
Thanks.
Kelvin Chua
SINGAPORE
Joseph Lucas
Don Redd <dgr...@softhome.net> wrote in message
news:3712c...@tsnews.clarion.com...
> Hi Sabastii,
> See Kelvins reposnse - Exact as mine. The difference I like IS if you
want
> to get on the C/S (Client/Server) bandwagon - not to be confused with the
> SQL bandwagon, PSQL is the way to go. And IF you want to go SQL, still
the
> way to go. I've (being a person responsible for spending others peoples
> money - an independent developer) learned to look at ALL options and not
> just go with the "most popular" option. I'm assuming you know about
> Pervasive's "60 Day trial edition (10 User - ten user)". Does Sybase do
> this - hell no. Just call 1-800-287-4383 and find out for u-self.
Sybase offers a trial version downloadable from their website.
joe
ssehati
Thanks for all the info. This has been a great help. I was Looking at
Tango by Pervasive
today. It sounds really impressive. I might give that a try too?
P.S. Very good luck with your accounting system.
Best Regards
Soheil Sehati
<kel...@accpro.com.sg> wrote in message
news:3712d...@tsnews.clarion.com...
> Hi ssehati,
>
> ssehati <sse...@email.msn.com> wrote in message
> news:3712c...@tsnews.clarion.com...
ssehati
> Do give it a try, I will be attending the technical workshop with 6 of my
> consultants with Pervasive this week. Will really shout to everyone if it
> is a good stuff.
Pervasive will be close to my area on 29th of this month for half a day
technical workshop
on Tango. I will definitely attend the workshop.
>Will really shout to everyone if it is a good stuff.
Exactly the same here. I peronaly think i owe it to CW community - If it is
really solid and works nicely, then we need to let other developers know
about it.
Regards
Soheil Sehati
p.s. Good job on your system, Kelvin.
>
> Thanks.
>
> Kelvin Chua
> SINGAPORE
>
> P.S. I had sold my accounting at prices ranges from USD10,000 to
USD15,000.
> Certainly I know luck is with me.
>
>
> ssehati <sse...@email.msn.com> wrote in message
> news:3713f...@tsnews.clarion.com...
Kelvin Chua
Do give it a try, I will be attending the technical workshop with 6 of my
consultants with Pervasive this week. Will really shout to everyone if it
is a good stuff.
Thanks.
Augustinus Ludwig Jacob
let me ask some dumb questions:
- With PERVASIVE.SQL workstation edition does it matter where the
databse files are located? Can they be located on a network drive,
e.g. an NT server or a Linux/Samba server?
- Do I understand correctly that with PERVASIVE.SQL workstation your
are doing C/S on a standalone computer, or in other words, client and
server are physically the same hardware?
- Again, with a LINUX/Samba fileserver, which essentially mimics an
NT-server, would it be possible to approach a common data set from
several workstations each running its copy of PERVASIVE.SQL
workstation? As kind of an interim solution until PERVASIVE.SQL may
eventually support LINUX (what they cautiously imply on their
website)?
Best regards
Augustinus Ludwig Jacob
Kelvin Chua
I will try to answer your questions:
> - With PERVASIVE.SQL workstation edition does it matter where the
> databse files are located? Can they be located on a network drive,
> e.g. an NT server or a Linux/Samba server?
The database files are located on at the workstation, in such case PERVASIVE
provides you a local DESKTOP Server within the same computer. You can try
to read data from another PERVASIVE Workstation installed workstation, but I
tend to doubt such connection as the data is likely to be corrupted if a few
users were to log-on to the same database.
For workstations to workstations, you have to wait for the PEER to PEER
edition which is likely to be realeased in coming June 1999. PERVASIVE had
released its PERVASIVE 2000 Beta 1, really do not know what is it, will find
out more.
For the real power of PERVASIVE.SQL, I would only recommend purchasing the
Server edition.
> - Do I understand correctly that with PERVASIVE.SQL workstation your
> are doing C/S on a standalone computer, or in other words, client and
> server are physically the same hardware?
Well?? Since it is only a standalone, and the harddisk is local, then there
is no actual C/S. C/S is when all database is processed by a much more
power hardware and only the requested data is send to the less powerful
hardware over the network.
> - Again, with a LINUX/Samba fileserver, which essentially mimics an
> NT-server, would it be possible to approach a common data set from
> several workstations each running its copy of PERVASIVE.SQL
> workstation? As kind of an interim solution until PERVASIVE.SQL may
> eventually support LINUX (what they cautiously imply on their
> website)?
Why should they support LINUX?? Why should everyone be after LINUX?? Just
because it is free?? Why not set up a SCO UNIX Server and run windows
programs then, since LINUX is UNIX. Why not use MAC OS X which is a
combination of the NEXT, Inc Technology and free BSD software, and it is
also an Open source from Apple. Graphic wise, well... may be LINUX have to
take some time to fill the gap...
Just my thoughts..
Thanks.
Kelvin Chua
SINGAPORE
Augustinus Ludwig Jacob
On Sat, 17 Apr 1999 23:04:12 +0800, "Kelvin Chua"
<kel...@accpro.com.sg> wrote:
>
>Why should they support LINUX?? Why should everyone be after LINUX?? Just
>because it is free?? Why not set up a SCO UNIX Server and run windows
>programs then, since LINUX is UNIX. Why not use MAC OS X which is a
>combination of the NEXT, Inc Technology and free BSD software, and it is
>also an Open source from Apple. Graphic wise, well... may be LINUX have to
>take some time to fill the gap...
Why should anyyone be after LINUX?? Well, I cannot explain *why* so
many people are after LINUX, but the fact is there are many. You know
that lots of SQL databases are being ported to LINUX, among them
essentially all the big names. And, the possibility of eventually
going LINUX is mentioned on the Pervasive website, not invented by me.
I have to admit though, that we decided to replace an old netware
server with a LINUX/Samba combination in our lab, because this version
of netware does not support new hardware, e.g. the Adaptec 7890 family
or multi-GB disks. We did some nice experimenting with a SUSE 6.0
LINUX distribution CD that came as a bonus with some journal for a
total of 7,- DM or 4$. We are now waiting for version 6.1 with LINUX
kernel 2.2 that will come out next week. Then we will invest another
50$ for the full package, installable on as many servers as you like.
Back to pervasive. Following your advice I downloaded the PERVASISVE
SQL workstation trial version and converted a TPS file with a medical
index to Btrieve. First thing I noted was that the size of the file
grew from 3.8MB to 11.2MB, a factor of 3. This is a minor drawback
with this particular file but could be a problem with very big
databases. I tried putting the '/COMPRESS=ON' string in the options
field in the dictionary editor, so far to no avail.
I did not yet experiment with the speed of the new file yet.
many thanks for your insight!
Augustinus
Kelvin Chua
I would think that there is something to do with the contents of the file or
in the matter how the Btrieve Page Size is being defined.
Just a thought.
Thanks.
Kelvin Chua
SINGAPORE
ssehati
Actually, we will be needing couple of different SQL engines, because
some of our clients are using Sybase, MS SQL and Oracle (got a free Oracle
with 5 user licenses with Novell 5.0). I personally like the Pervasive.SQL
for internal app. dev. and also commercial development for obvious reasons.
I will post my findings when the first app is completed.
Regards
Soheil Sehati
Joseph Lucas <j...@pobox.com> wrote in message
news:3712d...@tsnews.clarion.com...
>
> Don Redd <dgr...@softhome.net> wrote in message
> news:3712c...@tsnews.clarion.com...
Joseph Lucas
> Hi Joseph,
> Actually, we will be needing couple of different SQL engines, because
> some of our clients are using Sybase, MS SQL and Oracle (got a free Oracle
> with 5 user licenses with Novell 5.0). I personally like the Pervasive.SQL
> for internal app. dev. and also commercial development for obvious
reasons.
> I will post my findings when the first app is completed.
Please do post your findings. I always like to here of others development
efforts and results.
joe
Kelvin Chua
When I use my legacy template, change all the Topspeed Files into
PERVASIVE.SQL File Type, when I run the program, all files were recreated
and everything is fine; i.e. all new records created does not present any
problems at all.
My problem is when I converted the old TPS files into the new PERVASIVE.SQL
(Btrieve), all the memos were gone. Is there any special considerations I
should have when converting from TPS MEMO to PERVASIVE MEMO fields.
Please kindly enlighten.
Thanks in advance.
Kelvin Chua
SINGAPORE
Daan Marais
Have you tried running Brebuild with compression set to ON?
Daan Marais
Augustinus Ludwig Jacob wrote in message
<3718a961...@tsnews.clarion.com>...
ssehati
I see that you are really at it with Pervasive.SQL. I haven't received
my workstation copy yet. I guess it should all go smooth for us since all
our apps are using DAT file driver.
P.S. In an existing app with tps driver, when you change your file format to
Pervasive, what happens to the data(records) that are already in tps? do
they automatically get converted and moved to pervasive when the file change
occurs?
Best Regards
Soheil Sehati
Kelvin Chua <kel...@accpro.com.sg> wrote in message
news:3719d...@tsnews.clarion.com...
Daan Marais
You need to write your own conversion for each file. The help tells you how,
but here it is in shorthand. Remember that you need a copy of the dictionary
prior to the change!
Using Clarion, open data file you wish to convert
Choose File/Convert, and fill in the prompts.
Open resulting source code file, compile & run
That's it!
ssehati wrote in message <371a0...@tsnews.clarion.com>...
Kelvin Chua
If I were to run and create all my database brand new in Btrieve, everything
is O.K. But I am trying to convert existing TPS Data into Btrieve, haven't
really understand Btrieve yet, that is why I am still not sure in many
areas.
By the way, if you are able to download 58MB of the Tango from Pervasive,
you are actually given a free copy of the PERVASIVE.SQL Workstation. If I
were you, instead of waiting for another few day, just on the modem and 5
hours later, the PERVASIVE.SQL Workstation, APACHE Webserver, TANGO are all
in my system, all free and original.
Thanks.
Kelvin Chua
SINGAPORE
ssehati <sse...@email.msn.com> wrote in message
news:371a0...@tsnews.clarion.com...
ssehati
I think I did apply for a free Tango on Pervasive site (haven't received
it yet).
Just got a ISDN line at work - will try to d/l tango tomorrow.
Good luck with the conversion.
Regards
Soheil Sehati
Kelvin Chua <kel...@accpro.com.sg> wrote in message
news:371a1...@tsnews.clarion.com...
ssehati
Your method might be the most efficient way to convert. I was thinking
about creating the Btrieve files in the same dictionary and then write the
conversion code to assign the DAT fields to Btrieve fields - record at a
time and when all the Btrieve tables are populated delete the DAT files from
the dictionary (too much work)
Regards
Soheil Sehati
Daan Marais <djma...@iafrica.com> wrote in message
news:7fd48u$2e2p$1...@nnrp01.iafrica.com...
> Hi Soheil
>
> You need to write your own conversion for each file. The help tells you
how,
> but here it is in shorthand. Remember that you need a copy of the
dictionary
> prior to the change!
>
> Using Clarion, open data file you wish to convert
> Choose File/Convert, and fill in the prompts.
> Open resulting source code file, compile & run
>
> That's it!
>
> ssehati wrote in message <371a0...@tsnews.clarion.com>...