|
Re: SERIAL PORT COMMUNICATION
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:-) * *********************************************************************
|
|
|
Re: SERIAL PORT COMMUNICATION
Craig Martin <craig_martin@...>
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")
|
|
|
Appending records to a table
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
|
|
|
Re: SERIAL PORT COMMUNICATION
Craig:
I have but one thing to say --- ITS ABOUT BLOODY TIME!! :-) :-) :-)
Ian
Craig Martin wrote:
toggle quoted message
Show quoted text
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@...
-------------------------------------------------------------------------------------------------------------------------------
|
|
|
Re: SERIAL PORT COMMUNICATION
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:
toggle quoted message
Show quoted text
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@...
-------------------------------------------------------------------------------------------------------------------------------
|
|
|
Re: Appending records to a table
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:
toggle quoted message
Show quoted text
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
|
|
|
Re: Disappearing letters in push button text
Thomas Martin <tmartin@...>
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
|
|
|
Re: Appending records to a table
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! 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
|
|
|
Re: Appending records to a table
Thomas Martin <tmartin@...>
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
|
|
|
Re: SERIAL PORT COMMUNICATION
Ira Gershenhorn <iragershenhorn@...
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"
|
|
|
Re: Magic V7/V8 BTrieve Performance
Gijs van Ballegooijen <gvb@...
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.
|
|
|
Gijs van Ballegooijen <gvb@...
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.
|
|
|
Re: Appending records to a table
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:
toggle quoted message
Show quoted text
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@...
-------------------------------------------------------------------------------------------------------------------------------
|
|
|
Re: Magic V7/V8 BTrieve Performance
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:
toggle quoted message
Show quoted text
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@...
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@...
-------------------------------------------------------------------------------------------------------------------------------
|
|
|
Re: Magic for Windows and Btrieve reliability - is anybody really happy?
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:
toggle quoted message
Show quoted text
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@...
-------------------------------------------------------------------------------------------------------------------------------
|
|
|
Re: Appending records to a table
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:
toggle quoted message
Show quoted text
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
|
|
|
Re: Appending records to a table
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:
toggle quoted message
Show quoted text
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
|
|
|
Re: Appending records to a table
Norbert Gutscher/NGS<dngs@...
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@... To: magicu-l@... 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@... --------------------------------------------------------------------------- ----------------------------------------------------
|
|
|
Re: Getting OS environment setting
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
toggle quoted message
Show quoted text
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@...
-------------------------------------------------------------------------------------------------------------------------------
|
|
|
Re: Magic V7/V8 BTrieve Performance
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
toggle quoted message
Show quoted text
-----Original Message----- From: Geoff Greig [mailto:geoffg@...] Sent: Saturday, December 19, 1998 8:03 PM To: magicu-l@... 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@...
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@... ---------------------------------------------------------------------------- ---------------------------------------------------
|
|
|
