Subject Re: beginappend() Problem Fixed
From Lee Grant <camilee@nospam.comcast.net>
Date Sat, 1 Jul 2023 01:29:28 -0400
Newsgroups dbase.getting-started

Ken and Mervyn,

Further checking the code and then I did a couple of experiments to find
out something I hadn't realized before about the designer nuances.

If I drop a database table on the designer form, it creates the
"this.rowset = this.<tablename>.rowset" right in the code of the form
and in addition it writes the complete filename path into the sql
statement created by this process. It also doesn't create a database
object, it just creates a sql query object named the same as the table
and "select * <filepath>"

If I drop a database object and then a sql object on the designer form
and then change the properties of the objects to retrieve the same
table, there is no code like "this.rowset = this.<tablename>.rowset"
inserted in the code on saving. In addition, there is no filepath as
that I assume is because the alias is being pointed to by the database
object, so only the name of the table is named in the sql query object
"select * from <tablename>.dbf"

I'm sure I've seen this code variant, but I think I never really
connected them before. :(

Lee

On 7/1/2023 12:59 AM, Lee Grant wrote:
> Ken and Mervyn,
>
> I'm glad I asked and read your comments. It made me realize the mistake
> was on me. I had forgotten, that I'm using a container around the
> buttons and there is no set rowset for the form. I call it navbar and
> it's a collection of buttons with that container from my .cc file.
>
> It's a direct call to the rowset, to provide the actions.  I fixed it by
> making the hardline connect to the rowset itself to call the rowset
> functions/methods. I had been using form.rowset...but that was an
> improper object reference, which is what the error box was giving me. :(
>
> Lee
<snip>