Subject Re: how left() works in dbase 11 plus
From Agostinho <Agostinhoteixeira@yahoo.com > <Agostinho <Agostinhoteixeira@yahoo.com >>
Date Mon, 31 May 2021 07:46:35 -0400
Newsgroups dbase.getting-started

Good morning Akshat
Thank you for your comments
and have a nice day
Agostinho


Akshat Kapoor Wrote:

> Good Afternoon AGOSTINHO,
 >
> > find &ccode
 > >     yn=" "
 > >     if .not. found() .or. eof()
 > >      ?chr(7)
 > >      @23,05 say 'Customer name not found   ,Add new Customer to the list? Y/N !'
 > >      get yn
 > >      read
 > This reminds me of my working with foxpro. And the coincidence is that
> for such situation even I had a variable named 'yn'
 >
> >
> >   function ENTRYFIELD4_onKey(nChar, nPosition,bShift,bControl)
 > >        form.clients1.params['ag'] = '%'+this.value+'%'
 > >        form.clients1.requery()
 > >                 if form.entryfield4.value<9999 .and. form.clients1.rowset.endofset
 > >                    if msgbox( "Add New Customer?", " ", 36 ) == 6
 > >                        form.rowset.beginAppend()
 > >                                  form.rowset.fields["code"].value = form.entryfield4.value
 > >                                  form.rowset.save()
 > >                         endif
 > >                  endif
 > >        return
 > >
>
> The new approach is totally different but much better I think.
 > Regards
 > Akshat