Excellent! Thank you Michiel!
Michiel Beijen-2 wrote: > > 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" > > -- View this message in context: http://www.nabble.com/Missing-numeric-and-datetime-fields-in-view-form-tf4557770.html#a13007408 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"
