>I am connecting to a maxdb database with vfp7. Reading the doumentaion that comes with maxdb it has a fetch sql command, which seems to read, that it will fetch limited rows of data from a prepared sql statement. The documentaion that comes with it seems to be all for C++, which I am having real trouble trying to follow. Does anyone know of any resources that explains how the preperation of statements and fetching of the rows would work in VFP. Any help appreciated.Darren:
I never used maxdb but if you have an ODBC driver for example, it should be fairly easy to connect to using SPT. Something like:
cConnectionString = "Driver={mySQL};" +;
"Server=MyServerName;" +;
"Option=16834;" +;
"Database=mydb"
nHandle = SQLStringConnect(cConnectionString)
if nhandle < 0
return .F.
endif
nResult = SQLEXEC("Select * from Mytable")
See
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForMySQLhttp://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnectHTH