topic Re: view table conditions in Application Development and Automation Discussions

view table conditions

Former Member — Tue, 28 Apr 2009 06:16:33 GMT

Hello Gurus,

For creating a view I am trying to join 2 tables.

I have selected 4 fields in first table and 3 fields in the second table.

The join condition is in such a way that the first table field(not primary) is input to second table primary field.

The first table field is of 10 char length and the input field in the second table primary field is 70 characters in length.

When we take the value in the first table field individually and give input in the second table it works. I.e., it works individually.

But when this data is seen using the view it doens't show any records, since the field length condition is not met.

Any solution on this.

Regards

Mac

Former Member — Tue, 28 Apr 2009 06:23:58 GMT

Hi,

the values of the two fields which you are trying to put in join condition are same in the both the tables,

check the entries in both the tables and specially for the fields you are putting a join,,

if the data does not match it will never give you results

Regards,

Siddarth

Former Member — Tue, 28 Apr 2009 06:25:22 GMT

Hi,

In the join condition try delimiting the lenght of 70 character field.

Hope this might help.

Regards,

Kritesh Shah

Former Member — Tue, 28 Apr 2009 14:37:24 GMT

Hi,

How can I delimit the length of 70 characters to 10 in the join conditions of the view.

Regards

mac

shahid_malayil1 — Sun, 03 May 2009 06:53:57 GMT

Hi Mac,

Check out this one

Best regards,

Shahid Malayil

Former Member — Wed, 16 Dec 2009 10:46:24 GMT

Solved myself