Re: autoNextRecord when the defined primarykey also a masterlink

--===============1598038649==
Content-Type: multipart/alternative; boundary=20cf3054a7b5ec16f8049d594125

--20cf3054a7b5ec16f8049d594125
Content-Type: text/plain; charset=ISO-8859-1

I think I sort of figured out what the error was. I had defined the
master/detaillink as:
<datasource name="dts_invoice" connection="test" table="invoice"
master="dts_purchaseOrder" masterlink="id" detaillink="uid_po"/>

and also used the fk_key in the block referring to a different column.:
<block name="blk_invoice" datasource="dts_invoice">
<field name="uid_po" field="uid_po"  fk_source="dts_purchaseOrder"
fk_key="id" fk_description="po" required="Y"  />

First of all, I should not have set fk_description=po, after having set it
to "id" in the master/detail. Though removing the fk_description did not
help, using the fk_source and fk_key was not required in the first place. So
I removed that and all I'm fine now.

Thanks Reinhard for looking into this.

On Sun, Feb 27, 2011 at 9:08 PM, Kishan Bhat <[email protected]> wrote:

> I have attached my full gfd and gsd, hope that is ok.
>
> If you move to 2'nd tab and if you tab out of the last gridline from the
> "PO Histroy" box, then you can see that no new record is created.
>
> If you remove the master/detail link for the "id", then you can see new
> records being auto created.
>
> Reinhard, let me know if you need more info.
>
>
> On Sun, Feb 27, 2011 at 8:45 PM, Reinhard Mueller <[email protected]>wrote:
>
>> Hi,
>>
>> Am Sonntag, den 27.02.2011, 17:22 +0530 schrieb Kishan Bhat:
>> > Now, my autoNextRecord="Y" stops working when I move out of the last
>> > block of "purchaseOrder". The moment I remove the master/detail
>> > relationship, the autonextrecord starts working.
>>
>> can you provide me with a small gfd(+gsd) which demonstrates the issue?
>>
>> Thanks,
>> Reinhard
>>
>
>

--20cf3054a7b5ec16f8049d594125
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I think I sort of figured out what the error was. I had defined the master/=
detaillink as:<div>&lt;datasource name=3D&quot;dts_invoice&quot; connection=
=3D&quot;test&quot; table=3D&quot;invoice&quot; master=3D&quot;dts_purchase=
Order&quot; masterlink=3D&quot;id&quot; detaillink=3D&quot;uid_po&quot;/&gt=
;</div>
<div><br></div><div>and also used the fk_key in the block referring to a di=
fferent column.:</div><div>&lt;block name=3D&quot;blk_invoice&quot; datasou=
rce=3D&quot;dts_invoice&quot;&gt;</div><div>&lt;field name=3D&quot;uid_po&q=
uot; field=3D&quot;uid_po&quot; =A0fk_source=3D&quot;dts_purchaseOrder&quot=
; fk_key=3D&quot;id&quot; fk_description=3D&quot;po&quot; required=3D&quot;=
Y&quot; =A0/&gt;</div>
<div><br></div><div>First of all, I should not have set fk_description=3Dpo=
, after having set it to &quot;id&quot; in the master/detail. Though removi=
ng the fk_description did not help, using the fk_source and fk_key was not =
required in the first place. So I removed that and all I&#39;m fine now.</d=
iv>
<div><br></div><div>Thanks Reinhard for looking into this.<br><div><br><div=
 class=3D"gmail_quote">On Sun, Feb 27, 2011 at 9:08 PM, Kishan Bhat <span d=
ir=3D"ltr">&lt;<a href=3D"mailto:[email protected]">[email protected]=
</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">I have attached my full gfd and gsd, hope t=
hat is ok.<div><br></div><div>If you move to 2&#39;nd tab and if you tab ou=
t of the last gridline from the &quot;PO Histroy&quot; box, then you can se=
e that no new record is created.</div>

<div><br></div><div>If you remove the master/detail link for the &quot;id&q=
uot;, then you can see new records being auto created.</div><div><br></div>=
<div>Reinhard, let me know if you need more info.<div><div></div><div class=
=3D"h5">
<br><br><div class=3D"gmail_quote">
On Sun, Feb 27, 2011 at 8:45 PM, Reinhard Mueller <span dir=3D"ltr">&lt;<a =
href=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a>&gt;=
</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .=
8ex;border-left:1px #ccc solid;padding-left:1ex">

Hi,<br>
<br>
Am Sonntag, den 27.02.2011, 17:22 +0530 schrieb Kishan Bhat:<br>
<div>&gt; Now, my autoNextRecord=3D&quot;Y&quot; stops working when I move =
out of the last<br>
&gt; block of &quot;purchaseOrder&quot;. The moment I remove the master/det=
ail<br>
&gt; relationship, the autonextrecord starts working.<br>
<br>
</div>can you provide me with a small gfd(+gsd) which demonstrates the issu=
e?<br>
<br>
Thanks,<br>
<font color=3D"#888888">Reinhard<br>
</font></blockquote></div><br></div></div></div>
</blockquote></div><br></div></div>

--20cf3054a7b5ec16f8049d594125--


--===============1598038649==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
gnue mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnue

--===============1598038649==--