Tim

Can the default column type be made user selectable - I'll probably never user CHAR but will very frequently use VARCHAR?

Roy Lambert

ps

The sooner altering a column definition allows you to actually alter it the better

Roy,

<< Can the default column type be made user selectable - I'll probably never
user CHAR but will very frequently use VARCHAR? >>

Sure, it can.  I'll add to the list of minor enhancements for the EDB
Manager.

<< The sooner altering a column definition allows you to actually alter it
the better >>

That's the standard, so it will stay for now.  If you want to change a
column's data type, then drop it and re-add it with the new type.  It will
pick up the old data now as of B6.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>That's the standard, so it will stay for now. If you want to change a
>column's data type, then drop it and re-add it with the new type. It will
>pick up the old data now as of B6.

I noticed that at least its a bit less painful

Roy Lambert

Roy,

<< I noticed that at least its a bit less painful >>

Yeah, especially since the EDB Manager keeps the old column's information,
so all you have to do is Drop, modify the column info, and then Add and Move
as required.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Yeah, especially since the EDB Manager keeps the old column's information,
>so all you have to do is Drop, modify the column info, and then Add and Move
>as required.

I'm guessing that's something we have to do for ourselves in an app? If so thanks for the code to crib from

Roy Lambert

Roy,

<< I'm guessing that's something we have to do for ourselves in an app? If
so thanks for the code to crib from >>

Yes, in your application you'll need to do the same.  However, I would
expect that you would know what the new column definition should look like
for the ADD COLUMN statement along with where you want to move it.   Keep in
mind also that the ADD COLUMN statement allows for an AT position at the
end:

http://www.elevatesoft.com/edb1sql_alter_table.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Yes, in your application you'll need to do the same. However, I would
>expect that you would know what the new column definition should look like
>for the ADD COLUMN statement along with where you want to move it. Keep in
>mind also that the ADD COLUMN statement allows for an AT position at the
>end:

Good, now all I need is to be able to figure out how to count columns - I was never able to get it right first time with DBISAM and I doubt I'll be any better with ElevateDB

Roy Lambert