Hi Mark,

Pardon me for jumping in, but do you use the CLOB data type in Oracle to handle large text (i.e., memo fields)?

If so, could you elaborate on any experiences or tips in how you've managed with them?

Guy


>>Hi,
>>
>>I am in a proccess of converting our VFP app to client/server using Oracle as the backend. Does anyone know any good books out there that can help me?
>>
>>Thank you very much
>
>Oracle or VFP? I recommend Oracle8 The Complete Reference [ISBN 0-07-88-2396-x] and Oracle PL/SQL Programming by Scott Urman [ISBN 0-07-882176-2].
>
>You need to learn about Triggers, Sequences and Procedures on the Oracle side. Creating script files [.SQL] that you can run from SQL*Plus is definitely a must.
>
>If you put in a lot of work on developing the database, the VFP work will be very quick. So far, on my latest project, I have spent about 80% of my time on the database and the rest on VFP development. The main reason is that my triggers, sequences and procedures on the Oracle side do almost all of the work. About the only thing VFP does is creating a shared connection to Oracle [user login], UI for data entry, and sending updates back to Oracle.
>
>I use Oracle to generate PKs from the sequences and BeforeInsertUpdate triggers. I also use triggers to populate Last_Update and Updated_By fields in every data table.