Recent content by cooperman1275

1) You cannot test a number for being NULL. 2) The comma after the END (CASE) statement should not be there unless you intend to show more columns? You should try the following: SELECT CASE WHEN sum(po_order_line.order_line_amnt) = 0 THEN 'ZERO' WHEN...

Hi Denny Thanks for answering Joe's question for me. I agree that it is best practice to setup the SQL Account without Domain Administrator permissions. My initial response to Joe was by way of a favourite quick and dirty problem fix that is guaranteed to work. Dave

Hi Joe One sure way to get this working is to have an account with Domain Admin permissions for your network etc. and it should also be given a valid MAPI profile so that it can be used to send and receive emails. The account can then be configured as the startup account for the MSSQLSERVER...

Problem Solved! Default environment variable 'path' on the client did not include the directory where winword.exe resides. Simple matter to change via My Computer > Properties. Prefer Informix to Microsoft anytime!!

Easiest way to set up DTS packages for the novice or infrequent user is run Enterprise Manager and then use the Import Data or Export Data Wizard to set up a prototype - Don't forget that you should check the box before the wizard finishes to save the jobs in a Local Package. The saved package...

Can anybody help? We have been using the Client SDK to connect between NT clients and Informix server for the past 5 years. In order to print documents created by the Informix 4GL programs, Microsoft Word is invoked on the client, allowing the user to preview, print and save etc.. We are now in...

Use Enterprise Manager to Design the table. Create the new column. Select the newly created column, right click, Indexes/Keys. Create a new index on the column name, and make sure to check "Create Unique" before saving amended design. Any attempt to insert a non-unique value into the new column...