I gave EDB Mgr another try.  FIrst attempt since first preview.

I was able to quickly add a database. This went very smooth.   I then
created a table. I added an integer a field and checked the Generated
check box. I then added a char type field.  When I clicked the ADD Col
button it gave me an expression error. I saw that the Generated box was
still checked.  I was sure I unchecked it when I added the new field,
but I unchecked it and tried again.  I could not get it to work until I
exited the table and went back in and added the new field.

--
David Farrell-Garcia
Whidbey Island Software, LLC

David,

<< I was able to quickly add a database. This went very smooth.   I then
created a table. I added an integer a field and checked the Generated
check box. I then added a char type field.  When I clicked the ADD Col
button it gave me an expression error. I saw that the Generated box was
still checked.  I was sure I unchecked it when I added the new field, but I
unchecked it and tried again.  I could not get it to work until I
exited the table and went back in and added the new field. >>

I will look into this.

--
Tim Young
Elevate Software
www.elevatesoft.com

David,

<< I was able to quickly add a database. This went very smooth.   I then
created a table. I added an integer a field and checked the Generated
check box. I then added a char type field.  When I clicked the ADD Col
button it gave me an expression error. I saw that the Generated box was
still checked.  I was sure I unchecked it when I added the new field, but I
unchecked it and tried again.  I could not get it to work until I
exited the table and went back in and added the new field. >>

I can't replicate what you're seeing.  I basically did this:

1) Entered an integer field called TestInt and added the column.
2) Entered a char(10) field called TestChar, clicked on the Generate check
box, and added the column.

Did you ever enter in a generation expression at all ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

>
>
> I can't replicate what you're seeing.  I basically did this:
>
> 1) Entered an integer field called TestInt and added the column.
> 2) Entered a char(10) field called TestChar, clicked on the Generate
> check box, and added the column.
>
> Did you ever enter in a generation expression at all ?

Hi Tim,

I did not want to generate a value for the Char field. That was the
problem.  It was fighting me to create the second field wihtout the
Generate box checked. I would uncheck it and then try to add the
column. I would then get the error, go back and the Generate box was
checked again.  Finally I closed the dialog, went back in and entered
the second column. I will try it again today to see if I can duplicate
it.



--
David Farrell-Garcia
Whidbey Island Software, LLC

Tim Young [Elevate Software] wrote:

>
>
> I can't replicate what you're seeing.

I can't seem to replicate this again now either.  I will keep my eye on
it to see if I can figure out what keystrokes I was doing to make it
fail.


--
David Farrell-Garcia
Whidbey Island Software, LLC

This is working fine for me now in buld 5.  

Suggestion:  After adding a col or constraint it would be nice to clear
the edit fields so that items are not carried over to the next
definition.  As it stands now you must be sure to clear Genrated
checkbox, Default Expressions and anything else that is left over from
the previous definition.


--
David Farrell-Garcia
Whidbey Island Software, LLC

David,

<< Suggestion:  After adding a col or constraint it would be nice to clear
the edit fields so that items are not carried over to the next definition.
As it stands now you must be sure to clear Genrated checkbox, Default
Expressions and anything else that is left over from the previous
definition. >>

The issue is that, after adding a column, the list view pointer is one the
column just added.  Therefore, we can't clear the information without
forcing the user to move off the current column and back on to it if they
want to alter something in the column they just added.

--
Tim Young
Elevate Software
www.elevatesoft.com