Hi Kevin,
>>Does this mean you can only have one 'memo/text' field per record? That could mean some design changes, but no show stoppers there, as we generally limit our tables to one 'Notes' field anyway.<
>
>Kevin: No, I have tables with lots of memo fields. It just means all these fields are mapped to individual VARCHAR2() fields in Oracle. Oracle only allows one LONG datatype per table.
>
Pardon my ignorance, but... is a LONG datatype the same as a MEMO in VFP and TEXT in SQL Server? What is the limit for VARCHAR2?
Thanks,
Bill Armbrecht
VFP MCP