From: bjo-sag@online.no   
      
   "Ed Nash"  wrote in message   
   news:455630f0$1@pnews.thedbcommunity.com...   
   > Bjorn Sagbakken wrote:   
   >   
   >> jpg-files just to check. But you set me on an idea; maybe there are   
   >> options in the BDE for the SQL connection?   
   >   
   > - There are some things to tweak.  I don't have the BDE in front of me so   
   > I can't help much now.   
   >   
   > - How are you attempting to post from Pdox to MS-SQL: tcursor directly,   
   > tcursor.add(), table add(), etc?  IIRC, I could never get an SQL INSERT to   
   > work so I always did a table (not tcursor) add.  Attach a table var to the   
   > remote table and another to a local PRIV table, then add local to remote.   
      
   I have tried to post from Pdox to MS-SQL directly with tcursors, one tcursor   
   pointing to the Pdox table and one pointing to the SQL table; using   
   insertrecord, copyrecord, and later also copying the imagefield alone, not   
   the whole record. Tried tcursor.add(), but it fails. I have also tried to   
   temporary write the graphic content to a file(both bmp and jpg) and read it   
   back into a graphic variable before inserting this to the SQL-field. Haven't   
   tried SQL INSERT or table add.   
   I will check out table add.   
      
   > - Are you first reading the source JPG, using readFromFile, into a BLOB or   
   > GRAPHIC field before attempting to load to the server?   
      
   Basically the graphic content resides in a Paradox table with GRAPHIC as the   
   field type, and ideally this should go directly to the SQL, but yes, I have   
   also tried to readfromfile.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)