Subject Re: field name error From Lee Grant <camilee@nospam.comcast.net> Date Sat, 17 Feb 2024 15:42:41 -0500 Newsgroups dbase.getting-started Mervyn, Thanks a lot. I was thinking of doing something like this for myself, and now that I see some workable code to do it, you've just added another project to my list of things to get done. :( Argghhh. :) Lee On 2/17/2024 5:19 AM, Mervyn Bick wrote: <snip> > > When I first started with OODML all those years ago there was help > aplenty in the newsgroups but I found I got so much from little working > turnkey examples posted by Marko Mihorko that could be run immediately. > Working code that could basically be cut and pasted with very few > changes suited this card carrying member of the "Monkey see, monkey do" > school of programming down to the ground. > > When I eventually reached the stage that I could offer help to others in > the newsgroups I decided that I too would create turnkey examples. > Writing the necessary code by hand to create and populate a table became > a chore so I wrote a little program to stream out code to create the > required table and insert some data. > > A stripped down version of the program is attached. Instead of streaming > out code for use in an example it actually uses the "create table" code > to create the table. You can uncomment the print statement if you want > to see the code generated. > > You are welcome to use the program but be aware that it was never meant > to be used by others.   There is no dropdown list of field types, there > is no error checking and I never did get the  program to create a Double > type field so in the end I removed the option  and included F for float > which is the SQL equivalent.  I had already use L fr a logical type > field so I left out the Long type and included I for Integer. > > The program definitely has warts but it should be better than writing > "create table ..." code by hand. > > Mervyn. >