Mistake #sql-9c8_21" (errno: 150)

Mistake #sql-9c8_21" (errno: 150)

am 22.05.2009 16:22:16 von HINOJO RUELAS ARTURO

------_=_NextPart_001_01C9DAE9.5B40CDDC
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C9DAE9.5B40CDDC"


------_=_NextPart_002_01C9DAE9.5B40CDDC
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hpe you are doing well, and Trying to create a FK from "evaluacion"
table to "seccion" table I got this error message, does anybody knows
how to solve this, anyone have heard about this mistake, any help on
this will be really appreciated.

=20

=20

=20

=20

Saludos

=20

Arturo Hinojo=20

NO imprimas este correo a menos que sea necesario.

Please consider the environment before printing this page.

=20


------_=_NextPart_002_01C9DAE9.5B40CDDC
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">










Hpe you are doing well, and Trying to create a FK =
from “evaluacion”
table to “seccion” table I got this error message, does =
anybody
knows how to solve this, anyone have heard about this mistake, any help =
on this
will be really appreciated.



 



 



src=3D"cid:image001.png@01C9DABE.52E1A210">



 



style=3D'font-size:9.0pt;font-family:"Arial","sans-serif"'>S aludos o:p>



style=3D'font-size:9.0pt;color:#1F497D'> =
style=3D'text-decoration:none'> 

=


style=3D'font-size:9.0pt;color:#1F497D'>Arturo
Hinojo



style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";
color:green'>  NO imprimas este correo a menos que sea
necesario.
style=3D'font-size:28.0pt;font-family:
Webdings;color:green'>



style=3D'font-size:7.5pt;font-family:"Arial","sans-serif";
color:green'> 
style=3D'font-size:7.5pt;font-family:
"Arial","sans-serif";color:green'>Please consider the environment before
printing this page.



 









------_=_NextPart_002_01C9DAE9.5B40CDDC--

------_=_NextPart_001_01C9DAE9.5B40CDDC--

RE: Mistake #sql-9c8_21" (errno: 150)

am 22.05.2009 20:22:10 von Martin Gainty

--_c4fe2ad1-39b3-4636-8e7b-c321e7d99479_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


no puedo ver la disposici=F3n atada del esquema de la exhibici=F3n de la
imagen. .please de la tabla relevante y crear la tabla=2C cree las
declaraciones del =EDndice

Saludos Cordiales desde EEUU!
Martin=20
GMT+5(por la semana)
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..




Subject: Mistake #sql-9c8_21' (errno: 150)
Date: Fri=2C 22 May 2009 09:22:16 -0500
From: ARTURO.HINOJO@inegi.org.mx
To: mysql@lists.mysql.com



















Hpe you are doing well=2C and Trying to create a FK from =93evaluacion=94
table to =93seccion=94 table I got this error message=2C does anybody
knows how to solve this=2C anyone have heard about this mistake=2C any help=
on this
will be really appreciated.

=20

=20



=20

Saludos

=20

Arturo
Hinojo=20

NO imprimas este correo a menos que sea
necesario.

Please consider the environment before
printing this page.

=20


____________________________________________________________ _____
Hotmail=AE has a new way to see what's up with your friends.
http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=3DTXT_ TAGLM_WL_HM_Tut=
orial_WhatsNew1_052009=

--_c4fe2ad1-39b3-4636-8e7b-c321e7d99479_--

RE: Mistake #sql-9c8_21" (errno: 150) SOLVED.

am 22.05.2009 21:06:02 von HINOJO RUELAS ARTURO

------_=_NextPart_001_01C9DB10.62B01791
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello Martin/Michael, I have recreated all relationships one important =
thing is when I made reverse engineer in MicroOLAP database Designer, =
and create the script for these tables and relationships in some cases =
the fields are defined as "Not Unsigned Not NULL" when I delete "Not =
Unsigned" in all tables, Problem gone.

Now I have created all FK for each table.

=20

Thank you so much for your attention.

Really Appreciate your Help.

=20

Saludos

=20

Arturo Hinojo=20

=20

De: Martin Gainty [mailto:mgainty@hotmail.com]=20
Enviado el: Viernes, 22 de Mayo de 2009 01:22 p.m.
Para: HINOJO RUELAS ARTURO; mysql@lists.mysql.com
Asunto: RE: Mistake #sql-9c8_21' (errno: 150)

=20

no puedo ver la disposici=F3n atada del esquema de la exhibici=F3n de la =
imagen. .please de la tabla relevante y crear la tabla, cree las =
declaraciones del =EDndice

Saludos Cordiales desde EEUU!
Martin=20
GMT+5(por la semana)
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de =
confidentialit=E9

=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene =
Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede =
unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. =
Diese Nachricht dient lediglich dem Austausch von Informationen und =
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten =
Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt =
uebernehmen.

Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous =
n'=EAtes pas le destinataire pr=E9vu, nous te demandons avec bont=E9 que =
pour satisfaire informez l'exp=E9diteur. N'importe quelle diffusion non =
autoris=E9e ou la copie de ceci est interdite. Ce message sert =E0 =
l'information seulement et n'aura pas n'importe quel effet l=E9galement =
obligatoire. =C9tant donn=E9 que les email peuvent facilement =EAtre =
sujets =E0 la manipulation, nous ne pouvons accepter aucune =
responsabilit=E9 pour le contenu fourni.







________________________________

Subject: Mistake #sql-9c8_21' (errno: 150)
Date: Fri, 22 May 2009 09:22:16 -0500
From: ARTURO.HINOJO@inegi.org.mx
To: mysql@lists.mysql.com

Hpe you are doing well, and Trying to create a FK from "evaluacion" =
table to "seccion" table I got this error message, does anybody knows =
how to solve this, anyone have heard about this mistake, any help on =
this will be really appreciated.

=20

=20

=20

=20

Saludos

=20

Arturo Hinojo=20

NO imprimas este correo a menos que sea necesario.

Please consider the environment before printing this page.

=20

=20

________________________________

Hotmail=AE has a new way to see what's up with your friends. Check it =
out. =
Tutorial_WhatsNew1_052009>=20


------_=_NextPart_001_01C9DB10.62B01791--