I downloaded the free windows rekall from totalrekall.co.uk and it seems to
run just fine. I created some forms for some text tables, and they wouldnt
do add or save. It was only when I defined a table with one primary key, and
several fields, and then created a form with ever field EXCEPT the primary
key. Then it added records just fine. The error I was getting
involved putting the primary key in the form. It seems like when it goes to add
or save a record, then it assumes that the primary key is NOT on the form, and
if it IS, then you get a sql error of the same field mentioned twice. When
you leave the primary key off of the form, then it is automatically included in
the insert sql statement, and seems to be a series type autoincrement
field.
I must say, I am quite confused by the two opposing companies. But, I guess
I shall see how much I may accomplish with the FREE windows rekall, and
meanwhile wait for the dust to settle regarding the various rekall companies
before I invest in a non-free version.
Apparently Novell is going great guns to support Rekall as a substitute for
M$ Access.
|