Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    10

    Unanswered: table designer question...

    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

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Oct 2004
    Posts
    10
    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))

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Oct 2004
    Posts
    10
    hey thanks..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •