Mike Do you get the same problem with memos is in a simple table? Does the master-detail work without the memo?
I don't use the odbc access so am not an expert in this area - I do know there are problems with the Cache OCX direct access in the area of memo's. You may be interested in our tool - xebRAD - it connects to the Cache database directly - no odbc - have a look at www.xisltd.co.uk if you are Peter ========================== Peter F Cooper BSc Managing Director xebec information systems ltd the creators of xebRAD [EMAIL PROTECTED] www.xisltd.co.uk On Tue, 4 Apr 2000 10:10:50 -0400, "Mike Kilmade" <[EMAIL PROTECTED]> wrote: >I have a project that involves a number of Master-Detail Cache class >relationships. There is one usage pattern that is consistently causing a error >when the user inserts a 'detail' entry. > >The detail class has a character stream property that I allow the user to input >data via a Delphi Memo field. If the user enters data in this field when first >creating the record, the initial 'post' returns the following error. 'Non-blob >colmn in table required to perform operation'. I've check and all the required >fields/properties are being sent tot eh server and the interesting thing is that >the data is inserted ok on the Cache side. Also, any subsequent edits to the >memo field get updated properly. > >If the user does not enter any text in the memo field, no error occurs on the >initial posting. > >I suspect it has something to do with the ID field for the detail. The error >occurs between the BeforePost and AfterPost event. > >Any help is appreciated. >
