You are using Oracle only as back end database, you didn't use any Oracle development tools?


>I actually have to develop both VFP and Oracle databases. I use VFP as the front-end. Where I work, I do not have much choice in what tools I have available to use for web development. No IIS, no ASP, no IE. :(
>
>>Hi Mark,
>>
>>Does that mean you are in Oracle Side :)?
>>
>>Acualy, I am using VB6 to develop my applications, and thinking seriasly to move to Oracle development tools, because I need to create an Internet/Interanet applications and looking for a powerfull development tools.
>>They told me to use InterDev, but I don't know about it.
>>
>>ADSC
>>
>>
>>
>>>PL/SQL is powerful enough. The learning curve for creating SPs and packages can be daunting. You will lose a significant amount of RAD capability using Oracle designer tools. VFP as a front end to an Oracle database is an awesome combination. You definitely need to learn about triggers, sequences, roles and synonyms. I have posted examples of all these in the Oracle forum.
>>>
>>>If you put a super effort into the database design and put your integrity checks in the database, the front end development is a breeze.
>>>
>>>>I work with a client that is considering dumping VFP for Oracle. Although I can easily support the move to the database, I am leary that Oracle Forms is as powerful as what they are used to with a VFP front-end. I am also leary that PL/SQL is powerful enough to, because as we all know, there are always reports that require significant data manipulation before the final cursor is created for a report, is powerful enough to support very complex reports. I would appreciate any insight as to the limitations in using strictly Oracle development tools (Forms and report writer) as opposed to a development language such as: VFP, VB or C++.
>>>>
>>>>Thanks,
>>>>Steve