Home > database >  Pb in the data window is used to implement multiple function
Pb in the data window is used to implement multiple function

Time:10-22

Pb how to use the data in the window function of multiple examples who can give me under reference, 872894181 @qq.com, thank you

CodePudding user response:

In SQL join two empty field, such as
SELECT *, 'N' AS checked, 'N' AS SeleAll
The FROM TableName
Adjust the input mode to the check box, like the image below

CodePudding user response:

http://blog.csdn.net/caok/article/details/4039197

CodePudding user response:

Long ll_currentrow
Long ll_j, ll_s


If the row & lt; 1 then Return

If the row=0 then
Return
The Else
Ll_currentrow=row
End the if

Ll_s=This. Getselectedrow (0)

If keydown (keyshift! Then
If ll_s=0 then
Enclosing selectrow (ll_currentrow, true)
The Else
Enclosing selectrow (0, false)
If ll_currentrow & gt; Ll_s then
For ll_j=ll_s to ll_currentrow
Enclosing selectrow (ll_j, true)
End for
The Else
For ll_j=ll_s to ll_currentrow step - 1
Enclosing selectrow (ll_j, true)
End for
End the if

End the if
The Else

If keydown (keycontrol! Then
If this. An isselected (ll_currentrow) then
Enclosing selectrow (ll_currentrow, false)
The Else
Enclosing selectrow (ll_currentrow, true)
End the if
The Else
Enclosing selectrow (0, false)
Enclosing selectRow (ll_CurrentRow, true)
End the if
End the if
  • Related