topic Re: Maintaining foreign key relationship between two servers in Application Development and Automation Discussions

Maintaining foreign key relationship between two servers

Former Member — Mon, 29 May 2006 05:29:15 GMT

Hi,

I am maintaining the Custom table in one server using SM30. Here i have to maintain the foreign key relationship with other table which lies in the some other server.

Is it possible to maintain the foreign key relation ship between two servers.

Expecting the reply from you soooon.

Thanks in Advance

Regards

Re: Maintaining foreign key relationship between two servers

Former Member — Mon, 29 May 2006 05:33:24 GMT

Hi,

You can maintain the parent child relation ship between the tables with in the same database.

You cannot have a relation with a table in a different server. You can implement it manually though, by writing the code to check values.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Maintaining foreign key relationship between two servers

Former Member — Mon, 29 May 2006 06:02:06 GMT

Hi rajasekhar,

1. Directly, using DATA Dictionary foreign-key relationships,

its not possible.

(Database does not allow such facility, so far)

2. I am maintaining the Custom table in one server using SM30

If this is the case, then

u can use events in SM30

so that while saving the record,

u can write your own code,

which will check the values in the REMOTE Server,

using some your own Z FM and using DESTINATION extension.

3. In this way, u can indirecty maintain

the foreing key relationship between two servers,

and two tables.

regards,

amit m.

Re: Maintaining foreign key relationship between two servers

Former Member — Mon, 29 May 2006 06:12:56 GMT

GOOD

I DONT THINK YOU CAN CREATE THE FOREIGN KEY RELATIONSHIP BETWEEN TWO SERVERS.

THANKS

MRUTYUN