I have a remote view that has suddenly started failing on inserts claiming a column which contains a value in the VFP record will not except nulls ( null is indeed off on that column, but I should be inserting a value )

Profiler shows only the first 11 columns are in the insert statement.

getfldstate(-1) correctly shows those fields that have been modified in the appended record with a 4

( I ran this right before the tableupdate() statement )

'SYMBOL' is field(37) and getfldstate(37) = 4 but it does not appear in the insert

I can insert a new row into the table in SSMS using a select from an existing row so the identity key works fine.

I have recently added a number of long named fields to the table. Is there an upper limit for the insert statement that gets sent to the back end and if so how do I get around it on an insert ?

Never saw something like this before - does anyone have a suggestion ?

I see the field that is the first one to not be included is a memo field, but I have made sure that is not null (in case the "symbol" is a false error message)

I don't know enough about the under-the-hood mechanics of ODBC to know what could be going wrong, but the only change on my VFP side has been to add 20 or so columns to an already long table.

I suppose if I set a default value on the VFP side and say Key and Modified fields that will increase the size - could set defaults on back end I guess. Is this on the right track?

????

TIA

INSERT INTO Future_Change (Action,Action_Code,ADR_Ratio,Apply_Note,Apply_Stat,Apply_Time,Cashdiv,Cntry_code,CUSIP) VALUES ('',1,0.0,' ',0,'19800101 00:00:00.000',0.0,'AA','            ')

Date of last update:    11/09/2011
Memo file block size:   64
Code Page:              1252    
Field  Field Name      Type                Width    Dec   Index   Collate Nulls    Next    Step
    1  ACTION          Memo                    4                             No
    2  ACTION_CODE     Integer                 4                             No
    3  ACTION_DESCR..  Character              30                            Yes
    4  ADR_RATIO       Double                  8      6                      No
    5  APPLY_NOTE      Memo                    4                             No
    6  APPLY_STAT      Integer                 4                             No
    7  APPLY_TIME      DateTime                8                             No
    8  CASHDIV         Double                  8      6                      No
    9  CASHDIV_DIV_..  Double                  8      6                     Yes
   10  CNTRY_CODE      Character               2                             No
   11  CUSIP           Character              12                             No
   12  DESCRIPT        Memo                    4                             No
   13  SHORTDESCRIP..  Character             200                            Yes
   14  EFF_DATE        Date                    8                             No
   15  FCA_CURR        Character               3                             No