dbTalk Databases Forums  

SQL Error (1217):

comp.databases.mysql comp.databases.mysql


Discuss SQL Error (1217): in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bruce
 
Posts: n/a

Default SQL Error (1217): - 01-12-2011 , 01:10 PM






What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), /* 1910 to Wisconsin */
(2,1) /* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) /* Wisconsin to Rock */
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) /* Rock to Porter */
;

Thank you....

Bruce

Reply With Quote
  #2  
Old   
Henrik Hartig
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 02:47 PM






bruce wrote:
Quote:
What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), /* 1910 to Wisconsin */
(2,1) /* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) /* Wisconsin to Rock */
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) /* Rock to Porter */
;

Thank you....

Bruce

I have no problem execute you're script.

It seems to me that you have an undeleted table with foreign key(s) in.
It would help if you took you're script and execute it line by line to
locate the error.
/henrik

Reply With Quote
  #3  
Old   
Jerry Stuckle
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:16 PM



On 1/12/2011 2:10 PM, bruce wrote:
Quote:
What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), /* 1910 to Wisconsin */
(2,1) /* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) /* Wisconsin to Rock */
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) /* Rock to Porter */
;

Thank you....

Bruce
Bruce,

Are you sure this is the script you are running? Which statement gets
the error?

The reason I ask is you the 1217 error indicates a violation of a
foreign key constraint, but you haven't defined any foreign keys.

Maybe it's failing on a DROP TABLE because a previous foreign key
constraint existed?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Reply With Quote
  #4  
Old   
bruce
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:16 PM



On Jan 12, 3:47*pm, Henrik Hartig <henrikhar... (AT) varmmail (DOT) dk> wrote:
Quote:
bruce wrote:
What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), * * /* 1910 to Wisconsin */
(2,1) * * */* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) * * */* Wisconsin to Rock **/
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) * * /* Rock to Porter * * **/
;

Thank you....

Bruce

I have no problem execute you're script.

It seems to me that you have an undeleted table with foreign key(s) in.
It would help if you took you're script and execute it line by line to
locate the error.
/henrik
When I run, using HeidiSQL, I get the error following
DROP TABLE IF EXISTS states;

So, I assume it's somehow related to this DROP TABLE.

If I manually DROP states, using HeidiSQL, then run the script, it
works fine. If I run it a 2nd time, without dropping the states table,
it fails, as before..

Did you try to run the script a second time??

Thank you for the response. (Mange Tak)

Bruce

Reply With Quote
  #5  
Old   
bruce
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:25 PM



On Jan 12, 4:16*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:
Quote:
On 1/12/2011 2:10 PM, bruce wrote:



What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), * * /* 1910 to Wisconsin */
(2,1) * * */* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) * * */* Wisconsin to Rock **/
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) * * /* Rock to Porter * * **/
;

Thank you....

Bruce

Bruce,

Are you sure this is the script you are running? *Which statement gets
the error?

The reason I ask is you the 1217 error indicates a violation of a
foreign key constraint, but you haven't defined any foreign keys.

Maybe it's failing on a DROP TABLE because a previous foreign key
constraint existed?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================
I'm running it under HeidiSQL. What is the syntax for running it from
the command line?

Thanks..

Bruce

Reply With Quote
  #6  
Old   
bruce
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:29 PM



On Jan 12, 4:25*pm, bruce <bruc... (AT) bellsouth (DOT) net> wrote:
Quote:
On Jan 12, 4:16*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:



On 1/12/2011 2:10 PM, bruce wrote:

What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), * * /* 1910 to Wisconsin */
(2,1) * * */* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) * * */* Wisconsin to Rock **/
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) * * /* Rock to Porter * * **/
;

Thank you....

Bruce

Bruce,

Are you sure this is the script you are running? *Which statement gets
the error?

The reason I ask is you the 1217 error indicates a violation of a
foreign key constraint, but you haven't defined any foreign keys.

Maybe it's failing on a DROP TABLE because a previous foreign key
constraint existed?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================

I'm running it under HeidiSQL. What is the syntax for running it from
the command line?

Thanks..

Bruce
I figured out the command line syntax and ran the script. I failed
with the same error...

Thanks...

Bruce

Reply With Quote
  #7  
Old   
Henrik Hartig
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:29 PM



bruce wrote:
Quote:
On Jan 12, 3:47 pm, Henrik Hartig <henrikhar... (AT) varmmail (DOT) dk> wrote:

When I run, using HeidiSQL, I get the error following

Don't know HeidiSQL
DROP TABLE IF EXISTS states;

So, I assume it's somehow related to this DROP TABLE.

If I manually DROP states, using HeidiSQL, then run the script, it
works fine. If I run it a 2nd time, without dropping the states table,
it fails, as before..

Did you try to run the script a second time??


Now I have. With no problem. You must have created table states with a
foreign key or constraint. If you execute the command
SHOW CREATE TABLE xxx

where xxx is the table(s) you can't drop, and post the result here I
might help you. I'm sure that you must have an "old" table with a
foreign key in. None of youre tables in youre script have a foreign key,
so it must have been an "old" table.


Quote:
Thank you for the response. (Mange Tak)


aha du er ogsċ dansker :-)
Bruce

/henrik

Reply With Quote
  #8  
Old   
Henrik Hartig
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:30 PM



Jerry Stuckle wrote:
Quote:
On 1/12/2011 2:10 PM, bruce wrote:
What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), /* 1910 to Wisconsin */
(2,1) /* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) /* Wisconsin to Rock */
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) /* Rock to Porter */
;

Thank you....

Bruce

Bruce,

Are you sure this is the script you are running? Which statement gets
the error?

The reason I ask is you the 1217 error indicates a violation of a
foreign key constraint, but you haven't defined any foreign keys.

Maybe it's failing on a DROP TABLE because a previous foreign key
constraint existed?

My point to
/henrik

Reply With Quote
  #9  
Old   
bruce
 
Posts: n/a

Default Re: SQL Error (1217): - 01-12-2011 , 03:33 PM



On Jan 12, 4:25*pm, bruce <bruc... (AT) bellsouth (DOT) net> wrote:
Quote:
On Jan 12, 4:16*pm, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote:



On 1/12/2011 2:10 PM, bruce wrote:

What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?

DROP TABLE IF EXISTS year2state;
DROP TABLE IF EXISTS state2county;
DROP TABLE IF EXISTS county2township;

DROP TABLE IF EXISTS years;
DROP TABLE IF EXISTS counties;
DROP TABLE IF EXISTS townships;

DROP TABLE IF EXISTS states;

CREATE TABLE years (
yearid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
year CHAR(4));

CREATE TABLE states (
stateid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
state CHAR(10));

CREATE TABLE counties (
countyid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
county VARCHAR(20));

CREATE TABLE townships (
townshipid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
township VARCHAR(20));

CREATE TABLE year2state(
yearid INT UNSIGNED NOT NULL,
stateid INT UNSIGNED NOT NULL);

CREATE TABLE state2county (
stateid INT UNSIGNED NOT NULL,
countyid INT UNSIGNED NOT NULL);

CREATE TABLE county2township (
countyid INT UNSIGNED NOT NULL,
townshipid INT UNSIGNED NOT NULL);

INSERT INTO states (state) VALUES
("Wisconsin");

INSERT INTO counties (county) VALUES
("Rock");

INSERT INTO years (year) VALUES
("1910"),
("1930");

INSERT INTO townships (township) VALUES
("Porter");

INSERT INTO year2state (yearid, stateid) VALUES
(1,1), * * /* 1910 to Wisconsin */
(2,1) * * */* 1930 to Wisconsin */
;

INSERT INTO state2county (stateid, countyid) VALUES
(1,1) * * */* Wisconsin to Rock **/
;

INSERT INTO county2township (countyid, townshipid) VALUES
(1, 1) * * /* Rock to Porter * * **/
;

Thank you....

Bruce

Bruce,

Are you sure this is the script you are running? *Which statement gets
the error?

The reason I ask is you the 1217 error indicates a violation of a
foreign key constraint, but you haven't defined any foreign keys.

Maybe it's failing on a DROP TABLE because a previous foreign key
constraint existed?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck... (AT) attglobal (DOT) net
==================

I'm running it under HeidiSQL. What is the syntax for running it from
the command line?

Thanks..

Bruce
I think I found the problem. I need to do some testing before I'm
sure.

I have another table in the database that DOES have "state" defined as
a foreign key. So, I'm sure that's the problem.

Thanks again...

Bruce

Reply With Quote
  #10  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Re: SQL Error (1217): - 01-13-2011 , 02:52 AM



El 12/01/2011 20:10, bruce escribió/wrote:
Quote:
What do I need to do get rid of the SQL Error (1217):Cannot delete or
update a parent row: a foreign key constraint fails from the following
script?
You need to remove the child table first or disable foreign key checks:

-- Disable check
SET @BACKUP_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS;
SET @@FOREIGN_KEY_CHECKS=0;

-- Do stuff here

-- Re-enable check
SET @@FOREIGN_KEY_CHECKS=@BACKUP_FOREIGN_KEY_CHECKS;
SET @BACKUP_FOREIGN_KEY_CHECKS=NULL;



--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.