PdcDBQuery.NextRecord: Difference between revisions
Jump to navigation
Jump to search
Created page with "== Declaration == NextRecord == Description == Moves the pointer to the next record == Notes == This method will move the record pointer to the next record in the created q..." |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 9: | Line 9: | ||
== Code example == | == Code example == | ||
This code example executes a SQL statement and moves the pointer to the next record. | |||
<source lang="vb"> | <source lang="vb"> | ||
Sub sExecuteQuery | |||
dim objQuery | |||
dim intCnt | |||
set objQuery = pdc.Database.OpenQuery(pdcConData) | |||
objQuery.SQL = "SELECT * FROM LK_KLANT" | |||
if objQuery.Execute then | |||
objQuery.NextRecord | |||
else | |||
msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & objQuery.SQL | |||
end if | |||
End Sub | |||
</source> | </source> | ||
== Availability == | == Availability == | ||
Available since September 2008 (from version 3.8) | Available since September 2008 (from version 3.8) | ||
Latest revision as of 15:09, 29 December 2021
Declaration
NextRecord
Description
Moves the pointer to the next record
Notes
This method will move the record pointer to the next record in the created query.
Code example
This code example executes a SQL statement and moves the pointer to the next record.
Sub sExecuteQuery
dim objQuery
dim intCnt
set objQuery = pdc.Database.OpenQuery(pdcConData)
objQuery.SQL = "SELECT * FROM LK_KLANT"
if objQuery.Execute then
objQuery.NextRecord
else
msgbox "Error:" & vbCrLf & pdc.LastError & vbCrLf & vbCrLf & "SQL:" & vbCrLf & objQuery.SQL
end if
End Sub
Availability
Available since September 2008 (from version 3.8)