Information générale
Titre:
SPT INSERT syntax error?
Since TABLEUPDATE() seems rather unreliable for INSERTing new table rows back to SQL Server 6.5 through Remote Views, I'm now trying SQL Pass-Through functions to send an INSERT back to the server. No such luck, I keep getting syntax errors and connectivity errors. I've tried the syntax a hundred different ways, it seems - still no success. If anyone can shed light here, it would be greatly appreciated.
I APPEND BLANK to cursor, then REPLACE data in all fields. Now I send
= SQLExec(nConnect, "INSERT INTO sqltable (col1,col2,col3...) VALUE (curs.col1, curs.col2, etc..)")
I've initialized all required elements using CURSORSETPROP().
I've tried the SQLExec a variety of ways, using various delimiters, specifying each value, not specifying, etc. etc. What am I doing wrong? SELECT and UPDATE's work fine, only INSERT's do not. Thanks.
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