Dirk, Thanks for the quick response (again).
It works. I changed it to varchar and it's OK ;) Thanks, Eddie >From: Dirk Kraemer <[EMAIL PROTECTED]> >To: Eddie Post <[EMAIL PROTECTED]> >Subject: Re: [dbforms] Inserting NULL >Date: Mon, 10 Jun 2002 13:01:25 +0200 > >Hi Eddie! > >It's the 'uniqueidentifier' type that is not known to dbforms. >Please set it to a known type. If it is alphanumeric, select >something like 'char', if it is numeric 'integer'. >It is not really important that dbforms knows the exact type, >just important to know if it is numeric, alphanumeric, date etc. >If it is a key in that table don't forget to set 'isKey' attribute. >If it is generated by database set autoInc="true". > >Then restart your application and leave your JSP as it was. >Please let me know if it works or if you need more help. > >Hope this helps > >Dirk > > > >Eddie Post wrote: > > > > Dirk, > > > > Thanks for the quick response. > > Here is the declaration of the table. The column that gives problem is >the > > one with "Pdt_Tbl_Id": > > ---------------- > > <table name="Tbl_Pdt_ProjectTableDetails"> > > <field name="Pdt_Id" fieldType="uniqueidentifier" >size="36" isKey="true" > > autoInc="true"/> > > <field name="Pdt_Prj_Id" fieldType="uniqueidentifier" >size="36" > > sortable="true"/> > > <field name="Pdt_Tbl_Id" fieldType="uniqueidentifier" >size="36" > > sortable="true"/> > > <field name="Pdt_DeleteSequence" fieldType="smallint" >size="5" > > sortable="true"/> > > <field name="Pdt_Where" fieldType="varchar" size="100" >sortable="true"/> > > <field name="Pdt_OrderBy" fieldType="varchar" size="50" >sortable="true"/> > > <field name="Pdt_RowLimit" fieldType="smallint" >size="5"/> > > <field name="Pdt_Source" fieldType="bit" size="1" >sortable="true"/> > > <field name="Pdt_Tbl_Target" >fieldType="uniqueidentifier" size="36" > > sortable="true"/> > > <field name="Pdt_DateLastCopy" fieldType="datetime" >size="23" > > sortable="true"/> > > </table> > > ------------- > > > > BTW: > > I also tries somthing like: > > ----- > > <db:select fieldName="Pdt_Tbl_Target" > > customEntry="$null$,Null,uniqueidentifier"> > > ----- > > But neither dis that work. > > > > Thanks, > > Eddie > > _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
