Information générale
Catégorie:
COM/DCOM et OLE Automation
>I'm not sure if this will help, but what happens if you make a view as >SELECT * FROM table? Do you get an error as well?
It says: "The data source for this object must be a variable reference (Error 1742)"
I get the sql SELECT * FROM when I do an ADD ALL from the remote view->modify->fields. If I manually select them, i of course get the other error when I try to add the 5_percent_n field.
Is ther another way to make the view as SELECT * FROM table? I don't think that there is, but I'm not master on views ;)
>Another try might be to make a SQL-PT connection and use SQLCOLUMNS() on >the affected table. I wonder, what will be returned as the field name for >the "numeric" field name.
it returns 5_percent_n...what else can I do with sql-pt? I'm not sure what sql-pt is, but i used sqlconnect() to connect to by access db, whcih i assumed was what you were talking about?
matt
Précédent
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