Rob,
It's quite possible that you have a "turbo fat" error which results
from an incompatibility between novell 4.1x and btrieve 6.1

I'll send the patch information to you (and to anybody else who wants
it.) My copy is a bit old, and you might want to re-check the
Novell web site before applying it.

Sherm

On 12/20/98 23:52:19 you wrote:
>
>From: "Rob Berkers" <rberkers@...>
>
>Hi Group,
>
>What can be the reasons for a Fatal error 2?
>
>In our Magic-applications we get every now and then an error 2. When I check
>the files that are used by the application with BTUTIL most of the time
>there seems nothing wrong. So I wondered what could be other reasons for an
>error 2 except a damaged file.... Anyone an idea?
>
>Oh yes, we are talking about Magic 5.60c on an Novell 4.11 server with
>Btrieve 6.10.
>
>Thanks in advance.
>
>Cheers,
>Rob.
>
>
>
>
>------------------------------------------------------------------------
>To unsubscribe from this mailing list, or to change your subscription
>to digest, go to the ONElist web site, at http://www.onelist.com and
>select the User Center link from the menu bar on the left.
>------------------------------------------------------------------------
>-------------------------------------------------------------------------------\
----------------
------------------------------
>Please ensure that you respect other users of this list, and do not flame or
insult others.
>Any problems please contact peter.stewart@...
>-------------------------------------------------------------------------------\
----------------
--------------------------------
>
>



Sherman Levine
MIT
Management of Information Technologies, Inc
(914)-967-7212 voice
(914)-967-7460 fax

Rob,

To my knowledge, the error 46 problem is limited to version 5 files.
When Pervasive wrote btrieve 7, they somehow interpreted magic's "Read
only" file open (This task can only read the file) as "This file can
only be read, and not written to, by ANYBODY!"

When the "first"  user of a file opens it in write/write mode,
subsequent users are fine. However, when the "first" user of a file
opens it in Magic read/write mode, all subsequent users who attempt to
update a record in the file will crash with error 46.

You may have some version 5 files hanging around, and they may be the
cause of the problem. Also, did you set btrieve to create any new
files in version 7 format?

Pervasive has a series of service release patches on their website
www.pervasive.com, however one of our clients has had multiple server
abends, which appears have been solved only by "last week's patch",
which may or may not be available on the server. I'll try to find out
the current patch version and post it when I have it.

I haven't heard of "error 100" problems, but...

Another day, another patch!

Sherm Levine


On 12/21/98 00:01:04 you wrote:
>
>From: "Rob Berkers" <rberkers@...>
>
>Hi group,
>
>Recently we did upgrade Btrieve 6.10 on our Novell-filerserver to
>Pervasive.SQL. Our Magic 5.60c applications is running most of the time
>really good. We did convert our Btrieve 5.x files to Btrieve 7.0 files.
>
>But every now and then we run into an error 46 or an error 100. I can't get
>an real reason for these errors.
>
>Anyone an idea in which direction to look for the cause of these errors????
>
>Thanks,
>
>Cheers,
>Rob.
>
>
>
>
>------------------------------------------------------------------------
>To unsubscribe from this mailing list, or to change your subscription
>to digest, go to the ONElist web site, at http://www.onelist.com and
>select the User Center link from the menu bar on the left.
>------------------------------------------------------------------------
>-------------------------------------------------------------------------------\
----------------
------------------------------
>Please ensure that you respect other users of this list, and do not flame or
insult others.
>Any problems please contact peter.stewart@...
>-------------------------------------------------------------------------------\
----------------
--------------------------------
>
>



Sherman Levine
MIT
Management of Information Technologies, Inc
(914)-967-7212 voice
(914)-967-7460 fax

Rob,

Are you receiving any error messages on your server's console?  Specifically
any type of SPX errors.

Michael Stewart
Director, Applications Development
Pharmacy Division
MedE America

-----Original Message-----
From: Rob Berkers [mailto:rberkers@...]
Sent: Sunday, December 20, 1998 5:52 PM
To: Magic Mailing List
Subject: [magicu-l] Fatal error 2


From: "Rob Berkers" <rberkers@...>

Hi Group,

What can be the reasons for a Fatal error 2?

In our Magic-applications we get every now and then an error 2. When I check
the files that are used by the application with BTUTIL most of the time
there seems nothing wrong. So I wondered what could be other reasons for an
error 2 except a damaged file.... Anyone an idea?

Oh yes, we are talking about Magic 5.60c on an Novell 4.11 server with
Btrieve 6.10.

Thanks in advance.

Cheers,
Rob.




------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------

Hi group,

Recently we did upgrade Btrieve 6.10 on our Novell-filerserver to
Pervasive.SQL. Our Magic 5.60c applications is running most of the time
really good. We did convert our Btrieve 5.x files to Btrieve 7.0 files.

But every now and then we run into an error 46 or an error 100. I can't get
an real reason for these errors.

Anyone an idea in which direction to look for the cause of these errors????

Thanks,

Cheers,
Rob.

Hi Group,

What can be the reasons for a Fatal error 2?

In our Magic-applications we get every now and then an error 2. When I check
the files that are used by the application with BTUTIL most of the time
there seems nothing wrong. So I wondered what could be other reasons for an
error 2 except a damaged file.... Anyone an idea?

Oh yes, we are talking about Magic 5.60c on an Novell 4.11 server with
Btrieve 6.10.

Thanks in advance.

Cheers,
Rob.

Geoff,

I have duplicated this behavior in a clean application with just 1 program
and 1 table (I even tried a clean installation of Magic).  The program
selects the following fields from my table and the only range is defined on
the first 3 fields (using the Min/Max column in the record main):

Ignore Flag (Boolean)  Range = FALSE
Carrier Code (Alpha - U3) Range = F54
Group Number (Alpha - U15) Range = 10061001
Member ID Number (Alpha - U21)
Effective Date (String Date - YYYYMMDD)
Termination Date (String Date - YYYYMMDD)

My full key is defined as:

Ignore Flag (1) + Carrier Code (3) + Group Number (15) + Member ID Number
(21) + Effective Date (8).

In this program, I want to display all the records for the selected Carrier
and Group.  My program displays 10 records per screen in a table object.  By
using the 32-bit monitor program that ships with Pervasive.SQL, I observed
the following behavior.

14 records were read before the 1st screen of data was displayed.
15 records were read before displaying every screen after the first, except
for the last screen.
8,203 records were read before the last screen of data was displayed.

Fortunately in the above example, Pervasive.SQL scans through 8,203 records
in under 5 seconds.

I am able to duplicate the test results with both BTrieve 6.15 for NetWare
and Pervasive.SQL for NetWare.

MSE has also duplicated this behavior.  However, their claim is that this
behavior is inherent with BTrieve and cannot be changed.  I am working with
Pervasive to resolve this issue as well.

If you are using Magic with a server-based copy of BTrieve, load up the
BTrieve monitor program and start tracking your using while running your
online programs.  I think you will be shocked at the number of records
actually being read by the database.

Mike

-----Original Message-----
From: Geoff Greig [mailto:geoffg@...]
Sent: Saturday, December 19, 1998 8:03 PM
To: magicu-l@onelist.com
Subject: [magicu-l] Re: Magic V7/V8 BTrieve Performance


From: Geoff Greig <geoffg@...>

Michael,

Perhaps the reason that the 4096 records are read before returning the error
condition is because of the Cashe size. Have you tried
changing this?

As I asked before. Have you tried isolating the situation. ie writing a
small program that only does this search?

It may be the problem is in some other part of your program that does not
appear immediatly overious.

Geoff Greig
No 1 Software protection Hatr
Currently in Melbourne Australia


MichaelStewart@... wrote:

> From: MichaelStewart@...
>
> Geoff,
>
> I am using a range on the Min/Max fields of the record main on the first 3
> fields of my defined index.  For all 3 fields, the min and max values are
> equal.
>
> In my case, the results are almost "instantaneous" as well.  However,
watch
> the BTrieve monitor while the operations are performed and you will see
many
> more reads than expected.  I have a .zip file of test data and an
> application for anyone to test who is interested.  In my test case,
instead
> of seeing approximately 10 records read before the last screen is
displayed,
> over 8000 records are read.  MSE is using the BTrieve Get Next Extended
> operation.  The problem is that they are setting the rejected record count
> for this function to 4096.  This tells BTrieve that 4096 records should be
> read that do not match the filter condition on the operation before an
error
> is returned to the application.  For a more detailed explanation, email me
> and I'll forward the test files to you.
>
> This behavior on one of my large files is causing system-wide delays of
over
> 1 minute.
>
> Mike
> -----Original Message-----
> From: Geoff Greig [mailto:geoffg@...]
> Sent: Thursday, December 17, 1998 4:09 PM
> To: magicu-l@onelist.com
> Subject: [magicu-l] Re: Magic V7/V8 BTrieve Performance
>
> From: Geoff Greig <geoffg@...>
>
> Michael,
>
> I just tried what you are doing on a 20,000 record file that has a  key
with
> 4 segments were I specified first 3 segments. the
> result was almost instantanious.
>
> I could force it to be slow by useing the wrong key. Even then it only
took
> about 5 seconds.
>
> Are you sure you are using the right key?
>
> To isolate the problem have you tried writing a seperate program that only
> does this search?
>
> Have you specified the Ranges in the record main or in the Task Control.
If
> the later, this is you problem, Task Control range
> expressions are performed sequentionally. ie Don't use the key.
>
> Geoff Greig
> No 1 Software protection Hatr
> Brisbane Australia
>
> MichaelStewart@... wrote:
>
> > From: MichaelStewart@...
> >
> > Has anyone encountered performance problems with Magic versions 7 and 8
> with
> > BTrieve 6.15 or Pervasive.SQL 7?  We have found through extensive
testing
> > that a potential performance problem exists in any online program that
> uses
> > a range on key fields of the index.  Here is an example:
> >
> > We have a program that gets called from the record prefix whenever the
> user
> > changes into Modify mode.  This program has an end condition set to
> > Counter(0)>2 (AFTER).  It's primary purpose is to determine whether or
not
> > more than 1 coverage window record exists for the current member that is
> to
> > be modified.  The range in this subprogram is on the first 3 segments of
> the
> > main key in the task.  Their are no additional ranges defined in the
> > program.
> >
> > Whenever this program is called, we have verified through the Pervasive
> > monitor program, over 4,000 records are scanned before control is
returned
> > back to the user.
> >
> > MSE has acknowledged this behavior and claims that it is inherent with
> > BTrieve databases.  However, through examining the Magic Btrieve Gateway
> log
> > files and the BTrieve trace files, we have determined that the BTrieve
> > function that Magic is using has not been optimized for this type of
use.
> >
> > On small files or files with small record sizes, this type of behavior
is
> > almost unnoticeable.  However, in large files with large record sizes
> (over
> > 1,000,000 records, 680 bytes per record) this problem causes delays of
> more
> > than 1 minute.
> >
> > Michael J. Stewart
> > MedE America - Pharmacy Division, SC
> > (864)574-7245 ext. 106
> >
> > MichaelStewart@...
> >
> > ------------------------------------------------------------------------
> > To unsubscribe from this mailing list, or to change your subscription
> > to digest, go to the ONElist web site, at http://www.onelist.com and
> > select the User Center link from the menu bar on the left.
> > ------------------------------------------------------------------------
> >
>
----------------------------------------------------------------------------
> -------------------------------------------------
> > Please ensure that you respect other users of this list, and do not
flame
> or insult others.
> > Any problems please contact peter.stewart@...
> >
>
----------------------------------------------------------------------------
> ---------------------------------------------------
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
----------------------------------------------------------------------------
> -------------------------------------------------
> Please ensure that you respect other users of this list, and do not flame
or
> insult others.
> Any problems please contact peter.stewart@...
>
----------------------------------------------------------------------------
> ---------------------------------------------------
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
----------------------------------------------------------------------------
-------------------------------------------------
> Please ensure that you respect other users of this list, and do not flame
or insult others.
> Any problems please contact peter.stewart@...
>
----------------------------------------------------------------------------
---------------------------------------------------



------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------

Hi
you can use a batch that perform "set > tempfile"

then scan the tempfile file via magic application init batch
program and write the environment variable into the magic.ini
which should be resident (make sure that the original magic.ini
is read only or copied into the user directory so you
can keep your master magic.ini clean of specific user
information)

Micha - Huji

On Thu, 17 Dec 1998, Thomas Martin wrote:

> From: Thomas Martin <tmartin@...>
>
> At 12/16/98 04:33 PM -0500, you wrote:
> >From: "Steve Cullifer" <scullifer@...>
> >
> >What is the best way to get an operating system environment setting/variable
> >into Magic?  I'm using Magic 8.01, Btrieve, running on Windows 95, Windows
> >98, and Windows NT 3.51.
> >
> >I can think of several ways, but would like to find the best solution, so
> >post what works for you and/or what you think would work best.
>
> Amazingly enough, OS variables (the ones that show up with the "SET"
> command) aren't available directly to a Windows 95 icon.  If you create an
> icon to call a batch file, the batch file can reference the environmental
> variables with the %variablename% method.  I use this to insure that
> magic's "CommandProcessor" is equivalent to %COMSPEC% so that user exits
> don't have a problem.
>
> Tom Martin
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------
>

Hello Geoff,

we tested a methode like this, but it is very slow and sometimes produces
GPFs (version 6.0a). Therefore we went back to the init methode.


Regards
Norbert





Geoff Greig <geoffg@...> on 20.12.98 04:00:26
Please respond to magicu-l@onelist.com
To:     magicu-l@onelist.com
cc:
Subject:        [magicu-l] Re: Appending records to a table

From: Geoff Greig <geoffg@...>

Ian,

Ah,  So you are asking the same thing I asked some time ago. How to copy
records.

And you are saying it is not very RAD in Magic compared to XBase, or for
that mater even somthing as old a COBOL.

We discused this at some length some time ago.

I ended up writing a general purpose copy felds Batch program that recieves
to Numeric paramaters.  The starting varable and the number of varables. It
has one Evaluate operation in the record suffix.

VARSET (A+B+COUNTER (0),VARCURR (A+COUNTER (0)))

were A is the starting Varable and B is the number of varables.

The end condition Expression is COUNTER(0)=B and after.

You still have to create a bach task with all the felds that you want to
copy. But this can be done with the APG. A Link Create can then be entered
at the end of the record main and use the Edit, Repeat Entries (CTL
+R) to fill in the felds of the record to be created/ Appended.

Yes a one liner would be more RAD.

Geoff Greig
No 1 Software protection Hatr
Currently in Melbourne Australia


Ian Whybrow wrote:

> Sorry -- need to clarify. I want to locate records in one table (in this
case the Memory table I have just been creating in) and
> append them to another (identical format) table for permanent storage. At
present I do it field by field (i.e.: create a record and
> initialize each field with the value of the field in the record I am
reading in the memory table) but this seems positively unRAD.
>
> Ian Whybrow
> Logistics Technologies
>
> Roland Thibault wrote:
>
> > From: Roland Thibault <rodantiger@...>
> >
> > For a Magic file, just write more records, magic will keep adding to
the
> > file until you delete the file.
> > If your asking about an ASCII file, the I/O table has an append or
output
> > option.
> >
> > Roland Thibault
> >
> > Ian Whybrow wrote:
> >
> > > THis may sound like a stupid request, but is there a simple
(all-in-one
> > > command) that appends a record or several records to an existing
table.
> > > In X-base programming you just APPEND the whole record and either
> > > specify specific fields or "all" to send all fields. In Magic, to my
> > > knowledge, this is not the case and it should be. Am I wrong (I hope
> > > so). If not it goes in as my first wish list request.
> > >
> > > Ian Whybrow
> > > Logistics Technologies
> >
> >
------------------------------------------------------------------------
> > To unsubscribe from this mailing list, or to change your subscription
> > to digest, go to the ONElist web site, at http://www.onelist.com and
> > select the User Center link from the menu bar on the left.
> >
------------------------------------------------------------------------
> >
---------------------------------------------------------------------------
--------------------------------------------------
> > Please ensure that you respect other users of this list, and do not
flame or insult others.
> > Any problems please contact peter.stewart@...
> >
---------------------------------------------------------------------------
----------------------------------------------------
>
> ------------------------------------------------------------------------
>
>   Ian Whybrow <sales@...>
>   Logistics Technologies Development Corporation
>
>   Ian Whybrow
>   Logistics Technologies Development Corporation    <sales@...>
>                                                                    HTML
Mail
>   1212 Kirtstie Court, Unit 4                         Cellular:
1-416-432-7005
>   Oakville      Fax: 1-905-337-9680
>   Ontario     Work: 1-905-337-9678
>   L6H 5C8
>   Canada
>   Come see us at http://www.logtech.ca Developers of SHIPMENT COMMANDER -
- The first name in Shipping Software. multi-carrier, rate shopping - -
powerful, flexible, user-friendly, interfaceable to most software
>   Additional Information:
>   Last Name     Whybrow
>   First Name    Ian
>   Version       2.1



------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
---------------------------------------------------------------------------
--------------------------------------------------
Please ensure that you respect other users of this list, and do not flame
or insult others.
Any problems please contact peter.stewart@...
---------------------------------------------------------------------------
----------------------------------------------------

Ian,

Ah,  So you are asking the same thing I asked some time ago. How to copy
records.

And you are saying it is not very RAD in Magic compared to XBase, or for that
mater even somthing as old a COBOL.

We discused this at some length some time ago.

I ended up writing a general purpose copy felds Batch program that recieves to
Numeric paramaters.  The starting varable and the number of varables. It has one
Evaluate operation in the record suffix.

VARSET (A+B+COUNTER (0),VARCURR (A+COUNTER (0)))

were A is the starting Varable and B is the number of varables.

The end condition Expression is COUNTER(0)=B and after.

You still have to create a bach task with all the felds that you want to copy.
But this can be done with the APG. A Link Create can then be entered at the end
of the record main and use the Edit, Repeat Entries (CTL
+R) to fill in the felds of the record to be created/ Appended.

Yes a one liner would be more RAD.

Geoff Greig
No 1 Software protection Hatr
Currently in Melbourne Australia


Ian Whybrow wrote:

> Sorry -- need to clarify. I want to locate records in one table (in this case
the Memory table I have just been creating in) and
> append them to another (identical format) table for permanent storage. At
present I do it field by field (i.e.: create a record and
> initialize each field with the value of the field in the record I am reading
in the memory table) but this seems positively unRAD.
>
> Ian Whybrow
> Logistics Technologies
>
> Roland Thibault wrote:
>
> > From: Roland Thibault <rodantiger@...>
> >
> > For a Magic file, just write more records, magic will keep adding to the
> > file until you delete the file.
> > If your asking about an ASCII file, the I/O table has an append or output
> > option.
> >
> > Roland Thibault
> >
> > Ian Whybrow wrote:
> >
> > > THis may sound like a stupid request, but is there a simple (all-in-one
> > > command) that appends a record or several records to an existing table.
> > > In X-base programming you just APPEND the whole record and either
> > > specify specific fields or "all" to send all fields. In Magic, to my
> > > knowledge, this is not the case and it should be. Am I wrong (I hope
> > > so). If not it goes in as my first wish list request.
> > >
> > > Ian Whybrow
> > > Logistics Technologies
> >
> > ------------------------------------------------------------------------
> > To unsubscribe from this mailing list, or to change your subscription
> > to digest, go to the ONElist web site, at http://www.onelist.com and
> > select the User Center link from the menu bar on the left.
> > ------------------------------------------------------------------------
> >
--------------------------------------------------------------------------------\
---------------------------------------------
> > Please ensure that you respect other users of this list, and do not flame or
insult others.
> > Any problems please contact peter.stewart@...
> >
--------------------------------------------------------------------------------\
-----------------------------------------------
>
>   ------------------------------------------------------------------------
>
>   Ian Whybrow <sales@...>
>   Logistics Technologies Development Corporation
>
>   Ian Whybrow
>   Logistics Technologies Development Corporation
<sales@...>
>
HTML Mail
>   1212 Kirtstie Court, Unit 4
Cellular: 1-416-432-7005
>   Oakville
Fax: 1-905-337-9680
>   Ontario
Work: 1-905-337-9678
>   L6H 5C8
>   Canada
>   Come see us at http://www.logtech.ca Developers of SHIPMENT COMMANDER - -
The first name in Shipping Software. multi-carrier, rate shopping - - powerful,
flexible, user-friendly, interfaceable to most software
>   Additional Information:
>   Last Name     Whybrow
>   First Name    Ian
>   Version       2.1

Michael,

Perhaps the reason that the 4096 records are read before returning the error
condition is because of the Cashe size. Have you tried
changing this?

As I asked before. Have you tried isolating the situation. ie writing a small
program that only does this search?

It may be the problem is in some other part of your program that does not appear
immediatly overious.

Geoff Greig
No 1 Software protection Hatr
Currently in Melbourne Australia


MichaelStewart@... wrote:

> From: MichaelStewart@...
>
> Geoff,
>
> I am using a range on the Min/Max fields of the record main on the first 3
> fields of my defined index.  For all 3 fields, the min and max values are
> equal.
>
> In my case, the results are almost "instantaneous" as well.  However, watch
> the BTrieve monitor while the operations are performed and you will see many
> more reads than expected.  I have a .zip file of test data and an
> application for anyone to test who is interested.  In my test case, instead
> of seeing approximately 10 records read before the last screen is displayed,
> over 8000 records are read.  MSE is using the BTrieve Get Next Extended
> operation.  The problem is that they are setting the rejected record count
> for this function to 4096.  This tells BTrieve that 4096 records should be
> read that do not match the filter condition on the operation before an error
> is returned to the application.  For a more detailed explanation, email me
> and I'll forward the test files to you.
>
> This behavior on one of my large files is causing system-wide delays of over
> 1 minute.
>
> Mike
> -----Original Message-----
> From: Geoff Greig [mailto:geoffg@...]
> Sent: Thursday, December 17, 1998 4:09 PM
> To: magicu-l@onelist.com
> Subject: [magicu-l] Re: Magic V7/V8 BTrieve Performance
>
> From: Geoff Greig <geoffg@...>
>
> Michael,
>
> I just tried what you are doing on a 20,000 record file that has a  key with
> 4 segments were I specified first 3 segments. the
> result was almost instantanious.
>
> I could force it to be slow by useing the wrong key. Even then it only took
> about 5 seconds.
>
> Are you sure you are using the right key?
>
> To isolate the problem have you tried writing a seperate program that only
> does this search?
>
> Have you specified the Ranges in the record main or in the Task Control.  If
> the later, this is you problem, Task Control range
> expressions are performed sequentionally. ie Don't use the key.
>
> Geoff Greig
> No 1 Software protection Hatr
> Brisbane Australia
>
> MichaelStewart@... wrote:
>
> > From: MichaelStewart@...
> >
> > Has anyone encountered performance problems with Magic versions 7 and 8
> with
> > BTrieve 6.15 or Pervasive.SQL 7?  We have found through extensive testing
> > that a potential performance problem exists in any online program that
> uses
> > a range on key fields of the index.  Here is an example:
> >
> > We have a program that gets called from the record prefix whenever the
> user
> > changes into Modify mode.  This program has an end condition set to
> > Counter(0)>2 (AFTER).  It's primary purpose is to determine whether or not
> > more than 1 coverage window record exists for the current member that is
> to
> > be modified.  The range in this subprogram is on the first 3 segments of
> the
> > main key in the task.  Their are no additional ranges defined in the
> > program.
> >
> > Whenever this program is called, we have verified through the Pervasive
> > monitor program, over 4,000 records are scanned before control is returned
> > back to the user.
> >
> > MSE has acknowledged this behavior and claims that it is inherent with
> > BTrieve databases.  However, through examining the Magic Btrieve Gateway
> log
> > files and the BTrieve trace files, we have determined that the BTrieve
> > function that Magic is using has not been optimized for this type of use.
> >
> > On small files or files with small record sizes, this type of behavior is
> > almost unnoticeable.  However, in large files with large record sizes
> (over
> > 1,000,000 records, 680 bytes per record) this problem causes delays of
> more
> > than 1 minute.
> >
> > Michael J. Stewart
> > MedE America - Pharmacy Division, SC
> > (864)574-7245 ext. 106
> >
> > MichaelStewart@...
> >
> > ------------------------------------------------------------------------
> > To unsubscribe from this mailing list, or to change your subscription
> > to digest, go to the ONElist web site, at http://www.onelist.com and
> > select the User Center link from the menu bar on the left.
> > ------------------------------------------------------------------------
> >
> ----------------------------------------------------------------------------
> -------------------------------------------------
> > Please ensure that you respect other users of this list, and do not flame
> or insult others.
> > Any problems please contact peter.stewart@...
> >
> ----------------------------------------------------------------------------
> ---------------------------------------------------
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> -------------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
> insult others.
> Any problems please contact peter.stewart@...
> ----------------------------------------------------------------------------
> ---------------------------------------------------
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------

Sherman,

You are not the only one concerned about the reliability of Magic and Btrieve.

It seems with all the releases and patches to both Magic and Btrieve and hardly
ever a list of what bugs that the relase or patch
fixes that it is becoming ever more difficult to support end users.

My recient Btrieve locking problems required days of work to eventually come up
with a work around.

It is not much use having the fastest development system, if you then have to
spend days on work arounds to problems that sould
never have existed.

Geoff Greig
No 1 Software protection Hatr
Currently in Melbourne Australia



slevine@... wrote:

> From: slevine@...
>
> Back in the old days (through Magic 5), the combination of Magic and
> Btrieve was "rock-solid" - When something didn't work, it was because
> of something I did wrong - virtually without exception.
>
> Recently, however, I'm seeing an increasing number of
> significant problems on the maillist related to the combination of
> Magic 7-8/Btrieve 6.15/7 on multiuser systems. Some of the issues
> relate to speed, others to record and file locking. I have the
> uncomfortable feeling that many of the issues raised are not curable
> by "tuning", but are the result of design problems in Magic or Btrieve
> (or both).
>
> Clearly the correspondence here is heavily weighted toward solving
> problems, and in that context I'd be interested in hearing about
> "success stories" - that is, large multiuser systems which work
> quickly and reliably - and how you got them to function that way.
>
> Thanks in advance.
>
> Sherm Levine
> ---------------------------
>
> Sherman Levine
> MIT
> Management of Information Technologies, Inc
> (914)-967-7212 voice
> (914)-967-7460 fax
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------

Ian,

A Create task

Or am I not understaining your request

Geoff Greig
No 1 Software Protection Hatr
Currently in Melbourne Australia


Ian Whybrow wrote:

> THis may sound like a stupid request, but is there a simple (all-in-one
> command) that appends a record or several records to an existing table.
> In X-base programming you just APPEND the whole record and either
> specify specific fields or "all" to send all fields. In Magic, to my
> knowledge, this is not the case and it should be. Am I wrong (I hope
> so). If not it goes in as my first wish list request.
>
> Ian Whybrow
> Logistics Technologies
>
>   ------------------------------------------------------------------------
>
>   Ian Whybrow <sales@...>
>   Logistics Technologies Development Corporation
>
>   Ian Whybrow
>   Logistics Technologies Development Corporation
<sales@...>
>
HTML Mail
>   1212 Kirtstie Court, Unit 4
Cellular: 1-416-432-7005
>   Oakville
Fax: 1-905-337-9680
>   Ontario
Work: 1-905-337-9678
>   L6H 5C8
>   Canada
>   Come see us at http://www.logtech.ca Developers of SHIPMENT COMMANDER - -
The first name in Shipping Software. multi-carrier, rate shopping - - powerful,
flexible, user-friendly, interfaceable to most software
>   Additional Information:
>   Last Name     Whybrow
>   First Name    Ian
>   Version       2.1

Sorry -- need to clarify. I want to locate records in one table (in this case
the Memory table I have just been creating in) and
append them to another (identical format) table for permanent storage. At
present I do it field by field (i.e.: create a record and
initialize each field with the value of the field in the record I am reading in
the memory table) but this seems positively unRAD.

Ian Whybrow
Logistics Technologies

Roland Thibault wrote:

> From: Roland Thibault <rodantiger@...>
>
> For a Magic file, just write more records, magic will keep adding to the
> file until you delete the file.
> If your asking about an ASCII file, the I/O table has an append or output
> option.
>
> Roland Thibault
>
> Ian Whybrow wrote:
>
> > THis may sound like a stupid request, but is there a simple (all-in-one
> > command) that appends a record or several records to an existing table.
> > In X-base programming you just APPEND the whole record and either
> > specify specific fields or "all" to send all fields. In Magic, to my
> > knowledge, this is not the case and it should be. Am I wrong (I hope
> > so). If not it goes in as my first wish list request.
> >
> > Ian Whybrow
> > Logistics Technologies
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------

Hi all,

We have reported a performance problem to magic support that they can't
reproduce.

Maybe one of you has the same effects as we.

If we range using the new CNDRANGE function, performance is terrible and if
we don't use the CNDRANGE function, performance is good.

I'll try to explain:

We do a conditional range using:

	 Select field A range from expression: IF (NeedToRange,RangeValue,'')
			 range to expression: IF (NeedToRange,RangeValue,chr(255))

Field NeedToRange and RangeValue are both defined in a higher level task.
Using the above construct everything works ok. But if we change this to

	 Select field A range from expression:  cndrange(NeedToRange,RangeValue)
			 range to expression: cndrange(NeedToRange,RangeValue)

then performace is terrible (system is scanning 100's of records instead of
the few records in the range).

Does anyone have similar experience (The key is a multi-segment key and not
on all segment will be ranged but the range will start with the first
segment etc. and only the last segment can be left unranged).


Regards,

Gijs van Ballegooijen
SPB Software bv.

Geoff wrote:

>From: Geoff Greig <geoffg@...>
>
>Norman,
>
>Why would anyone want to have a screen saver on a server console?


Why would anybody have a GUI window on a server.


Gijs van Ballegooijen
SPB Software bv.

The Dutch members of this group are unlikely to be able to correctly
pronounce the 'dg' in Fudge. It will come out a bit harder, but perhaps,
that is your intention. :)

At 05:37 PM 12/18/98 -0500, you wrote:
>I'm in DAY2 of my 21 days to Delphi Geniusness and soon after I shall
commence contributing to the Fudging of Magic or is that the
>Magic of Fudging. The new LINUX shall be called Magic Fudge or should it
be Hot Fudged Magic or Magically Fudgical Heat or..........
>
>Ian Whybrow
>Logistics Technologies
>
>Dave Persons wrote:
>
>> From: Dave Persons <personsd@...>
>>
>> If we take this approach, we could end up writing another Linux!
>>
>> Craig Martin wrote:
>>
>> > From: Craig Martin <craig_martin@...>
>> >
>> > Ian Whybrow writes:
>> > >For one that works now but costs you money,
>> > >try Open Sesame Systems in Toronto or Montreal
>> > > (Contact Don Ferguson or Moe Nawaz in
>> > >Toronto at donf@... or -- oops
>> > > -- can't find Moe's email) or contact Craig Martin
>> > >who is in the final stages of
>> > >building similar DLL at craig_martin@....
>> > >Craig also has a great multi-purpose DLL called
>> > >Hot Fudge that you may like to
>> > >check into at http://www.craigmartin.com
>> >
>> > Ah, who needs a marketing department when I have
>> > Ian and the mail list... :-)
>> >
>> > Sorry, my 'holiday' got in the way but the elves are
>> > now busy cooking up some new Fudge goodies
>> > just in time for Xmas. It may even include what you say.
>> >
>> > You're beginning to make all this Hot Fudge stuff
>> > seem like a Microsoft product, Ian :-)
>> > (ie. pre-announced by several years).
>> > Apart from the fact I have less money and less bugs than
>> > Microsoft that is.
>> >
>> > Maybe Mr. Eric Gagne wants to post his forthcoming
>> > comms thing as part of Hot Fudge and we start a group
>> > happening with Magic dll-madness unleashed
>> > on an unsuspecting universe.
>> > ("Nothing great was ever achieved without enthusiasm")
>> >
>> > Now how can I become Bodhisattva with
>> > all this ego-stroking.... (very big grin)
>> >
>> > Craig
>> >
>> > ------------------------------------------------------------------------
>> > To unsubscribe from this mailing list, or to change your subscription
>> > to digest, go to the ONElist web site, at http://www.onelist.com and
>> > select the User Center link from the menu bar on the left.
>> > ------------------------------------------------------------------------
>> >
----------------------------------------------------------------------------
-------------------------------------------------
>> > Please ensure that you respect other users of this list, and do not
flame or insult others.
>> > Any problems please contact peter.stewart@...
>> >
----------------------------------------------------------------------------
---------------------------------------------------
>>
>> --
>> David D. Persons
>> IS Manager
>> The Vacation Store
>> (757) 437-7516
>> (757) 437-8290 (fax)
>>
>> *********************************************************************
>> * Vacations for couples. Vacations for singles. Cruises.       *
>> * All-inclusive vacations. Vacations for families.                     *
>> * With The Vacation Store at 1-800-TAKE-OFF, dozens of  *
>> * remarkable vacation choices are just a phone call away:-) *
>> *********************************************************************
>>
>> ------------------------------------------------------------------------
>> To unsubscribe from this mailing list, or to change your subscription
>> to digest, go to the ONElist web site, at http://www.onelist.com and
>> select the User Center link from the menu bar on the left.
>> ------------------------------------------------------------------------
>>
----------------------------------------------------------------------------
-------------------------------------------------
>> Please ensure that you respect other users of this list, and do not
flame or insult others.
>> Any problems please contact peter.stewart@...
>>
----------------------------------------------------------------------------
---------------------------------------------------
>
>Attachment Converted: "e:\program files\edoralight.3.0.5\attach\sales6.vcf"
>

At 12/18/98 06:30 PM -0500, you wrote:
>From: Thomas Martin <tmartin@...>
>
>At 12/18/98 05:05 PM -0500, you wrote:
>>THis may sound like a stupid request, but is there a simple (all-in-one
>>command) that appends a record or several records to an existing table.
>>In X-base programming you just APPEND the whole record and either
>>specify specific fields or "all" to send all fields. In Magic, to my
>>knowledge, this is not the case and it should be. Am I wrong (I hope
>>so). If not it goes in as my first wish list request.
>
>Well, Ian, you did something special -- you made me stop and think for a
>minute!

And then as soon as I hit the send button, it becomes clear that I TOTALLY
MISREAD your question -- I think!

Are you asking about adding blank records?

Tom Martin

>
>When you are at the "dot" prompt in Xbase, you are sitting at an
>interactive interpreter.  Magic really doesn't work that way, in that you
>can't actually do anything until you switch to runtime mode.  I am curious
>as to the domain of your request.  Are you asking for developer's to have
>this function? or End Users?  When I developed in Xbase (Oh, MY!  That's
>was over 10 years ago) :), I generally and heavily discouraged my end users
>from playing at the dot prompt.
>
>Anyway, from the Tables repository, you can do a "Ctrl-G" to generate an
>import program.  If you used this facility to generate the output program
>that created the text data, the import will match; and you don't even have
>to create the program.
>
>Unfortunately, Magic inserts a space between each field when it creates the
>output or input form for this APG program.  If you want to import data from
>Xbase SDF format, you will need to create the program and edit the import
>form, taking out 1 space between each field.
>
>If you want to import CSV, you will still need to create the program so
>that you can change a couple of parameters on the import line in record
>suffix.  In either case, while is isn't QUITE as easy as Xbase, it really
>doesn't take very long.
>
>I do a LOT of stuff with text files, with Magic.  If you have any other
>questions, please let me know.
>
>Tom Martin

At 12/18/98 05:05 PM -0500, you wrote:
>THis may sound like a stupid request, but is there a simple (all-in-one
>command) that appends a record or several records to an existing table.
>In X-base programming you just APPEND the whole record and either
>specify specific fields or "all" to send all fields. In Magic, to my
>knowledge, this is not the case and it should be. Am I wrong (I hope
>so). If not it goes in as my first wish list request.

Well, Ian, you did something special -- you made me stop and think for a
minute!

When you are at the "dot" prompt in Xbase, you are sitting at an
interactive interpreter.  Magic really doesn't work that way, in that you
can't actually do anything until you switch to runtime mode.  I am curious
as to the domain of your request.  Are you asking for developer's to have
this function? or End Users?  When I developed in Xbase (Oh, MY!  That's
was over 10 years ago) :), I generally and heavily discouraged my end users
from playing at the dot prompt.

Anyway, from the Tables repository, you can do a "Ctrl-G" to generate an
import program.  If you used this facility to generate the output program
that created the text data, the import will match; and you don't even have
to create the program.

Unfortunately, Magic inserts a space between each field when it creates the
output or input form for this APG program.  If you want to import data from
Xbase SDF format, you will need to create the program and edit the import
form, taking out 1 space between each field.

If you want to import CSV, you will still need to create the program so
that you can change a couple of parameters on the import line in record
suffix.  In either case, while is isn't QUITE as easy as Xbase, it really
doesn't take very long.

I do a LOT of stuff with text files, with Magic.  If you have any other
questions, please let me know.

Tom Martin

At 12/18/98 09:19 AM -0800, you wrote:
>From: "Robert Warren" <robertwarren@...>
>
>Hello,
>
>For some strange reason, the capital letter 'F' causes all the text
>following the F to disappear.  If you place a backslash in front of the
>letter F, it works fine.  I don't know if the letter F is some kind of
>hidden picture directive or what.  I use the letter F to my advantage
>however.  I can place text on the button, preceded by the letter F (without
>the backslash), and it appears during development but disappears during
>runtime. I use buttons that return user actions.  I usually forget what
>button uses what user action.  To find out, you have to zoom on the button
>and look at the properties.  Instead, I put the intended label on the button
>and F1 or F2 etc. to tell me the user action.  During development my button
>looks like this: 'Search F1', the 1 tells me the button uses user action 1.
>During runtime the button looks like this: 'Search'.

This is a really slick idea, but it is the kind of thing that can really
"Bite" you in the future -- when MSE decides to get rid of an undocumented
feature....

Tom Martin

For a Magic file, just write more records, magic will keep adding to the
file until you delete the file.
If your asking about an ASCII file, the I/O table has an append or output
option.

Roland Thibault


Ian Whybrow wrote:

> THis may sound like a stupid request, but is there a simple (all-in-one
> command) that appends a record or several records to an existing table.
> In X-base programming you just APPEND the whole record and either
> specify specific fields or "all" to send all fields. In Magic, to my
> knowledge, this is not the case and it should be. Am I wrong (I hope
> so). If not it goes in as my first wish list request.
>
> Ian Whybrow
> Logistics Technologies

I'm in DAY2 of my 21 days to Delphi Geniusness and soon after I shall commence
contributing to the Fudging of Magic or is that the
Magic of Fudging. The new LINUX shall be called Magic Fudge or should it be Hot
Fudged Magic or Magically Fudgical Heat or..........

Ian Whybrow
Logistics Technologies

Dave Persons wrote:

> From: Dave Persons <personsd@...>
>
> If we take this approach, we could end up writing another Linux!
>
> Craig Martin wrote:
>
> > From: Craig Martin <craig_martin@...>
> >
> > Ian Whybrow writes:
> > >For one that works now but costs you money,
> > >try Open Sesame Systems in Toronto or Montreal
> > > (Contact Don Ferguson or Moe Nawaz in
> > >Toronto at donf@... or -- oops
> > > -- can't find Moe's email) or contact Craig Martin
> > >who is in the final stages of
> > >building similar DLL at craig_martin@....
> > >Craig also has a great multi-purpose DLL called
> > >Hot Fudge that you may like to
> > >check into at http://www.craigmartin.com
> >
> > Ah, who needs a marketing department when I have
> > Ian and the mail list... :-)
> >
> > Sorry, my 'holiday' got in the way but the elves are
> > now busy cooking up some new Fudge goodies
> > just in time for Xmas. It may even include what you say.
> >
> > You're beginning to make all this Hot Fudge stuff
> > seem like a Microsoft product, Ian :-)
> > (ie. pre-announced by several years).
> > Apart from the fact I have less money and less bugs than
> > Microsoft that is.
> >
> > Maybe Mr. Eric Gagne wants to post his forthcoming
> > comms thing as part of Hot Fudge and we start a group
> > happening with Magic dll-madness unleashed
> > on an unsuspecting universe.
> > ("Nothing great was ever achieved without enthusiasm")
> >
> > Now how can I become Bodhisattva with
> > all this ego-stroking.... (very big grin)
> >
> > Craig
> >
> > ------------------------------------------------------------------------
> > To unsubscribe from this mailing list, or to change your subscription
> > to digest, go to the ONElist web site, at http://www.onelist.com and
> > select the User Center link from the menu bar on the left.
> > ------------------------------------------------------------------------
> >
--------------------------------------------------------------------------------\
---------------------------------------------
> > Please ensure that you respect other users of this list, and do not flame or
insult others.
> > Any problems please contact peter.stewart@...
> >
--------------------------------------------------------------------------------\
-----------------------------------------------
>
> --
> David D. Persons
> IS Manager
> The Vacation Store
> (757) 437-7516
> (757) 437-8290 (fax)
>
> *********************************************************************
> * Vacations for couples. Vacations for singles. Cruises.       *
> * All-inclusive vacations. Vacations for families.                     *
> * With The Vacation Store at 1-800-TAKE-OFF, dozens of  *
> * remarkable vacation choices are just a phone call away:-) *
> *********************************************************************
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------

Craig:

I have but one thing to say --- ITS ABOUT BLOODY TIME!! :-) :-) :-)

Ian

Craig Martin wrote:

> From: Craig Martin <craig_martin@...>
>
> Ian Whybrow writes:
> >For one that works now but costs you money,
> >try Open Sesame Systems in Toronto or Montreal
> > (Contact Don Ferguson or Moe Nawaz in
> >Toronto at donf@... or -- oops
> > -- can't find Moe's email) or contact Craig Martin
> >who is in the final stages of
> >building similar DLL at craig_martin@....
> >Craig also has a great multi-purpose DLL called
> >Hot Fudge that you may like to
> >check into at http://www.craigmartin.com
>
> Ah, who needs a marketing department when I have
> Ian and the mail list... :-)
>
> Sorry, my 'holiday' got in the way but the elves are
> now busy cooking up some new Fudge goodies
> just in time for Xmas. It may even include what you say.
>
> You're beginning to make all this Hot Fudge stuff
> seem like a Microsoft product, Ian :-)
> (ie. pre-announced by several years).
> Apart from the fact I have less money and less bugs than
> Microsoft that is.
>
> Maybe Mr. Eric Gagne wants to post his forthcoming
> comms thing as part of Hot Fudge and we start a group
> happening with Magic dll-madness unleashed
> on an unsuspecting universe.
> ("Nothing great was ever achieved without enthusiasm")
>
> Now how can I become Bodhisattva with
> all this ego-stroking.... (very big grin)
>
> Craig
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------

THis may sound like a stupid request, but is there a simple (all-in-one
command) that appends a record or several records to an existing table.
In X-base programming you just APPEND the whole record and either
specify specific fields or "all" to send all fields. In Magic, to my
knowledge, this is not the case and it should be. Am I wrong (I hope
so). If not it goes in as my first wish list request.

Ian Whybrow
Logistics Technologies

Dave Persons writes:
>If we take this approach, we could end up writing another Linux!

Never under estimate the power of the force!
May the Fudge be with you.
Craig

("A journey of a thousand leagues must
first begin with a single step")

If we take this approach, we could end up writing another Linux!

Craig Martin wrote:

> From: Craig Martin <craig_martin@...>
>
> Ian Whybrow writes:
> >For one that works now but costs you money,
> >try Open Sesame Systems in Toronto or Montreal
> > (Contact Don Ferguson or Moe Nawaz in
> >Toronto at donf@... or -- oops
> > -- can't find Moe's email) or contact Craig Martin
> >who is in the final stages of
> >building similar DLL at craig_martin@....
> >Craig also has a great multi-purpose DLL called
> >Hot Fudge that you may like to
> >check into at http://www.craigmartin.com
>
> Ah, who needs a marketing department when I have
> Ian and the mail list... :-)
>
> Sorry, my 'holiday' got in the way but the elves are
> now busy cooking up some new Fudge goodies
> just in time for Xmas. It may even include what you say.
>
> You're beginning to make all this Hot Fudge stuff
> seem like a Microsoft product, Ian :-)
> (ie. pre-announced by several years).
> Apart from the fact I have less money and less bugs than
> Microsoft that is.
>
> Maybe Mr. Eric Gagne wants to post his forthcoming
> comms thing as part of Hot Fudge and we start a group
> happening with Magic dll-madness unleashed
> on an unsuspecting universe.
> ("Nothing great was ever achieved without enthusiasm")
>
> Now how can I become Bodhisattva with
> all this ego-stroking.... (very big grin)
>
> Craig
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------

--
David D. Persons
IS Manager
The Vacation Store
(757) 437-7516
(757) 437-8290 (fax)

*********************************************************************
* Vacations for couples. Vacations for singles. Cruises.       *
* All-inclusive vacations. Vacations for families.                     *
* With The Vacation Store at 1-800-TAKE-OFF, dozens of  *
* remarkable vacation choices are just a phone call away:-) *
*********************************************************************

Ian Whybrow writes:
>For one that works now but costs you money,
>try Open Sesame Systems in Toronto or Montreal
> (Contact Don Ferguson or Moe Nawaz in
>Toronto at donf@... or -- oops
> -- can't find Moe's email) or contact Craig Martin
>who is in the final stages of
>building similar DLL at craig_martin@....
>Craig also has a great multi-purpose DLL called
>Hot Fudge that you may like to
>check into at http://www.craigmartin.com

Ah, who needs a marketing department when I have
Ian and the mail list... :-)

Sorry, my 'holiday' got in the way but the elves are
now busy cooking up some new Fudge goodies
just in time for Xmas. It may even include what you say.

You're beginning to make all this Hot Fudge stuff
seem like a Microsoft product, Ian :-)
(ie. pre-announced by several years).
Apart from the fact I have less money and less bugs than
Microsoft that is.

Maybe Mr. Eric Gagne wants to post his forthcoming
comms thing as part of Hot Fudge and we start a group
happening with Magic dll-madness unleashed
on an unsuspecting universe.
("Nothing great was ever achieved without enthusiasm")

Now how can I become Bodhisattva with
all this ego-stroking.... (very big grin)

Craig

MSE does not currently support Btrieve 7.  However, we have been using it in
house since it's release without any major problems.  The only issue that we
have with it we would also have if we were using 6.15.  That is Magic's use
of the Btrieve extended operations.  We jumped from 6.10 to 7.0.

We have had great success using Magic 5.7 and Btrieve.  However, the same
cannot be said for Magic 8.0 and Btrieve.

Michael Stewart
Director, Applications Development
Pharmacy Division
MedE America

-----Original Message-----
From: Bret Wiener [mailto:bret@...]
Sent: Friday, December 18, 1998 3:10 PM
To: 'magicu-l@onelist.com'
Subject: [magicu-l] Re: Magic for Windows and Btrieve reliability - is
any body really happy?


From: Bret Wiener <bret@...>

I'm a little unsure about something...does MSE support Magic with Btrieve 7?
I thought Btrieve 7 was still an "unknown" and therefore MSE won't support
it.  We have 2 servers in-house...one with Btrieve 6.15.451 and the other
with Pervasive.SQL (Btrieve 7).  The one with Btrieve 7 doesn't seem to be
any faster, and it gives us a ton of problems...frequent Fatal Error 46's
are the worst, and I've tested after hours with programs which I KNOW should
not cause a 46.  I still prefer 6.15.

Bret

-----Original Message-----
From: slevine@... [mailto:slevine@...]
Sent: Friday, December 18, 1998 6:46 AM
To: magicu-l@onelist.com
Subject: [magicu-l] Magic for Windows and Btrieve reliability - is
anybody really happy?


From: slevine@...

Back in the old days (through Magic 5), the combination of Magic and
Btrieve was "rock-solid" - When something didn't work, it was because
of something I did wrong - virtually without exception.

Recently, however, I'm seeing an increasing number of
significant problems on the maillist related to the combination of
Magic 7-8/Btrieve 6.15/7 on multiuser systems. Some of the issues
relate to speed, others to record and file locking. I have the
uncomfortable feeling that many of the issues raised are not curable
by "tuning", but are the result of design problems in Magic or Btrieve
(or both).

Clearly the correspondence here is heavily weighted toward solving
problems, and in that context I'd be interested in hearing about
"success stories" - that is, large multiuser systems which work
quickly and reliably - and how you got them to function that way.

Thanks in advance.

Sherm Levine
---------------------------





Sherman Levine
MIT
Management of Information Technologies, Inc
(914)-967-7212 voice
(914)-967-7460 fax


------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------

------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------

I'm a little unsure about something...does MSE support Magic with Btrieve 7?
I thought Btrieve 7 was still an "unknown" and therefore MSE won't support
it.  We have 2 servers in-house...one with Btrieve 6.15.451 and the other
with Pervasive.SQL (Btrieve 7).  The one with Btrieve 7 doesn't seem to be
any faster, and it gives us a ton of problems...frequent Fatal Error 46's
are the worst, and I've tested after hours with programs which I KNOW should
not cause a 46.  I still prefer 6.15.

Bret

-----Original Message-----
From: slevine@... [mailto:slevine@...]
Sent: Friday, December 18, 1998 6:46 AM
To: magicu-l@onelist.com
Subject: [magicu-l] Magic for Windows and Btrieve reliability - is
anybody really happy?


From: slevine@...

Back in the old days (through Magic 5), the combination of Magic and
Btrieve was "rock-solid" - When something didn't work, it was because
of something I did wrong - virtually without exception.

Recently, however, I'm seeing an increasing number of
significant problems on the maillist related to the combination of
Magic 7-8/Btrieve 6.15/7 on multiuser systems. Some of the issues
relate to speed, others to record and file locking. I have the
uncomfortable feeling that many of the issues raised are not curable
by "tuning", but are the result of design problems in Magic or Btrieve
(or both).

Clearly the correspondence here is heavily weighted toward solving
problems, and in that context I'd be interested in hearing about
"success stories" - that is, large multiuser systems which work
quickly and reliably - and how you got them to function that way.

Thanks in advance.

Sherm Levine
---------------------------





Sherman Levine
MIT
Management of Information Technologies, Inc
(914)-967-7212 voice
(914)-967-7460 fax


------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------

Reponse to problem #2:  When you install Magic, after you've entered YOUR
LICENSE DATA, you must reboot for the new license data to "take effect".
Give it another shot!

Bret

-----Original Message-----
From: Brian Scoffield [mailto:brianscoffield@...]
Sent: Friday, December 18, 1998 6:50 AM
To: magicu-l@onelist.com
Subject: [magicu-l] V8.01a installation problems


From: "Brian Scoffield" <brianscoffield@...>

I attempted 2 separate installations this past week. Simple single
workstation installations from the Magic CD.

1.    V8.01a Deployment on Win95.  I did a straight, accept all defaults,
installation and  I got the problem initializing the license
database. I resolved that by moving the WBtrcall.dll files to the
appropriate
directories... 51K dll was already in the license directory so I moved the
42k
dll from windows\system to the magic\deployment directory. I was then able
to proceed....

2.    V8.01 Deployment on Win98. I did exactly the same thing on a win98
machine(at a different client, so the two installations are not related in
any
way) and was able to launch the License manager and add my license data
and complete that task without a problem. I did not have to shuffle the
dlls!!!
However, when I tried to then launch Magic I got a "License Error - unable
to
access license data". Those may not be the exact words, but this was not
the DB initialization error of the previous install.
I tried the dll shuffle to no avail. I installed on another workstation and
did
not enter my license info but simply tried to launch Magic expecting to see
the demo application. No way past the license error. (additional inf. both
these machines access a V5.7 version of Magic from an NT server..
conflicts??) Reboots were tried as well...

First, why would the two results be different?

Second, what can I do about the second situation? I hope it is something
simple and I was just too tired to see it, but a simple install from the cd
should probably work!!

Any help would be greatly appreciated....


Brian Scoffield (613) 837-5570
Centillion Information Systems
mailto:brianscoffield@...
http://www.centillion.net

------------------------------------------------------------------------
To unsubscribe from this mailing list, or to change your subscription
to digest, go to the ONElist web site, at http://www.onelist.com and
select the User Center link from the menu bar on the left.
------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------
Please ensure that you respect other users of this list, and do not flame or
insult others.
Any problems please contact peter.stewart@...
----------------------------------------------------------------------------
---------------------------------------------------

For one that works now but costs you money, try Open Sesame Systems in Toronto
or Montreal (Contact Don Ferguson or Moe Nawaz in
Toronto at donf@... or -- oops -- can't find Moe's email) or
contact Craig Martin who is in the final stages of
building similar DLL at craig_martin@.... Craig also has a great
multi-purpose DLL called Hot Fudge that you may like to
check into at http://www.craigmartin.com

Ian Whybrow
Logistics Technologies
Authors of Shipment Commander

socopa Informatique cherre wrote:

> From: "socopa Informatique cherre" <socopa.inform@...>
>
> Hi there !
>
>         Can anyone tell me where i could find some DLL that read/write ( with
> parity, baud, protocol, ...) a serial port with Magic V8 ?
>         Opening a COM like a standard file doesn't work very well :(
>
> A lots of Thanx !
>
> ------------------------------------------------------------------------
> To unsubscribe from this mailing list, or to change your subscription
> to digest, go to the ONElist web site, at http://www.onelist.com and
> select the User Center link from the menu bar on the left.
> ------------------------------------------------------------------------
>
--------------------------------------------------------------------------------\
---------------------------------------------
> Please ensure that you respect other users of this list, and do not flame or
insult others.
> Any problems please contact peter.stewart@...
>
--------------------------------------------------------------------------------\
-----------------------------------------------