b1b49102   
   From: reb01501@NOSPAMyahoo.com   
      
   xo wrote:   
      
   > The error seems to be caused by the last line.  Add'l info - FLODS_ID   
   > is (PK, numeric (18,0), not null) and OBJECT_ID (varchar(80), null)   
   >   
   > Below is the sql -   
   >   
      
   > Thanks in advance   
      
   Thanks for the attempt to provide extra information. Unfortunately it was   
   both too much and not enough information.   
   Please provide:   
   1. A CREATE TABLE script to allow us to create a table with only the   
   relevant columns. Do not include any columns that are not needed to recreate   
   the symptom.   
   2. A script to insert some sample data into the table. The sample data   
   should include the row that causes the error message.   
   3. The sql statement that uses the test table to reproduce the symptom   
      
   This of course will require you to find the row(s) containing the data that   
   causes the error. Doing so might lead you to the answer to your question. I   
   suggest you remove tables and columns from the sql you provided until you   
   can run it without error. Then add back in a column/table at a time until   
   the error does occur. Then try limiting the results using a WHERE clause   
   until you identify the row(s) containing the problem data.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)