Yip I kinda figured that and tend to code that way anyhow
But
There is OCA which does work with a number of other database it's just there
isn't a ready built MySql setup.
I'll try converting one of the others to run
Thanks anyhow
Ken
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: 02 February 2004 23:42
To: Ken Brown; [EMAIL PROTECTED]
Subject: Re: MySql and Oracle Forms 6i
Someone posted an answer:
Oh wow... I can't think of how you'd get that to work without a ton of
custom. For starters, you'll have to write your own transactional triggers
and intercept every one of Oracle's select, lock, update, insert, delete,
like On-Lock, On-Insert, etc. since Forms will want things like rowids.
You'll also have to write your own on-Login.
Mike
Oracle and MySQL differ in date handling, functions, triggers/stored
prodedures (or lack of), outer-join syntax, and a hundred other ways that
would make Forms incompatible with MySQL. Not to mention the fact that Forms
probably uses SQL*Net and a TNSNames.ora entry.
David.
- Original Message -
From: Ken Brown [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 02, 2004 3:11 PM
Subject: MySql and Oracle Forms 6i
Is there any way of using MySql as a back end to Oracle Forms?
Ken Desperately trying to justify not going back to oracle db Brown
Mail was checked for spam by the Freeware Edition of No Spam Today!
The Freeware Edition is free for personal and non-commercial use.
You can remove this notice by purchasing a full license! To order
or to find out more please visit: http://www.no-spam-today.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
