Punkte nach der Entfernung zur Mauskoordinate sortieren
Private Sub Pic1_MouseDown(Button%, Shift%, xg!, yg!)
Dim dy As Recordset, dy2 As Recordset, Sql$
Const Umkreis = 100
If Button = 2 Then
Sql = "Select *,int(sqr((Y-" + Val(xg) + ")^2 + (X- " + Val(yg) + ")^2)) as dS "
Sql = Sql + "From PL Where y Between " + Val(xg - Umkreis) + " And " + Val(xg + Umkreis)
Sql = Sql + " AND X Between " + Val(yg - Umkreis) + " And " + Val(yg + Umkreis)
Set dy = gDB.OpenRecordset(Sql)
Set dy2 = dy: dy2.Sort = "ds"
Set dy = dy2.OpenRecordset(dy2.Type)
Set Data1.Recordset = dy
If Not dy.EOF Then
DBGrid1.Visible = True
Else
DBGrid1.Visible = False
End If
End If
End Sub
|