Cool, thanks Ted and Ed ... I was just hoping to use views and a connection
in the DBC, how do I go about getting the number for the connection created
when I open my DBC to pass to the SQLEXEC command so that I use the ideas
you suggested ?
-----Original Message-----
From: profoxtech-bounces .AT. leafe DO.T com [mailto:profoxtech-bounces@leafe.com] On
Behalf Of Ed Leafe
Sent: 31 May 2004 17:32
To: profoxtech .AT. leafe DO.T com
Subject: Re: Remote Views
On May 31, 2004, at 8:46 AM, Ted Roche wrote:
> You can use the @@IDENTITY value to return the last autoincremented
> value:
This is available in versions of MySQL >= 3.23.25. It is a synonym
for
the native MySQL construct:
SELECT LAST_INSERT_ID()
in order to make MySQL more compatible with other databases.
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://dabodev.com/
[excessive quoting removed by server]
©2004 Chris Davis |
