I had a similar problem a while ago and I got round it by using a trigger -
called a function on an insert to
read a value from a table (use for update when selecting)
update with incremented value
then use the return value from the ffunction to "set" the new value -
you can do all your login or
Anyone any idea how I could rewrite this as a join - all the indexes are in
place and each of the components of this work fine - its only when the
combined subqueries are passed to the root query does it appear to go wrong
(Takes around 1.5 mins to complete and causes 100% processor utilisation
whi
iffiths [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
Is there any way of using MySql as a back end to Oracle Forms?
Ken Brown
Oh, and one other thing, you have to create the passwords AFTER you use
the switch! That was probably obvious to you but it took me a while to
figure out.
Randy
Randy Chrismon wrote:
> Ken Brown wrote:
>
>> Just installed 4.1.1 on windows 2000 with current odbc layer
>>
>
Anyone managed to get oracle forms 6i to talk to MySQL - if so how?
I've got ODBC working but it will not connect and the ODBC trace is less
than useful
Ken
I need to do this to get round password issues as -old-passwords doesn't
work
Anyone any ideas?
Kwn
uld advise otherwise - or at
the very least how to switch on a security log
Ken
-Original Message-----
From: Ken Brown [mailto:[EMAIL PROTECTED]
Sent: 31 January 2004 15:56
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Passwords and ODBC - what am I missing
Just instal
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no password
But if I set a password on root or create a user with a password odbc fails
with
"Client does not support authentication protocol requested by the server -
consider upgrading MYSql Client"
Oracle has "Dual" does MySql have something similar?
In Oracle I use SYSDATE and USER a lot as default column values when
creating a table. Can you do something similar in MySql and how?
Does MySql support sequences? How?
Relationships - can the code be interfered with or do I have to w
10 matches
Mail list logo