Howdy... Found out why this was not working in the enviroment I was testing it on...5.0. There is not User Perference form which this command sets, with 23235 being the field id for the field in question. For future reference for anyone you can find this info in: P628 of ARS 6.3 Developing AR System Applications:Basic
Regards, YHK On 10/2/07, YHK <[EMAIL PROTECTED]> wrote: > > Good morning, > > Forgive me for resurrecting this. Found it in a search regarding how to > set the ODBC use underscore with a run process. I tried both command lines > which Fred recommended, with no luck as they did not work. Tried with a > space and a return after 23235. Does anyone know the correct command or > point me to the correct manual? > To set the option on thru code do: PERFORM-ACTION-SET-PREFERENCE 23235 > 1 > To set the option off thru code do: PERFORM-ACTION-SET-PREFERENCE 23235 > 0 > > > Thank you! > Regards, > YHK > > On 9/19/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote: > > > > Also inside the Crystal Designer when you Set Location the ODBC use > > underscores must match the User Tools -> Options setting > > > > Basically the Report setting must match the User tool setting. The ODBC > > use underscores optios determines wether the ODBC driver will convert > > non database characters in form and field names into an underscore. > > i.e. > > > > A form called "My:MainTicket" will be referenced as "My_MainTicket" when > > the ODBC use underscores option is selected and "My:MainTicket" when the > > > > option is not selected. > > > > The same goes for fields. A field called "Send Survey?" will be > > referenced in the report as "Send_Survey_" when the option is selected > > and "Send Survey?" when it is not. > > > > TIP ------- > > > > Just before the report Window Open action in the Active Link do a Run > > Process action to set the ODBC use underscores setting so it will match > > with what was used in the Crystal Reports definition. > > > > To set the option on thru code do: PERFORM-ACTION-SET-PREFERENCE 23235 > > 1 > > To set the option off thru code do: PERFORM-ACTION-SET-PREFERENCE 23235 > > 0 > > > > TIP ------- > > > > Fred > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke > > Sent: Wednesday, September 19, 2007 12:15 PM > > To: [email protected] > > Subject: Re: Crystal Reports problem (U) > > > > Hi Sandra, > > > > > Sounds like it could be an "ODBC Use Underscores" error > > > > > > Check your Windows Control Panel > Administrative Tools > Data Source > > > (ODBC) > AR System ODBC Data Source > Configuration Is the "Use > > > underscores" checked? > > > > > > Check Remedy > Tools > Options > Advanced Is the "ODBC Use > > > Underscores" checked? > > > > > > Which ever you use - underscores Yes or No - must be consistent > > > because your use of Crystal Reports with Remedy depends on this > > setting. > > > > > > Will check that tomorrow. BTW, what is the underscores thing? A workmate > > > > warned me. He said it caused some problems with crystal reports, when he > > activated the option. > > > > > > Mark > > > > > > _______________________________________________________________________________ > > 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"
