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"
