>>The version is 10.0.3, which has Text type: but sybase team says:
>>--snip--
>>W.r.t using Text datatype we found following Problem :
>> "To write text datatype the command is Writetext ,which is a non logged state , a System Administrator must use sp_dboption to set select into/bulkcopy pn. This permits the insertion of non-logged data. After using WriteText , it is necessary to dump database. A transaction dump which is done after unlogged changes to the database is not usable in a Load transaction operation. "
>>
>>Now if use the datatype "TEXT" in our database then there is a possibility to lose the text data as the transaction log does not contain text data in it . (as after each writetext we have to use "DUMP DATABASE" . That’s the reason, We changed all our datatype of text to VarChar(255) and split the records.
>>--snip--
>>I feel like I may be in the wrong forum now for this, but any ideas on either the vfp side or sybase side of things?
>
>Bruce,
>
>Sounds like, "this is buggy and doesn't work the way it should" in techno-speak to me. I'll see what I can find out from our Sybase people, and if there's something I think that you can use, I'll post.
>
>BTW, the latest version of Sybase that I know about is System 11.
>
Yes, either buggy or they don't want to update their DB... :~) Thanks again for any info.