Yes, that is similar to what I did, using amembers as per Dave's suggestion
Thank you too
Rafael
El 09/09/2011 13:23, Jack Skelley escribió:
> Rafael:
> I have used it something like this in the past:
>
> use s_player
> scatter name oPlayer memo
> amembers(laFields
Rafael:
I have used it something like this in the past:
use s_player
scatter name oPlayer memo
amembers(laFields, oPlayer)
for each mField in laFields
? mField, evaluate(mField), isnull(evaluate(mField))
endfor
use
Perhaps this will get the creative juices flowing...
Jack
Jack Skelley
Dave Crozier wrote:
> Use aMembers() to examine the scattered object, this will get you an array of
> the property names then they you can interrogate them using macro substitution
Huh - VFP just keeps getting better and better. Thanks, Dave.
___
Post
l Message-
> From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
> Rafael Copquin
> Sent: 09 September 2011 16:13
> To: profoxt...@leafe.com
> Subject: scatter name
>
> Say you scatter all fields of one record to an object, like so:
>
> select
Oops or what Dave said :)
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/pr
I think the only way you could do it is use Fcount() and Field() on the
base table to iterate through and retrieve each field name, and using
that use GetPem("fieldname" ... ) and IsNull() on the scattered object.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
September 2011 16:13
To: profoxt...@leafe.com
Subject: scatter name
Say you scatter all fields of one record to an object, like so:
select customers
locate for accno = '1234'
if found()
scatter name oCust memo
endif
and you want to know whether there is one or more fields containi
Say you scatter all fields of one record to an object, like so:
select customers
locate for accno = '1234'
if found()
scatter name oCust memo
endif
and you want to know whether there is one or more fields containing a
null value.
How do you scan the oCust object to search fo
memo name this' which adds the cursor column names/ values as properties of the
...
I missed this, what's myData's baseclass?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies
Sent: Friday, December 08, 2006 11:04 AM
To: [EMAIL PROTECTE
Lew Schwartz said:
>...you 'scatter ... name this additive' which is bound to create problems
imo.
why? - it is even suggested as a technique in Help!
>...Surely if you attempt to write to the properties named 'class',
'baseclass', 'name' etc... so
In all honesty, Andy, I don't use ca's and don't understand how or if
they contribute to this problem. Looking at the code you refer to below, I do
see that you 'scatter ... name this additive' which is bound to create problems
imo. The 'additive'
Andy Davies wrote:
> P.P.S my Les Pinter multiline 'grid' example doesn't show it, but if there
> are more records than will fit in the 'grid' there is a rather ugly ActiveX
> slider control for navigation - does anyone know of a vfp [slider] control
> that I could substitute?
>
>
Andy -- I've
Andy Davies wrote:
> For me the jury is still out on whether ca's offer anything over my
> previous hand-coded cursorsetprop stuff, but like Everest they're there so
> I thought I'd try them. It *is* useful to be able to create a quick form by
> dragging the ca (if I ever find the time I might try
Andy,
> does anyone know of a vfp [slider] control
As an alternative, check out Carlos's free scrollable container for VFP.
Requires VFP 9.
http://www.ctl32.com.ar
An awesome piece of work. Also checkout Carlos's other VFP components.
All free - all highly recommended!
Malcolm
_
P.P.S my Les Pinter multiline 'grid' example doesn't show it, but if there
are more records than will fit in the 'grid' there is a rather ugly ActiveX
slider control for navigation - does anyone know of a vfp [slider] control
that I could substitute?
Andrew Davies MBCS CITP
- AndyD 8-)#
7;t have the time to set up a test scenario to
check whether this behaviour is a general case or specific to something
about my form.
To sum up my experiences so far: I have found the cursoradapter plus
'scatter name this' object idea works well. My data design has so far
managed to ensu
L PROTECTED] On Behalf Of MB Software
Solutions
Sent: Thursday, December 07, 2006 2:06 PM
To: profox@leafe.com
Subject: Re: ca's with scatter name objects
Lew Schwartz wrote:
> I don't see what you're asking. The failures you encountered seem perfectly
> reasonable if you forg
Lew Schwartz wrote:
> I don't see what you're asking. The failures you encountered seem perfectly
> reasonable if you forget 'memo' with scatter. On the other hand, I've found
> scatter ... name this to be problematic since my this's ususally have
>
I don't see what you're asking. The failures you encountered seem perfectly
reasonable if you forget 'memo' with scatter. On the other hand, I've found
scatter ... name this to be problematic since my this's ususally have property
names (eg 'name') that
just a word of warning - don't do what I did: it just took me about 6 hours
to sort this one :-
I set up a ca to initially open with no data, so I did 'scatter name this
additive' from it in the init of my oData object
.. after the user edits some controls bound to oData... I
20 matches
Mail list logo
