General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Timothy,
>you have to set the maxrecords property before you open the recordset.
Below is the code I am using. Am I doing something wrong here?
' Create ADO connection object
Set loConnection = sdMtsObjectCreate(poMTSContext, "ADODB.Connection")
' Create ADO recordset object
Set loRsToBll = sdMtsObjectCreate(poMTSContext, "ADODB.Recordset")
' Open connection to data source
loConnection.Open APP_CONNECTION
' Allow "abc" = "a" to be true
loConnection.Execute ("SET ANSI OFF")
' Set maximum records returned (does not work)
loRsToBll.MaxRecords = 200
' Query data source
loRsToBll.Open tcSQL, loConnection, adOpenStatic, adLockReadOnly, adCmdText
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only