"first" was apparently the problem. I tried "firstnm" and lastnm" and was able to set up the table.
I ran into a number of problems trying to import data from a text file. The import
wizard window didn't redraw properly, making it difficult to figure out what was going on. But I eventually got through it, only to throw an exception at
finish. I think the problem was that the primary key column
table4id was not filling properly in the new record creation. Then I went back and tried to fix that but it wouldn't let me change the primary key.
Thank you very much for your help here. I am impressed that you have been so prompt and thorough in helping me get going. I really think Servoy has
very great potential but at the moment it seems too rough for me to make use of. I will try again once the project is a bit further along.
jaleman wrote:It looks like first and last are reserved words in Firebird, can you try to use different column names to see if that solves the problem? If it solves let us know so we can add it to the reserved words list that will automatically warn when you try to use them.
We are working on a Quick Start guide that will be released very soon. That guide will provide a step by step introduction to using Servoy.