>From the Integrating-700.pdf file: "Only the following data types are supported in view forms: .. SQL Server—char, varchar, tinyint, smallint, int, text, real, float, decimal " The best way to access your numeric and date fields is to create a database view on top of the table in which you CAST them to for instance a varchar field. When you would create a view form on top of this new database view, you should have access to all fields.
-- Met vriendelijke groet / Kind regards Michiel Beijen ______________________________________________________ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On 10/2/07, brooksm <[EMAIL PROTECTED]> wrote: > Hi- > My ARSystem server is on MS SQL Server 2005. > I've created a view (view_form1) on my SQL Server of an external SQL Server > 2000 table. This new view contains all fields, but when I try to create a > view form on view_form1 all numeric and datetime fields do not come over. > What is the easiest way to see the numeric & datetime fields? > -- > View this message in context: > http://www.nabble.com/Missing-numeric-and-datetime-fields-in-view-form-tf4557770.html#a13006994 > Sent from the ARS (Action Request System) mailing list archive at Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
