Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • January 26, 2005 at 11:30 am in reply to: Copying table #16889
    glenn351
    Member

    When do you anticipate the release and will I be notified?. Will I have to pay for an upgrade?

    December 17, 2004 at 6:57 pm in reply to: Can't create foreign keys #16726
    glenn351
    Member

    Ok, here you go

    /*DDL Information For – ufa.u01_caspdepn*/

    Table Create Table

    u01_caspdepn CREATE TABLE `u01_caspdepn` (

    `CDEMSSN` char(9) NOT NULL default '',

    `CDECODE` char(1) NOT NULL default '',

    `CDECODE2` char(3) NOT NULL default '',

    `CDESSN` char(9) NOT NULL default '',

    `CDELAST` char(18) NOT NULL default '',

    `CDEFIRST` char(12) NOT NULL default '',

    `CDESEX` char(1) NOT NULL default '',

    `CDEEFF` char(8) NOT NULL default '',

    `CDEDROP` char(8) NOT NULL default '',

    `CDEDOB` char(8) NOT NULL default '',

    `CDECERT` char(8) NOT NULL default '',

    `CDERSENT` char(8) NOT NULL default '',

    `CDERCERT` char(8) NOT NULL default '',

    `CDEDOM` char(8) NOT NULL default '',

    `CDEDOD` char(8) NOT NULL default '',

    `CDEDIVRC` char(8) NOT NULL default '',

    `CDEDBLDT` char(8) NOT NULL default '',

    `CDEDBL` char(1) NOT NULL default '',

    `CDESCHOL` char(8) NOT NULL default '',

    `CDESTAT` char(1) NOT NULL default '',

    `CDECOB` char(10) NOT NULL default '',

    `CDEPAID` char(1) NOT NULL default '',

    `CDEOVR19` char(1) NOT NULL default '',

    `CDEFLAG1` char(1) NOT NULL default '',

    `CDEFLAG2` char(1) NOT NULL default '',

    `CDETCODE` char(1) NOT NULL default '',

    `CDECRDT` char(8) NOT NULL default '',

    `CDECSTAT` char(2) NOT NULL default '',

    `CDEFIL50` char(9) NOT NULL default '',

    `CDEOPER` char(3) NOT NULL default '',

    `CDECHGDT` char(8) NOT NULL default '',

    `CDECHGTM` char(4) NOT NULL default '',

    PRIMARY KEY (`CDEMSSN`,`CDECODE`),

    KEY `CDEMSSN` (`CDEMSSN`)

    ) ENGINE=InnoDB DEFAULT CHARSET=latin1

    /*DDL Information For – ufa.u01_caspenrl*/

    Table Create Table

    u01_caspenrl CREATE TABLE `u01_caspenrl` (

    `CENMSSN` char(9) NOT NULL default '',

    December 17, 2004 at 6:23 pm in reply to: Can't create foreign keys #16724
    glenn351
    Member

    The tables weren't created in SQLyog, they were ODBC imports.

    However, here's the statement from when I tried to create the relationship and it failed.

    /*[1:17:15 PM][ 551 ms]*/ alter table `ufa`.`u01_caspdepn` add foreign key (CDEMSSN) references `u01_caspenrl` (CENMSSN)

    And just so you know that they are InnoDB, here's from the Database info screen.

    u01_caspdepn InnoDB 9 Fixed

    u01_caspenrl InnoDB 9 Fixed

    December 17, 2004 at 4:56 pm in reply to: Can't create foreign keys #16722
    glenn351
    Member

    Yes, in fact I just upgraded this AM.

    December 16, 2004 at 2:33 pm in reply to: Error No 1043 Bad Handshake #16718
    glenn351
    Member

    Version 3.52

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)