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