Erin,
This is because your SELECT creates a free table which doesn't support long field names. Simply add the keyword DATABASE to your query:
SELECT * FROM v_testview INTO TABLE erintemptable DATABASE erintempdb
This will add the table to your database and the table will have long fieldnames.
HTH
>Hi all,
>
>I'm exporting data from a SQL server to a view, then to a table. My syntax looks like this:
>
>
>set defa to c:/data/projects
>create database erintempdb
>CREATE CONNECTION conTempConnection DATASOURCE "test" USERID "testing"
>PASSWORD "testing" DATABASE 'testdb'
>
>lnConnect = SQLCONNECT('conTempConnection')
>? lnconnect **-- Here I received a positive value, so I've established a conn.
>
>CREATE SQL VIEW v_testview CONNECTION conTempConnection ;
> As SELECT * FROM testdb.testtable testtable;
>
>SELECT * FROM v_testview INTO TABLE erintemptable
>***************************************************************
>
>This all works fine, however, when i go from the view to the erintemptable, my fieldnames change. They match in the SQL table testtable and the view v_testview. But, when i do the last line of code to put everything from the view into erintemptable, i get different field names in my table. this is not a predefined table, so i have no idea why this is happening. any clues? tia.
>
>erin
Daniel