Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Conflict--Connectivity error 1526
Message
De
16/04/2005 11:38:53
Thomas Wang
Cts Int'l Transportation Co., Ltd.
Shanghai, Chine
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Update Conflict--Connectivity error 1526
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01005458
Message ID:
01005458
Vues:
62
I have a code block like below
+++++++++++++++++++++++++++++++++++++++
thisform.AddProperty("loCursor")
thisform.loCursor = newobject("CursorAdapter")
lcConnString = 'driver=SQL Server;server=(local);database=Northwind;trusted_connection=yes'

with thisform.loCursor
.BufferModeOverride = 5
.Alias = 'Customers'
.DataSourceType = 'ODBC'
.DataSource = sqlstringconnect(lcConnString)
text to .SelectCmd noshow
select CustomerID, CompanyName, ContactName from Customers
endtext
.KeyFieldList = 'CustomerID'
.Tables = 'Customers'
.UpdatableFieldList = 'CustomerID, CompanyName, ContactName'
.UpdateNameList = 'CustomerID Customers.CustomerID,CompanyName Customers.CompanyName, ContactName Customers.ContactName'
.CursorFill()
endwith

select customers
go top
replace customers.companyname with "Alfreds"

if !tableupdate(2,.t.,thisform.loCursor.alias)
=aerror(laerror)
display memory like laerror
endif
++++++++++++++++++++++++++++++++++++++++++++++++++++++
I can not update data via tableupdate() and
laerror(1,1) return 1526,
laerror(1,4) return "S0002"
laerror(1,5) return 208

has any body give me any idea ?

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform