I need to eat and learn VDB7.01 at the same time
Derek Fawell
Thanks for the previous help in starting VDB7.01, I appreciate it.
I have read Alan Katz's How to do it several times and with each reading
the dimmer switch in my brain goes up a fraction.
Ken M's, Vesper7 is a great help and inspiration.
I need to understand some things further :-
i) Syntax. Can I get a set of rules ( written for an idiot ) which
unravels things like 'parent.parent.etc or tells me how and why?
ii) I can't relate the routines that calculate, update and replace in
early dDbase with 7.01 eg :-
sele 1
use customer
sele 2
use sales
sele 1
go top
do while .not. eof()
store 0.00 to mbalance
store cust to mcust
sele 2
seek mcust
do while cust=mcust .and. .not. eof()
store mbalance+debit+credit-paid to mbalance
skip
enddo
sele 1
replace balance with mbalance
skip
enddo
sorry that the code is a bit crude, but you get the idea.
The relationship between 'form.datamod1.ref.customer1.rowset' and the
above is light years apart, especially as I don't have a 'customer1.dbf'
and don't know the referential syntax to do and replace the values in the
customer database.
On the other hand I am amazed at the power of the layered systems of the
classes and each day brings more joy.
Perhaps I should get a proper job.
Regards
Derek
George Burt
>unravels things like 'parent.parent.etc or tells me how and why?
Try some simple examples that don't involve any tables at all. Start with
buttons. Put a couple buttons on a form and get them to talk to each other.
Have them change each others colors, sizes positions etc. (attach code to
the button's Onclick method). Then try using other events like MouseMove so
that when the mouse moves over a button, it changes the other button's
color. Next, put a container on the form and drop a couple buttons there.
Now make the buttons inside the container talk to ones out side the
container and vice versa. Master the buttons and their relationship to each
other. Learn about all their properties. When you understand how to
control one kind of object, the others are much easier to learn. Post
questions here often, even if they are very basic. People that are a little
ahead of you get great satisfaction from being able to help others out.
That's the way it works here.
Good luck,
George Burt
Gary White
> Thanks for the previous help in starting VDB7.01, I appreciate it.
Ken is working on a new HOW document that should enlighten you. Keep
an eye out here. He'll post an announcement, I'm sure. I don't think
it will be too long coming.
Gary
Some dBASE Stuff at
http://www.AppTools.com/dbase
Jens Alrø
beginners.
Jens
Gary (Gary White) skrev i meddelelsen
<366980af...@forums.borland.com>...
Lorrie Rea
parent.
You could say in the form onOpen method :
this.rCustomer = form.datamod1.ref.customer1.rowset
since you are in the form onOpen 'this' refers to the
form. i tend not to use the 'form' word because i read
something somewhere which put me off using it.
from here on you can refer to ;
form.datamod1.ref.customer1.rowset as <form>.rCustomer
the question then is where are we in relation to the
<form> when we want to refer to rCustomer. If we are in
a button method and the button is on the form then
'form' is the parent of the button - hence - :
this(the button).parent(the form).rCustomer
this.parent.rCustomer.fields["fieldname"].value =
<newvalue>
try and work out where you are in relation to the
'form' and how deep (how many parent(s)) you need to go
to get where you want to be.
you could have a method on the form like:
do while (not this.rCustomer.endOfSet)
this.rCustomer.fields["mbalance"].value = ;
this.rCustomer.fields["mbalance"].value+((debit+credit)-paid)
this.rCustomer.next()
enddo
the question now is where is debit, credit and paid
if they are in the same table then:
this.rCustomer.fields["debit"].value
if it was declared in the form onOpen as :
this.debit = 0.00
then :
this.rCustomer.fields["mbalance"].value +=((this.debit
hope this helps rather than confuses more!!!
"Derek Fawell" <DFa...@Compuserve.com> wrote:
> The relationship between 'form.datamod1.ref.customer1.rowset' and the
>above is light years apart, especially as I don't have a 'customer1.dbf'
>and don't know the referential syntax to do and replace the values in the
>customer database.
--
Regards ...
Lorrie Rea (Mr.) - Northern Rivers - (Northern) NSW Australia
Ken Mayer [TeamB]
>Ken is working on a new HOW document that should enlighten you. Keep
>an eye out here. He'll post an announcement, I'm sure. I don't think
>it will be too long coming.
Yeah, but I'm hoping you can find some time to help me edit the last
three sections ... <G> (it's nearly there, folks!)
Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm
Howard Mintzer
dbase 5 for dos i was overwhelmed with all of the properties and methods so that
i didn't even attempt to use them. I finally switched to vdb 5.5 and then vdb7.
At first working with rowsets and parent.parent etc was EXTREMELY confusing. I
kept posting what I thought were the dummest questions in this ng. However by
reading the ng, the HOW's and looking at other people's codes I feel I've finally
left the steep part of the learning code and am now impressing myself with what I
can write in a very short time.
As daunting as it may seem, once you start to get a hang for it, things will
come very quickly. I specially liked the suggestion you got to put buttons on a
form and get them to talk to and change each other. Its fun to do and really
teaches you alot. Team B and all the others who help on this list are great..they
are so helpful. I can truly say that unlike dbase dos (which I taught myself with
only the help of an occasional call to AshtonTate tech support), without these
TeamB guys vdb would be totally useless to me..i don't know how i'd ever learn to
use it without their advice.
BTW I've got to be a practicing veterinarian, run two hospitals, maintain
computer networks at both hospitals, and try to get out the new vdb programs to
replace my old dbase 5 dos programs that I've been promising my staff for a
year...oh, i eat once in a while too :-)
Howie
Derek Fawell wrote:
> From Derek
>
> Thanks for the previous help in starting VDB7.01, I appreciate it.
>
> I have read Alan Katz's How to do it several times and with each reading
> the dimmer switch in my brain goes up a fraction.
>
> Ken M's, Vesper7 is a great help and inspiration.
>
> I need to understand some things further :-
>
> i) Syntax. Can I get a set of rules ( written for an idiot ) which
> unravels things like 'parent.parent.etc or tells me how and why?
>
> ii) I can't relate the routines that calculate, update and replace in
> early dDbase with 7.01 eg :-
> sele 1
> use customer
> sele 2
> use sales
> sele 1
> go top
> do while .not. eof()
> store 0.00 to mbalance
> store cust to mcust
> sele 2
> seek mcust
> do while cust=mcust .and. .not. eof()
> store mbalance+debit+credit-paid to mbalance
> skip
> enddo
> sele 1
> replace balance with mbalance
> skip
> enddo
>
> sorry that the code is a bit crude, but you get the idea.
>
> The relationship between 'form.datamod1.ref.customer1.rowset' and the
> above is light years apart, especially as I don't have a 'customer1.dbf'
> and don't know the referential syntax to do and replace the values in the
> customer database.
>
Gary White
> Gary (Gary White) wrote:
>
> >Ken is working on a new HOW document that should enlighten you. Keep
> >an eye out here. He'll post an announcement, I'm sure. I don't think
> >it will be too long coming.
>
> Yeah, but I'm hoping you can find some time to help me edit the last
> three sections ... <G> (it's nearly there, folks!)
I plan on spending some more time on it today. <G>
Ken Mayer [TeamB]
>I plan on spending some more time on it today. <G>
Ah, then I better not post it just yet, eh? (By the bye, it appears
that you may have gotten the file, but not with the correct filename
-- dunno what happened, but my email at work did that to me here ...
check the directory for downloads and see if you get anything that
looks like the subject of the message, and rename it to something
appropriate.ZIP ...)
Alex Blaivas
guys. - Alex Blaivas, PP. PP stands, BTW, for Practicing Psychiatrist.