Subject Re: beginappend() Problem Fixed From Lee Grant <camilee@nospam.comcast.net> Date Sat, 1 Jul 2023 02:02:50 -0400 Newsgroups dbase.getting-started 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!! :) Lee On 7/1/2023 1:29 AM, Lee Grant wrote: > 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 > <snip>