Skip to Content
0
Former Member
Aug 31, 2009 at 10:52 AM

Entries fetched from table are not similar in diffrent servers.

63 Views

Hello Experts,

I have a scenaio wherein I have to print the fax numbers in the smartforms.

The code worked well in development but it failed for some cases in Quality and Production.

The piece of code is as follows:

select single adrc~FAX_NUMBER ADRC~FAX_EXTENS
  into (fax, ext)
  from t001w
    join adrc on adrc~name1 = t001w~name1
  where t001w~werks = <fs>-werks.

I debugged it and found out that there are multiple extries for the same name in table ADRC.

But the problem is that though all the three servers are in sync. i.e. contains the same entries in

table ADRC but the entry that is fetched in development is not same as that of Quality or Production.

I know that there is no specific way for fetching the entries in from database but can anyone tellme

the diffrence in fetching, though all the three servers contains the same entries and in same ordr as well.