Differenze tra le versioni di "GridBox"
(→Proprietà) |
|||
Riga 17: | Riga 17: | ||
==== Proprietà ==== | ==== Proprietà ==== | ||
− | + | ===== Action ===== | |
− | + | Property Action As String | |
− | + | ||
− | + | ===== AlwaysEditable ===== | |
− | + | Property AlwaysEditable As Boolean | |
− | + | ||
− | + | ===== AutoDataType ===== | |
− | + | Property AutoDataType As Boolean | |
− | + | ||
− | + | ===== AutoNew ===== | |
− | + | Property AutoNew As Boolean | |
− | + | ||
− | + | ===== Background ===== | |
− | + | Property Background As Integer | |
− | + | ||
− | + | ===== Border ===== | |
− | + | Property Border As Integer | |
− | + | ||
− | + | ===== Busy ===== | |
− | + | Property Busy As Boolean | |
− | + | ||
− | + | ===== Children ===== | |
− | + | Property Read Children As .ContainerChildren | |
− | + | ||
− | + | ===== ClientH ===== | |
− | + | Property Read ClientH As Integer | |
− | + | ||
− | + | ===== ClientHeight ===== | |
− | + | Property Read ClientHeight As Integer | |
− | + | ||
− | + | ===== ClientW ===== | |
− | + | Property Read ClientW As Integer | |
− | + | ||
− | + | ===== ClientWidth ===== | |
− | + | Property Read ClientWidth As Integer | |
− | + | ||
− | + | ===== ClientX ===== | |
− | + | Property Read ClientX As Integer | |
− | + | ||
− | + | ===== ClientY ===== | |
− | + | Property Read ClientY As Integer | |
− | + | ||
− | + | ===== Color ===== | |
− | + | Property Read Color As Color (Virtual class) | |
− | + | ||
− | + | ===== ColorRowAlternating ===== | |
− | + | Property ColorRowAlternating As Boolean | |
− | + | ||
− | + | ===== Column ===== | |
− | + | Property Column As Integer | |
− | + | ||
− | + | ===== Columns ===== | |
− | + | Property Read Columns As Columns (Virtual class) | |
− | + | ||
− | + | ===== Connection ===== | |
− | + | Property Connection As Connection | |
− | + | ||
− | + | ===== Cursor ===== | |
− | + | Property Cursor As Cursor | |
− | + | ||
− | + | ===== DataMining ===== | |
− | + | Property DataMining As Boolean | |
− | + | ||
− | + | ===== Design ===== | |
− | + | Property Design As Boolean | |
− | + | ||
− | + | ===== Drop ===== | |
− | + | Property Drop As Boolean | |
− | + | ||
− | + | ===== Enabled ===== | |
− | + | Property Enabled As Boolean | |
− | + | ||
− | + | ===== Expand ===== | |
− | + | Property Expand As Boolean | |
+ | |||
+ | ===== FieldKey ===== | ||
+ | Property FieldKey As String[] | ||
+ | |||
+ | ===== FieldReordering ===== | ||
+ | Property FieldReordering As String | ||
+ | |||
+ | ===== Font ===== | ||
+ | Property Font As Font | ||
+ | |||
+ | ===== Foreground ===== | ||
+ | Property Foreground As Integer | ||
+ | |||
+ | ===== GridOnly ===== | ||
+ | Property GridOnly As Boolean | ||
+ | |||
+ | ===== H ===== | ||
+ | Property H As Integer | ||
+ | |||
+ | ===== Handle ===== | ||
+ | Property Read Handle As Integer | ||
+ | |||
+ | ===== HasFocus ===== | ||
+ | Property Read HasFocus As Boolean | ||
+ | |||
+ | ===== Header ===== | ||
+ | Property Header As Integer | ||
+ | |||
+ | ===== Height ===== | ||
+ | Property Height As Integer | ||
+ | |||
+ | ===== Hovered ===== | ||
+ | Property Read Hovered As Boolean | ||
+ | |||
+ | ===== Id ===== | ||
+ | Property Read Id As Integer | ||
+ | |||
+ | ===== Ignore ===== | ||
+ | Property Ignore As Boolean | ||
+ | |||
+ | ===== KeyActivity ===== | ||
+ | Property KeyActivity As Boolean | ||
+ | |||
+ | ===== KeyGrid ===== | ||
+ | Property Read KeyGrid As KeyGrid (Virtual class) | ||
+ | |||
+ | ===== Left ===== | ||
+ | Property Left As Integer | ||
+ | |||
+ | ===== Mouse ===== | ||
+ | Property Mouse As Integer | ||
+ | |||
+ | ===== Name ===== | ||
+ | Property Name As String | ||
+ | |||
+ | ===== Next ===== | ||
+ | Property Next As Control | ||
+ | |||
+ | ===== Parent ===== | ||
+ | Property Read Parent As Container | ||
+ | |||
+ | ===== PicCheck ===== | ||
+ | Property PicCheck As Picture | ||
+ | |||
+ | ===== PicUncheck ===== | ||
+ | Property PicUncheck As Picture | ||
+ | |||
+ | ===== PopupMenu ===== | ||
+ | Property PopupMenu As String | ||
+ | |||
+ | ===== Previous ===== | ||
+ | Property Previous As Control | ||
+ | |||
+ | ===== Query ===== | ||
+ | Property Read Query As String[] | ||
+ | |||
+ | ===== ReadData ===== | ||
+ | Property Read ReadData As Result | ||
+ | |||
+ | ===== ReadOnly ===== | ||
+ | Property ReadOnly As Boolean | ||
+ | |||
+ | ===== Row ===== | ||
+ | Property Row As Integer | ||
+ | |||
+ | ===== RowSelected ===== | ||
+ | Property RowSelected As Integer[] | ||
+ | |||
+ | ===== Rows ===== | ||
+ | Property Read Rows As Rows (Virtual class) | ||
+ | |||
+ | ===== ScreenX ===== | ||
+ | Property Read ScreenX As Integer | ||
+ | |||
+ | ===== ScreenY ===== | ||
+ | Property Read ScreenY As Integer | ||
+ | |||
+ | ===== ScrollBar ===== | ||
+ | Property ScrollBar As Integer | ||
+ | |||
+ | ===== ScrollX ===== | ||
+ | Property ScrollX As Integer | ||
+ | |||
+ | ===== ScrollY ===== | ||
+ | Property ScrollY As Integer | ||
+ | |||
+ | ===== Table ===== | ||
+ | Property Read Table As Table | ||
+ | |||
+ | ===== TableName ===== | ||
+ | Property TableName As String | ||
+ | |||
+ | ===== Tag ===== | ||
+ | Property Tag As Variant | ||
+ | |||
+ | ===== TmpConnection ===== | ||
+ | Property Read TmpConnection As Connection | ||
+ | |||
+ | ===== Tooltip ===== | ||
+ | Property Tooltip As String | ||
+ | |||
+ | ===== Top ===== | ||
+ | Property Top As Integer | ||
+ | |||
+ | ===== Tracking ===== | ||
+ | Property Tracking As Boolean | ||
+ | |||
+ | ===== UpdateReording ===== | ||
+ | Property UpdateReording As Boolean | ||
+ | |||
+ | ===== Visible ===== | ||
+ | Property Visible As Boolean | ||
+ | |||
+ | ===== W ===== | ||
+ | Property W As Integer | ||
+ | |||
+ | ===== Width ===== | ||
+ | Property Width As Integer | ||
+ | |||
+ | ===== Window ===== | ||
+ | Property Read Window As Window | ||
+ | |||
+ | ===== X ===== | ||
+ | Property X As Integer | ||
+ | |||
+ | ===== Y ===== | ||
+ | Property Y As Integer | ||
+ | |||
==== Metodi ==== | ==== Metodi ==== | ||
==== Eventi ==== | ==== Eventi ==== |
Versione delle 05:25, 4 nov 2010
Indice
- 1 Introduzione
- 1.1 Le Classi esportabili
- 1.2 Simboli dell'oggetto GridBox
- 1.2.1 Proprietà
- 1.2.1.1 Action
- 1.2.1.2 AlwaysEditable
- 1.2.1.3 AutoDataType
- 1.2.1.4 AutoNew
- 1.2.1.5 Background
- 1.2.1.6 Border
- 1.2.1.7 Busy
- 1.2.1.8 Children
- 1.2.1.9 ClientH
- 1.2.1.10 ClientHeight
- 1.2.1.11 ClientW
- 1.2.1.12 ClientWidth
- 1.2.1.13 ClientX
- 1.2.1.14 ClientY
- 1.2.1.15 Color
- 1.2.1.16 ColorRowAlternating
- 1.2.1.17 Column
- 1.2.1.18 Columns
- 1.2.1.19 Connection
- 1.2.1.20 Cursor
- 1.2.1.21 DataMining
- 1.2.1.22 Design
- 1.2.1.23 Drop
- 1.2.1.24 Enabled
- 1.2.1.25 Expand
- 1.2.1.26 FieldKey
- 1.2.1.27 FieldReordering
- 1.2.1.28 Font
- 1.2.1.29 Foreground
- 1.2.1.30 GridOnly
- 1.2.1.31 H
- 1.2.1.32 Handle
- 1.2.1.33 HasFocus
- 1.2.1.34 Header
- 1.2.1.35 Height
- 1.2.1.36 Hovered
- 1.2.1.37 Id
- 1.2.1.38 Ignore
- 1.2.1.39 KeyActivity
- 1.2.1.40 KeyGrid
- 1.2.1.41 Left
- 1.2.1.42 Mouse
- 1.2.1.43 Name
- 1.2.1.44 Next
- 1.2.1.45 Parent
- 1.2.1.46 PicCheck
- 1.2.1.47 PicUncheck
- 1.2.1.48 PopupMenu
- 1.2.1.49 Previous
- 1.2.1.50 Query
- 1.2.1.51 ReadData
- 1.2.1.52 ReadOnly
- 1.2.1.53 Row
- 1.2.1.54 RowSelected
- 1.2.1.55 Rows
- 1.2.1.56 ScreenX
- 1.2.1.57 ScreenY
- 1.2.1.58 ScrollBar
- 1.2.1.59 ScrollX
- 1.2.1.60 ScrollY
- 1.2.1.61 Table
- 1.2.1.62 TableName
- 1.2.1.63 Tag
- 1.2.1.64 TmpConnection
- 1.2.1.65 Tooltip
- 1.2.1.66 Top
- 1.2.1.67 Tracking
- 1.2.1.68 UpdateReording
- 1.2.1.69 Visible
- 1.2.1.70 W
- 1.2.1.71 Width
- 1.2.1.72 Window
- 1.2.1.73 X
- 1.2.1.74 Y
- 1.2.2 Metodi
- 1.2.3 Eventi
- 1.2.1 Proprietà
- 1.3 Link utili
Introduzione
Una GridBox è un componente non ufficiale ma molto valido per chi lavora spesso con i database. Questo componente, tutto made in Gambas-it.org grazie all'ottimo lavoro dell'utente Milio, permette di creare semplicemente una griglia collegata a un database, con pochissime righe di codice, e già pronta con comandi quali: salvataggio, inserimento, eliminazione, modifica.
Una caratteristica interessante di questo componente è la possibilità di mantenere l'integrità dei dati, con l'aiuto di oggetti quali TextBox, ComboBox, CheckBox, ValueBox, ecc, per una corretta modifica/inserimento di record nel DataBase. Altre caratteristiche sono la formattazione dei dati, mantenendo l'integrità del loro valore, formattazioni condizionate in stile foglio di calcolo, colonne di tipo Formula per facilitare calcoli su i vari record, e altro ancora.
Le Classi esportabili
In questo componente abbiamo i seguenti oggetti che si possono utilizzare:
- GridBox
- Grid
- Conditional
- Cell
Simboli dell'oggetto GridBox
Proprietà
Action
Property Action As String
AlwaysEditable
Property AlwaysEditable As Boolean
AutoDataType
Property AutoDataType As Boolean
AutoNew
Property AutoNew As Boolean
Background
Property Background As Integer
Border
Property Border As Integer
Busy
Property Busy As Boolean
Children
Property Read Children As .ContainerChildren
ClientH
Property Read ClientH As Integer
ClientHeight
Property Read ClientHeight As Integer
ClientW
Property Read ClientW As Integer
ClientWidth
Property Read ClientWidth As Integer
ClientX
Property Read ClientX As Integer
ClientY
Property Read ClientY As Integer
Color
Property Read Color As Color (Virtual class)
ColorRowAlternating
Property ColorRowAlternating As Boolean
Column
Property Column As Integer
Columns
Property Read Columns As Columns (Virtual class)
Connection
Property Connection As Connection
Cursor
Property Cursor As Cursor
DataMining
Property DataMining As Boolean
Design
Property Design As Boolean
Drop
Property Drop As Boolean
Enabled
Property Enabled As Boolean
Expand
Property Expand As Boolean
FieldKey
Property FieldKey As String[]
FieldReordering
Property FieldReordering As String
Font
Property Font As Font
Foreground
Property Foreground As Integer
GridOnly
Property GridOnly As Boolean
H
Property H As Integer
Handle
Property Read Handle As Integer
HasFocus
Property Read HasFocus As Boolean
Header
Property Header As Integer
Height
Property Height As Integer
Hovered
Property Read Hovered As Boolean
Id
Property Read Id As Integer
Ignore
Property Ignore As Boolean
KeyActivity
Property KeyActivity As Boolean
KeyGrid
Property Read KeyGrid As KeyGrid (Virtual class)
Left
Property Left As Integer
Mouse
Property Mouse As Integer
Name
Property Name As String
Next
Property Next As Control
Parent
Property Read Parent As Container
PicCheck
Property PicCheck As Picture
PicUncheck
Property PicUncheck As Picture
PopupMenu
Property PopupMenu As String
Previous
Property Previous As Control
Query
Property Read Query As String[]
ReadData
Property Read ReadData As Result
ReadOnly
Property ReadOnly As Boolean
Row
Property Row As Integer
RowSelected
Property RowSelected As Integer[]
Rows
Property Read Rows As Rows (Virtual class)
ScreenX
Property Read ScreenX As Integer
ScreenY
Property Read ScreenY As Integer
ScrollBar
Property ScrollBar As Integer
ScrollX
Property ScrollX As Integer
ScrollY
Property ScrollY As Integer
Table
Property Read Table As Table
TableName
Property TableName As String
Tag
Property Tag As Variant
TmpConnection
Property Read TmpConnection As Connection
Tooltip
Property Tooltip As String
Top
Property Top As Integer
Tracking
Property Tracking As Boolean
UpdateReording
Property UpdateReording As Boolean
Visible
Property Visible As Boolean
W
Property W As Integer
Width
Property Width As Integer
Window
Property Read Window As Window
X
Property X As Integer
Y
Property Y As Integer