Hi All!

I am working on a form where I need to get the value of the generator
and put it in a variable to display in an edit box on the form. I am
using the generator as a receipt number and want to allow the user to
change the receipt number(receipt number is not the key to the
file). They can then edit the number and I can set the generator to
the new value.

The problem is that my sql code is saying the my generator is not
defined.

UPDATE Form SET Variable = GEN_ID(Generator_GEN,0) WHERE FILEKEY = 1

Please help.

Kristy