Monday, January 26, 2009

Sx_SetScope() Confusion - SIXCDX v3.01.00

>Hi Brian

>Do you mind if I post this at Clipper...Clipper...Clipper ?

No not at all, in retrospect to this, I have looked at documentation for
Advantage and Comix, who both implement a Scope function, their
documentation is as vague as the SIX documentation, but reading between
the lines from all three products, its working as designed ... not the
best implementation, IMHO but there again I can see the direction used and
understand it.


>Brian Dukes wrote:
>>
>> Having used SIXCDX now quite happily since version 1.5.x, through to

>> version 3.01.00, I have developed my applications and extensively used
>> Sx_SetScope() or SET SCOPE TO in my code.
>>
>> I have just found some interesting behavour with "scopes" that I
>> wasn't aware of and that frightens me a little!
>>
>> OK, lets take a quick psuedo example!
>>
>> set tag to "name"
>> ? sx_setscope(0) // returns NIL
>> Sx_SetScope(0,"BRIAN")
>> ? Sx_SetScope(0) // returns "BRIAN"
>>
>> set tag to "address"
>> ? Sx_SetScope(0) // returns NIL
>> Sx_SetScope(0,"MALVERN)
>> ? Sx_SetScope(0) // returns "MALVERN"
>>
>> set tag to "name"
>> ? Sx_SetScope(0) // returns "BRIAN"
>> Sx_SetScope(0,"")
>> ? Sx_SetScope(0) // returns NIL
>>
>> set tag to "address"
>> ? Sx_SetScope(0) // returns "MALVERN"
>>
>> No where in the SIXCDX documentation does it say that the scope is
>> localised to the current order, and swapping orders will bring into
>> focus a different scope!
>>
>> Not only that but clearing the scope by issuing Sx_SetScope(0,"") and
>> Sx_SetScope(1,"") or by SET SCOPE TO command, is only clearing the
>> scope in the current order ... so when you believe you have cleared
>> the scope on the work-area, and switch orders, you automagically have
>> a scope in force again.
>>
>> OK, take the following code as well :-
>>
>> Sx_SetScope(0,"")
>> cOrgScope := Sx_SetScope(0) // returns NIL
>>
>> Sx_SetScope(0,"FRED")
>> ? Sx_SetScope(0) // retur
>>
>> Sx_SetScope(0,cOrgScope) // restore origi
>> ? Sx_SetScope(0) // retur
>>
>> Because Sx_SetScope returns NIL if no scope is in force, cOrgScope
>> now contains NIL ... if Sx_setscope is called with no second
>> parameter then sx_setscope will just return the current scope setting;
>> Obviously they are checking if the second parameter is NIL, if so just
>> returning the value .... So a function that will save the value of
>> scope mess around under a different scope and then restore scope to
>> its original value, is not gonna work unless it looks summat like :-
>>
>> Sx_SetScope(0,if(cOrgScope == NIL,"",cOrgScope))
>>
>> I think whats clear from the message above, is that I had assumed that
>> you only had ONE scope per work area, as opposed to having one scope
>> per index order!! I can now see a lot of work writing a
>> Sx_SetScope() replacement, which will run through the other orders and
>> clear their scope before setting scope on the current order. And
>> correcting the SET SCOPE TO problem in the same way; and correcting
>> the NIL second parameter problem!!
>>
>> Thanks SuccessWare .... PLEASE can you either DOCUMENT this or FIX
>> IT!!
>>
>> Brian.

-----------------------------------------------------------
Brian Dukes
-----------------------------------------------------------

No comments:

Post a Comment

Welcome to Clipper... Clipper... Clipper


In 1997, then using Delphi 3, I had already created 32-bits Windows applications for HRIS, ERP and CRM. In 2007, using Ruby on Rails, an AJAX powered CRM site running on Apache & MySQL was created and I am now using Visual Studio .Net 2008 to create web-based projects and Delphi 7 for Win32 applications using SQL2005 & DBFCDX.

So, why then am I reviving the Original Clipper... Clipper... Clipper via a Blog as CA-Clipper is a programming language for the DOS world ? Believe it or not, there are still some clients using my mission-critical CA-Clipper applications for DOS installed in the late 80's and up to the mid 90's. This is testimony to CA-Clipper's robustness as a language :-)

With the widespread introduction of Windows 7 64-bits as the standard O/S for new Windows based PCs & Notebooks, CA-Clipper EXE simply will not work and it has become imperative for Clipper programmers to migrate immediately to Harbour to build 32/64 bits EXEs

Since 28th January 2009, this blog has been read by 134,389 (10/3/11 - 39,277) unique visitors (of which 45,151 (10/3/11 - 13,929) are returning visitors) from 103 countries and 1,574 cities & towns in Europe (37; 764 cities), North America (3; 373 cities) , Central America & Caribeans (6; 13 cities), South America(10; 226 cities), Africa & Middle-East (12; 44 cities) , Asia-Pacific (21; 175 cities). So, obviously Clipper is Alive & Well : -)


TIA & Enjoy ! (10th October 2012, 11:05; 13th November 2015)


Original Welcome Page for Clipper... Clipper... Clipper

This is the original Welcome Page for Clipper... Clipper... Clipper, which I am republishing for historical and sentimental reasons. The only changes that I have made was to fix all the broken links. BTW, the counter from counter.digits.com is still working :-)

Welcome to Chee Chong Hwa's Malaysian WWW web site which is dedicated to Clipperheads throughout the world.

This site started out as a teeny-weeny section of Who the heck is Chee Chong Hwa ? and has graduated into a full blown web site of more than 140 pages (actually hundreds of A4 size pages) ! This is due to its growing popularity and tremendous encouragements from visiting Clipperheads from 100 countries worldwide, from North America, Central America, Caribbean, South America, Europe, Middle-East, Africa and Asia-Pacific. Thanx Clipperheads, you all made this happen !


What is Clipper ?

You may ask, what is this Clipper stuff ? Could Clipper be something to do with sailing as it is the name of a very fast sailing American ship in the 19th century ?

Well, Clipper or to be precise, CA-Clipper is the premier PC-Software development tool for DOS. It was first developed by Nantucket Corporation initially as a compiler for dBase3+ programs. Since then, CA-Clipper has evolved away from its x-base roots with the introduction of lexical scoping & pre-defined objects like TBrowse. As at today, the most stable version ofClipper is 5.2e while the latest version, 5.3a was introduced on 21 May 1996.

As at 11th November, 1996, an unofficial 5.3a fixes file was made available by Jo French. See the About CA-Clipper 5.3a section for more details. BTW, Jo French uploaded the revised 5.3a fixes file on 20th November, 1996.

Latest News

The latest news is that CA has finally released the long-awaited 5.3b patch on 21 May, 1997.

For 5.3b users, you must a take a look at Jo French's comments on unfixed bugs in 5.3b.

BTW, have you used Click ? If you're a serious Clipperprogrammer and need an excellent code formatter, Click is a natural choice. How to get it ? Simple, access Phil Barnett's site via my Cool Clipper Sites.

32-bits Clipper for Windows ?

Have you tried Xbase ++ ? Well, I have and compared to Delphi (my current Windows programming tool of choice), I'm still sticking to Delphi.

Anyway, you should visit the Alaska Home Page. Give it a chance and then draw your own conclusions !.

The Harbour Project

Is this the future of Xbase ? Take a look at at the Harbour Project

You are Visitor # ...

According to counter.digits.com, you are visitor since 3 June 1996.

If you like or dislike what you see on this website, please drop me a line by clicking the email button at the bottom of this page or better still, by filling out the form in my guest book. If you are not sure what to write,click here to take a look at what other Clipperheads have to say.