Re: Updating column property on table gives error

Thanks for the feedback. I'm sorry I was never able to get back to this.


Uwe wrote:
Hi Bob;
I just wanted to let you know that I finally got everything working.
One of the reasons for the error has to do about which property you
attempt to update. e.g. if you attempt to update the nullable
property of a boolean column you'll get an error when you append the
column. Same for the Seed and increment values, they only apply to an
autoincrement column.
It would be nice if the error happened at the time the property is
updated
in code instead of when the append happens.
Thanks for your help.

Thanks.
I rooting around I discovered that there may be an easier way with
Select. "SELECT * INTO NewTable FROM TableToCopy WHERE 1=0"
do a connect.execute strsql
This does copy the structure only, but without any indexes. The
trick now would be to figure how to make it work with 2 databases
where the FROM is the template DB and the TO the application db.

I tried the following where the
"SELECT * INTO control FROM control IN
'D:\Vetdrv\sahData\srtemplate.mdb' WHERE 1=0;"
but I get an error 424 Object required
--
Thanks,
Uwe


"Bob Barrows [MVP]" wrote:

Uwe wrote:
Thanks for all the time you have taken on this.
I have the append column working, but as I mentioned updating the
column properties is a problem.
Below is the code as I ran it just now with debug output to show
you exactly what I am facing.


If nobody replies before I go home from work tonight, I will see
what i can come up with when I get home.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will
get a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.