Alias name already in use??

[gregory100]

Hi, How could avoid the error:Alias name already in use, in a SQL

thanks

 

[KDavie]

If you are using a SQL SELECT statement and storing the results to a cursor, you may be giving the cursor the same name as one of the tables in your data-environment. For example, if I had a table called "MyTable" in my data-environment and tried to execute this code:

SELECT * FROM MyData INTO CURSOR MyTable

I would get your error.

The cursor name must be unique to the data environment.

-Kevin

 

[JRB-Bldr]

You could always test for the ALIAS before attempting to use it.

* --- Ensure Alias Not Already In Use ---
IF USED('ThisAlias')
SELECT ThisAlias
USE
ENDIF

Good Luck,
JRB-Bldr

 

[Mike Lewis]

JRB-Bldr,

IF USED('ThisAlias')
SELECT ThisAlias
USE
ENDIF

Quite right. However, did you know that you can shorten that construct to a single line:

USE IN SELECT("ThisAlias")

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[dbMark]

Also, if you run 2 SQL selects in a row on the same tables, the first one may have left table(s) open that the second select statement stumbles on.