Tipos de relaciones de Foreign key en mysql y phpmyadmin y ejemplo de sintaxis

Los tipos de relaciones que pueden establecerse vienen definido por:

(fuente: http://stackoverflow.com/questions/459312/setting-up-foreign-keys-in-phpmyadmin)

CASCADE

Whenever rows in the master (referenced) table are deleted (resp. updated), the respective rows of the child (referencing) table with a matching foreign key column will get deleted (resp. updated) as well. This is called a cascade delete (resp. update[2]).

RESTRICT

A value cannot be updated or deleted when a row exists in a foreign key table that references the value in the referenced table. Similarly, a row cannot be deleted as long as there is a reference to it from a foreign key table.

NO ACTION

NO ACTION and RESTRICT are very much alike. The main difference between NO ACTION and RESTRICT is that with NO ACTION the referential integrity check is done after trying to alter the table. RESTRICT does the check before trying to execute the UPDATE or DELETE statement. Both referential actions act the same if the referential integrity check fails: the UPDATE or DELETE statement will result in an error.

SET NULL

The foreign key values in the referencing row are set to NULL when the referenced row is updated or deleted. This is only possible if the respective columns in the referencing table are nullable. Due to the semantics of NULL, a referencing row with NULLs in the foreign key columns does not require a referenced row.

SET DEFAULT

Similar to SET NULL, the foreign key values in the referencing row are set to the column default when the referenced row is updated or deleted.


Ejemplo de sintaxis FK:


ALTER TABLE  `usuarios_planes` ADD FOREIGN KEY (  `fk_plan` ) REFERENCES  `planes` (

`id`
) ON DELETE RESTRICT ON UPDATE RESTRICT ;

Tabla de KeyCodes javascript útil para para eventos javascript como keydown..

100%style="font-size: 26px; margin: 15px 0px 10px;"> Key Code Table

The "Key Down" event is supported from ForeUI V2.10, also we can check the "Current_Key_Code" system property to know which key is currently pressed. The key code table below is very useful when you want to test key code value in condition expression.

0		10		20	Caps Lock	30		40	Arrow Down
1		11		21		31		41
2		12		22		32		42
3		13	Enter	23		33	Page Up	43
4		14		24		34	Page Down	44
5		15		25		35	End	45	Insert
6		16	Shift	26		36	Home	46	Delete
7		17	Ctrl	27	Esc	37	Arrow Left	47
8	Backspace	18	Alt	28		38	Arrow Up	48	0
9	Tab	19	Pause/Break	29		39	Arrow Right	49	1
50	2	60		70	f	80	p	90	z
51	3	61	=+	71	g	81	q	91	Windows
52	4	62		72	h	82	r	92
53	5	63		73	i	83	s	93	Right Click
54	6	64		74	j	84	t	94
55	7	65	a	75	k	85	u	95
56	8	66	b	76	l	86	v	96	0 (Num Lock)
57	9	67	c	77	m	87	w	97	1 (Num Lock)
58		68	d	78	n	88	x	98	2 (Num Lock)
59	;:	69	e	79	o	89	y	99	3 (Num Lock)
100	4 (Num Lock)	110	. (Num Lock)	120	F9	130		140
101	5 (Num Lock)	111	/ (Num Lock)	121	F10	131		141
102	6 (Num Lock)	112	F1	122	F11	132		142
103	7 (Num Lock)	113	F2	123	F12	133		143
104	8 (Num Lock)	114	F3	124		134		144	Num Lock
105	9 (Num Lock)	115	F4	125		135		145	Scroll Lock
106	* (Num Lock)	116	F5	126		136		146
107	+ (Num Lock)	117	F6	127		137		147
108		118	F7	128		138		148
109	- (Num Lock)	119	F8	129		139		149
150		160		170		180		190	.>
151		161		171		181		191	/?
152		162		172		182	My Computer	192	`~
153		163		173		183	My Calculator	193
154		164		174		184		194
155		165		175		185		195
156		166		176		186		196
157		167		177		187		197
158		168		178		188	,<	198
159		169		179		189		199
200		210		220	\|	230		240
201		211		221	]}	231		241
202		212		222	'"	232		242
203		213		223		233		243
204		214		224		234		244
205		215		225		235		245
206		216		226		236		246
207		217		227		227		227
208		218		228		238		248
209		219	[{	229		239		249

Fuente: http://www.foreui.com/articles/Key_Code_Table.htm

Identificar la codificación de un código de barras

Gracias a la página: http://barcode.tec-it.com/es podemos introducir el dato que queremos visualizar y generar online un código de demostración de diferentes tipos para comprar con nuestro código a identificar.

¡Prueba y error y a comparar!

Solución al Error 1001 registrando un servicio de windows con installShield LE y visual studio 2013

Después de horas de pelea instentando instalar un servicio de windows con el installShield LE (limited edition) y visual studio 2013 siempre obtenía "error 1001" durante el intento de registro del servicio en el sistema. He pasado horas buscando por foros, web oficial.... y al final el error era:

¡¡En la pestaña 'Service' de installShield al crear el servicio DEBE TENER EL MISMO NOMBRE QUE LA PROPIEDAD 'SERVICENAME' DEL SERVICIO!!



Los pasos hasta llegar a este punto se pueden seguir en el artículo:

Crear un servicio en windows c# con visual studio

Crear instalación de servicio de windows con installShield LE

Información de interes de la pagina oficial de la empresa creadora de installShield Flexera

fuente: https://community.flexerasoftware.com/showthread.php?193911-Error-1001-during-installation

Thread: Error 1001 during installation

• InstallShield 2010
• Error 1001 during installation

• Thread Tools

• Display

1. 06-24-2010, 02:02 AM#1

   konanedojawa 

   New User (0 Posts)
   

   Join Date

   Jun 2010

   Posts

   3

   Error 1001 during installation

   I'm new in installshield , i created basic msi project using installshield 2010 .. build is succeeded , but unofrortunately when i tried to install the application and when it is about to finish the installtion , it gets two errors "Error 1001" then the installation rollback .. i wasted alot of time searching for a solution for that error , but i failed 
   
   can any one help me 
   thanks in advance

   Reply With Quote
2. 06-24-2010, 02:07 PM#2

   
   

   MichaelU 

   InstallShield Software Engineer
   

   Join Date

   Jan 2004

   Location

   Schaumburg, IL

   Posts

   4,683

   Error 1001 is often due to a problem in a .NET Installer Class. Unfortunately for .NET Installer Classes this single error code corresponds to several different underlying problems. In general I prefer to avoid use of .NET Installer Classes because they do not conform well with Windows Installer best practices.

   Michael Urman - Staff Software Engineer - Flexera Software: InstallShield Team

   Reply With Quote
3. 06-30-2010, 03:12 AM#3

   konanedojawa 

   New User (0 Posts)
   

   Join Date

   Jun 2010

   Posts

   3

   

   but i'm using the installer class to attach the db used by my application , is there a way instead of installer class to attach the db ??!!
   
   thanks for reply

   Reply With Quote
4. 06-30-2010, 01:52 PM#4

   bashenfelter 

   User (5+ Posts)
   

   Join Date

   Jun 2010

   Posts

   5

   Two issues I ran into using installer classes that resulted in getting the "1001" error:
   

   1. Make sure the correct version of InstallUtilLib.dll is installed in the MSI. If installing on a 32-bit OS, you'll need the 32-bit version. If installing on a 64-bit OS, you'll need the 64-bit version. Search the InstallShield help for where you specify the version of InstallUtilLib.dll.
   2. Within your installer class make sure you call the base class method of every method you're overriding. For example, in your Install() method, make sure the first thing you do is call base.Install().

   
   
   Other than that, I would simplify my installer class to determine if it's a problem with the installer loading the class vs. a problem with the logic inside the class. Adding some logging inside your installer class helps too.

   Reply With Quote
5. 07-05-2010, 06:56 AM#5

   konanedojawa 

   New User (0 Posts)
   

   Join Date

   Jun 2010

   Posts

   3

   

   for installutillib.dll , i didn't find in installshield help what is the correct version for my OS , i have windows xp professional and i'm using installutill version "2.0.50727.3053 " , is that right? 
   
   for the installer class i'm sure that i call the base class method of every method i'm overriding
   
   thanks

   Reply With Quote
6.