Search results for query: *

Try this UPDATE [Dealer Names And AddressesTEST] SET [Dlr Name] = REPLACE([Dlr Name], '''', '') That's four single quotes. SQL Books online (BOL) states that to represent an embedded quotation mark, use two single quotes. Alternately: SET QUOTED_IDENTIFIER OFF UPDATE [Dealer...

Thanks for the info, Denny. I'll just use a different account for testing the read only functionality. Rob --------------------------------------------------------------- There are 10 types of people in this world. Those who understand binary, and those who don't.

I can't find anywhere in Access to set authentication. However, I have found a few interesting things out about the setup of our SS2k instance. I removed my login id from the database to try to force the connection to use the read only id I setup. I then tried to connect to the database using...

Denny, thanks for the reply. Client OS: Win2K Pro Server OS: Win2K There are only two options that I can choose for authentication when setting up the ODBC connection - 1) Win NT authentication, 2)SQL Server authentication. The help says that NT authentication sets up a trusted connection and...

We have a SS2k database and want to be able to allow a PowerUser to link to tables using Access. I have created a ReadOnly role that has Select rights to all required tables and Execute rights to only those procedures that perform Selects. I then created a new login id and granted that id the...

You could use a stored procedure with a temp table and a cursor. That gives you control over which rows you report. Here's some basic logic: create table #{tmp_table_name} ({column_name} {data_type} ... ) declare {cursor_name} cursor for select {column_list} from...

Can you not use the SQL Expert to exclude this data. I.E. - Region <> &quot;Other&quot; RES

IsNull( {Company} ) should work. What database are you using? Is there anything else in the Select Expert? Are you joining multiple tables? Rob

Well put guys. A view is an excellent idea and one that I could easily implement. But, alas, I am constrained by the system for which I am developing reports. This particular application, Magic, has its own module for adding reports to the system. All reports are actually based on views and...

I tried that too. But, I get several errors about &quot;Communication Link failure&quot; and &quot;error in database DLL&quot;. The LOCATE function is listed in the function list in CR 8.5. If I understand correctly, the functions available to the SQL Expression are those exposed by the ODBC...

You also stated &quot;Version CR 8.5 and below will, CR 9 and above will not.&quot; That led me to believe that CR 9 will not treat a Varchar(256) column as a memo. What I am parsing is a string of email address information that includes an identifier for the person's location...

CR 8.5 - SQL Server 2k I am also very restricted by the application I'm developing for. It's a Help Desk application done in ASP. It has it's own interface for adding reports to the system and I can only base reports on db views it &quot;knows&quot; about. I thought about using a SQL...

In my database I have an EmailAddress column declared as Varchar(256). I need to be able to parse out part of the information in this field for my report. However, Crystal is treating this as a Memo field and therefore, I can't use it in a formula. Can anyone enlighten me as to why Crystal...

My suggestion is to create a formula field to format all phone numbers. I would first remove any non numeric character, then format it the way you want. I.E.: StringVar fmtPhone; fmtPhone = Replace( {db.phonecolumn}, &quot;(&quot;, &quot;&quot; ); fmtPhone = Replace( fmtPhone, &quot;)&quot...

I've created a rollup report to summarize work order data. WorkOrder Table: WO# SubjectID Subject Table: SubjectID SubjectDesc Parent There are 3 levels of subjects. SubjectID SubjectDesc Parent ------------ ------------- ------------- 1417 ACC_REQUEST null 1418 ACC_JDE...

I have two details sections - a & b. Details b has a subreport. I wish to suppress details a if the subreport has no rows. How can I accomplish this?

Join works great. But if you ever need to loop through a multivalued parameter, be sure to subscript the parameter. ---------------------------------------------------------- for i:=1 to count({?company}) do ( if i=1 then temp:=temp & {?company}[i] ; if i > 1 then temp := temp & &quot...

Try this: Picture( Replace( {phone_field}, &quot;,&quot;, &quot;&quot; ), &quot;(xxx) xxx-xxxx&quot;)

I downloaded a white paper and a UFL file from Crystal Decisions. cr_business_days_hours.zip BusinessDaysUFL.zip These files came with very good documentation and samples. You should be able to modify their code to meet your needs. Rob

John, I don't know the API calls you need. I suggest you start your search at msdn.microsft.com/library. Drill down in the menus on the left - Windows Development | Windows API. Sorry I can't help more.