# EFFECT

#### 1. Câu lệnh sql lấy mật khẩu super

select dbo.Encrypt((select pwd from \_USERS where MA\_USER=1))

#### 2. Ghép U.dbf bản effect2.0

* Copy hàm ở dưới vào sdt()
* Vào mode lập trình hoặc mode cus
  * mode cus: Vào màn hình tìm kiếm, Bấm Ctrl+Alt + S 
* Bấm Ctrl+F11 để hiện cửa sổ lệnh chạy
* Nhập tên function và enter để chạy lệnh: ghepthutien()

```
// Some code
FUNCTION ghepthutien
nn=adir(ardir,p_defdir+"sepdata\u*.dbf")
use p_defdir+"\thu_tien.dbf" in thu_tien alia thutien excl
*wait wind "1"
sele thutien
dele all
pack
*wait wind "2"
sele thutien
for i=1 to nn
	_st = p_defdir+"sepdata\" + ardir(i,1)
	sele thutien
	appen from &_st
endf
*wait wind "3"
sele thutien
pack
*wait wind "4"

```

3. Code thêm bổ sung kiểm tra lỗi khi đồng bộ bản 2.0

<figure><img src="/files/cl9bYIGleubZ2RuPsuko" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kythuat.dtechvn.com/effect.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.