hi all,

when i create a table with the wizard, i can later go in thru the
table designer & change data types.

however, after i create a table with sql, the designer will not
allow any changes.

any reason for this?

tia

What's your CREATE TABLE statement? Are you able to edit any fields?
DUmb question, why are you creating a table them modifying it? Why not make the changes in the SQL and create it that way?

i am able to edit field contents just not the fields themselves...

i'm in design stages of these tables, plus i guess i'm what you'd call
a newbie with pervasive...i wanted to experiment with all methods
available to the developer & noticed the differences..

i'm not quite sure what you mean in the last part of your reply,
are you saying not to bother with the wizard? i sort of prefer doing
things manually anyway unless a wizard is a real timesaver..

thanks..

here's my create table statement:

create table MyTestAppts
(ApptID IDENTITY,
CustID int,
CustomerNumber char(20),
NotesID int,
CustOnFile char (1),
ApptDate char (10),
ApptMonth int,
ApptDay int,
ApptYear int,
ApptTime char (8),
BegTimeSlot int,
NumberOfSlots int,
Crew int,
Zone char (20),
NumberOfUnits int,
ApptInsertDate date,
ApptInsertTime time,
Filler1 char (10),
Filler2 char (10),

PRIMARY KEY (ApptID))

I just tried your query here and I see the same behavior. I then noticed the "PRIMARY KEY" clause. That's what's keeping you from modifying the table. Because you're enabling Referential Integrity constraints, you can't modify the table without removing them. As a test, I removed the PRIMARY KEY clause and was able to modify the table.

hey thanks..