Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dynamic cursoradapter & grid
Message
De
30/05/2005 04:34:14
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Dynamic cursoradapter & grid
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01018489
Message ID:
01018489
Vues:
51
Hello all!
I'm quite new to VFP so pls bear with me.

I'm trying various ways to connect to a SQL Server 2000.
I've found this nice code (which works) :

local loCursor as CursorAdapter, ;
laErrors[1]
set multilocks on
loCursor = createobject('CursorAdapter')
with loCursor
.Alias = 'Customers'
.DataSourceType = 'ODBC'
*** Use appropriate connection settings here
.DataSource = sqlstringconnect('driver=SQL Server;' + ;
'server=(local);database=Northwind;uid=sa;pwd=;' + ;
'trusted_connection=no')
.SelectCmd = "select CUSTOMERID, COMPANYNAME, CONTACTNAME " + ;
"from CUSTOMERS where COUNTRY = 'Brazil'"
.KeyFieldList = 'CUSTOMERID'
.Tables = 'CUSTOMERS'
.UpdatableFieldList = 'CUSTOMERID, COMPANYNAME, CONTACTNAME'
.UpdateNameList = 'CUSTOMERID CUSTOMERS.CUSTOMERID, ' + ;
'COMPANYNAME CUSTOMERS.COMPANYNAME, CONTACTNAME CUSTOMERS.CONTACTNAME'

if .CursorFill()
BROWSE
else
aerror(laErrors)
messagebox(laErrors[2])
endif .CursorFill()
ENDWITH

Now instead of Browse, I would like to use a grid.
My question is what should I pass to
thisform.grdDynamic.RecordSource and thisform.grdDynamic.RecordSourceType?
Thank you very much
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform