Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Weirdness with a View
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement