Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to succeed with SPT
Hi all,
My first FoxPro job in 2.5+ years and my first ever involving SQL Server (MSDE at this point).
I have a single-table .DBC that I successfully used the Upsizing Wizard to create a MSDE database/table and 'load' data to it. I confirmed this with a simple SQLEXEC(nHandle,"Select * from Mapmerch"), browsing the result.
Now I have a program that is to add or update info in that MSDE database/table.
I get a connection handle just fine but any attempt to run SQLEXEC on that handle always fails.
The command is simply nResult=SQLEXEC(nHandle,cSQLIns1) and I have a rather lengthy SQL-Insert statement in cSQLIns1. But I have also tried with the following in cSQLIns1:
" cSQLIns1='INSERT INTO Mapmerch (MERCHANTNO, BUSNAME) VALUES ("9898989","NELSON TEST BY HAND")' " and
" cSQLIns1='INSERT Mapmerch (MERCHANTNO, BUSNAME) VALUES ("9898989","NELSON TEST BY HAND")' ".
My experience is sadly lacking and I'm sure that something more needs to be done, but I don't know what.
Your help will be appreciated.
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