Hi folks,
First i must congratulate you for the excellent work you have done by
creating this tool. I am currently working directly from CVS on a project
based on DBFORMS and i think that i should submit to your attention some
requirements that would considerably ease my work.
1.------------------------
Is there a posibility to get the values from calculated Fields into the
fieldValues Hashtable from Interceptors (or at least into the
interceptors..) ? The fieldValues hashtable actually contains only the
values contained in the update able fields. It has to be a way to get into
interceptors calculated field values (fields that do not corespond to any of
the fields from the database, or even key fields).Would it be possible to
create a field Tag something like :
<db:Field type="scalar" fieldName="scalarfield" >
<db:staticDataItem key="1" value
="<%=a*b*currentRow_tblUser.get("idUser")%>"/>
</db:Field>
or
<db:Field type="vector" fieldName="vectorfield"
<tabledata name="U2G"
foreignTable="tblGroup"
visibleFields="GroupName"
storeField="idGroup"
Format="-%s"
/>
</db:Field>
2.--------------------------
Because you already solved introducing the ForeignKey support iI think it
would be very nice to create also a control Tag based on.
Let's say FKcheckBox. That should be something like :
in dbforms-config.xml (like already is):
<table name="User2Group" defaultVisibleFields="idGroup,idUser">
<field name="idGroup" fieldType="int" size="10" isKey="true"/>
<field name="idUser" fieldType="int" size="10" isKey="true"/>
<foreign-key name="FK_User2Group_User" foreignTable="tblUser"
displayType="select">
<reference local="idUser" foreign="idUser"/>
</foreign-key>
<foreign-key name="FK_User2Group_Group" foreignTable="tblGroup"
displayType="select">
<reference local="idGroup" foreign="idGroup"/>
</foreign-key>
</table>
<table name="tblGroup" defaultVisibleFields="idGroup,GroupName">
<field name="idGroup" fieldType="int" size="10" isKey="true"
autoInc="true"/>
<field name="GroupName" fieldType="varchar" size="200"/>
</table>
<table name="tblUser" defaultVisibleFields="idUser,UserName">
<field name="idUser" fieldType="int" size="10" isKey="true"
autoInc="true"/>
<field name="UserName" fieldType="varchar" size="200"/>
</table>
in a form (having possibly nested dbform subforms) , using table user, i
have to establish the belongingness to a group :
<db:FKcheckBox name="check1" fieldName="FK_User2Group_User">
<tabledata name="U2G"
foreignTable="tblGroup"
visibleFields="GroupName"
storeField="idGroup"
Format="-%s"
/>
</db:FKcheckBox>
then if the data looks like below
table Groups
GroupID GroupName
-----------------
1 FirstGroup
2 SecondGroup
3 OurGroup
table Users
UserID UserName
-----------------
1 Andrew
2 John
5 Carla
table user2group
UserID GroupID
---------------
1 1
1 2
2 1
3 2
3 3
Its rendering (using FKcheckBox dbform tag) would be something like
for Andrew -> |O| FirstGroup |O| SecondGroup | | OurGroup
for John -> |O| FirstGroup | | SecondGroup | | OurGroup
for Carla -> | | FirstGroup |O| SecondGroup |O| OurGroup
(sorry for the lousy checkboxes)
and the result of clicking the update button should result in multiple
updates on the table user2group. How about clicking insert ?
3.--------------------------
After an insert or update ( even if the navigation was disabled !) the form
should display the last inserted/updated record not the first.
How about using followUp to specify this ?
Regards,
Andrei
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
