Sytze de Boer wrote:
> I think my previous post was not clear
> My statement, "It is not possible to "select into cursor tmp" twice on
> the same workstation" was meant to indicate that within the program,
> on the same pc, you could not end up with a select into cursor tmp
>
> So, how come I can end up with the error "Alias name is already in use"
> It isn't even an alias, its a cursor
I had this happen recently to me, on a UNION statement where it had been
going to a table but I changed it to go to a CURSOR. I had to close the
cursor (like Rick said) before the SQL. USE IN (select("MyCursor"))
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
