Hello, after seeing this strange error:
https://forums.smartclient.com/forum...832#post257832
I wonder if there's some problem with dataSources structured like this:
inheriting ds:
JOFC_ISCRIZIONE_SOCIO:
JOFC_ISCRIZIONE_SOCIO_BASE declares the fk:
and then also JOFC_SOCI inherits the ID_REC field from JOFC_SOCI_BASE.
So, the 'base' dataSources declare the foreign keys using the ID of the inheriting dataSources, and also the inheriting dataSources IDs are used to include fields.
Is this ok, or am I misusing something?
https://forums.smartclient.com/forum...832#post257832
I wonder if there's some problem with dataSources structured like this:
Code:
<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
ID="JOFC_CARRELLO_DETTAGLI_BASE"
tableName="JOFC_CARRELLO_DETTAGLI"
schema="mySchema"
dbName="myDB"
serverType="sql"
requiresAuthentication="true"
>
<fields>
......
<field name="ID_ISCRIZIONE_SOCIO_FK" type="integer" foreignKey="JOFC_ISCRIZIONE_SOCIO.ID_REC"/>
.....
Code:
<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
ID="JOFC_CARRELLO_DETTAGLI_FO"
tableName="JOFC_CARRELLO_DETTAGLI"
....
inheritsFrom="JOFC_CARRELLO_DETTAGLI_BASE"
>
<fields>
.....
<field name="ID_SOCIO_FK" type="integer" includeFrom="JOFC_ISCRIZIONE_SOCIO.ID_SOCIO_FK"/>
<field name="NOME_SOCIO" type="text" includeFrom="JOFC_ISCRIZIONE_SOCIO.JOFC_SOCI.NOME">
....
Code:
<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
ID="JOFC_ISCRIZIONE_SOCIO"
tableName="JOFC_ISCRIZIONE_SOCIO"
...
inheritsFrom="JOFC_ISCRIZIONE_SOCIO_BASE"
>
....
Code:
<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
ID="JOFC_ISCRIZIONE_SOCIO_BASE"
tableName="JOFC_ISCRIZIONE_SOCIO"
....
>
<fields>
.....
<field name="ID_SOCIO_FK" type="integer" foreignKey="JOFC_SOCI.ID_REC"/>
...
So, the 'base' dataSources declare the foreign keys using the ID of the inheriting dataSources, and also the inheriting dataSources IDs are used to include fields.
Is this ok, or am I misusing something?