Subject Re: beginappend() Problem Fixed
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Sat, 1 Jul 2023 05:16:20 -0700
Newsgroups dbase.getting-started

On 6/30/2023 11:02 PM, Lee Grant wrote:
> Ken,
 >
> I just confirmed that the designer does not write out that property
> assignment for a form unless the table it dropped on it straight from
> the Navigator like you show in the books.  I'll need to check the
> tutorials and the documentation to see if that if it ever mentioned that
> when creating a form and using a database object and query object to
> create the connection on a form (let alone a datamodule), to see if
> there is reference to having to manual do this step to create that link
> for the shortcut.  It's on me if I assumed, but really it's nothing I
> ever really thought about after starting to make forms. Obviously, many
> of the forms that I did use this way, I had to hard code the full rowset
> path to the buttons. Doh!! :)
If you are doing this by:

a) drag a database object to the surface from the Component Palette and
set the databaseName to one in the list using the inspector;
b) drag a query object to the surface from the Component Palette (note
that the database property is automatically set) and set the sql
property to something like "select * from tablename", you still get (I
did a really simple test here):

this.DATABASE1 = new DATABASE(this)
    with (this.DATABASE1)
       left = 3.0
       top = 1.0
       width = 6.0
       height = 1.0
       databaseName = "DBASESAMPLES"
    endwith

    this.QUERY1 = new QUERY(this)
    with (this.QUERY1)
       left = 13.0
       top = 1.0
       width = 4.0
       height = 1.0
       database = form.database1
       sql = "select * from fish"
    endwith

    this.rowset = this.query1.rowset



Note the last line of code. If you're not getting that, you're doing
something odd.

Ken

--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
dBASE DOS to Windows Tutorial:
http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm