ADO 쿼리 방법
❮ 완전한 레코드세트 개체 참조
Requery 메서드는 원래 Recordset을 만든 쿼리를 다시 실행하여 Recordset의 데이터를 업데이트합니다.
팁: 이 방법을 사용하여 레코드세트의 전체 내용을 새로 고칩니다.
참고: 이 메서드를 사용하면 Close 및 Open 메서드를 하나로 호출합니다.
통사론
objRecordset.Requery options
| Parameter | Description |
|---|---|
| options | Optional. Specifies how to execute this command. Can be an ExecuteOptionEnum value |
ExecuteOptionEnum 값
| Constant | Value | Description |
|---|---|---|
| adOptionUnspecified | -1 | Unspecified command |
| adAsyncExecute | 16 | The command should execute asynchronously. Cannot be combined with the CommandTypeEnum value adCmdTableDirect |
| adAsyncFetch | 32 | The remaining rows after the initial quantity specified in the CacheSize property should be retrieved asynchronously |
| adAsyncFetchNonBlocking | 64 | The main thread never blocks while retrieving. If the requested row has not been retrieved, the current row automatically moves to the end of the file. If you open a Recordset from a Stream containing a persistently stored Recordset, adAsyncFetchNonBlocking will not have an effect; the operation will be synchronous and blocking. adAsynchFetchNonBlocking has no effect when the adCmdTableDirect option is used to open the Recordset |
| adExecuteRecord | 512 | The CommandText is a command or stored procedure that returns a single row which should be returned as a Record object |
❮ 완전한 레코드세트 개체 참조