TPSQL/es: what changed

Revision 1 to 2. Removed lines have a minus sign; added lines have a plus sign.

Old	New		Line
1	1		### Acerca de
2	2
3	3		TPSQL e un paquete modificado bajo LGPL para Lazarus. Define dos componentes, TPSQLDatabase y TPSQLDataset, permitiendo a las aplicaciones conectar con servidores de bases de datos PostgreSQL en redes que utilizan TCP/IP.
4	4
5	5		La descarga contiene los ficheros de componentes Pascal, el fichero de paquete para Lazarus y los ficheros de recursos junto con los ficheros de texto que describen la licencia modified-LGPL.
6	6
7	7		Este componente fué diseñado para su utilización en aplicaciones corriendo bajo plataformas Linux y Win32.
8	8
9	9		### Autor
10	10
11	11		Antonio d'Avino
12	12
13	13		### Licencia
14	14
15	15		LGPL modificada (leer COPYING.modifiedLGPL y COPYING.LGPL que se incluyen en el paquete).
16	16
17	17		### Descarga
18	18
19	19		La última versión estable se puede encontrar en [Lazarus CCR Files page](http://sourceforge.net/project/showfiles.php?group_id=92177&package_id=98986) o en la página web del autor [<http://infoconsult.homelinux.net>](http://infoconsult.homelinux.net).
20	20
21	21		### Historial de cambios
22	22
23	23		- Version 0.4.0 2005/06/01
24	24		- Version 0.4.1 2005/06/02
25	25
26	26		` - ClientEncoding property added to TPSQLDatabase class. `
27	27
28	28		- Version 0.4.2 2005/06/03
29	29
30	30		` - Some changes to destroy method of TPSQLDatabase/TPSQLDataset for avoiding exception`\
31	31		` when closing IDE/project with components in Active/Connected status.`\
32	32		` - Base path in archived files changed from 'usr/share/lazarus/components/psql' to 'psql'`
33	33
34	34		- Version 0.4.6 2005/06/06
35	35
36	36		` - Executing queries that doesn't return data column now raises an exception.`\
37	37		` - commandQuery function added (see Usage section).`\
38	38		` - beginTransaction/commitTransaction/rollbackTransaction support added (see Usage section).`\
39	39		` - More ClientEncoding entities added.`
40	40
41	41		### Dependencias / Requerimientos del sistema
42	42
43	43		- Lazarus 0.9.6 (FPC 1.9.8)
44	44
45	45		Stado: estable
46	46
47	47		Issues: Testeado bajo Windows (Win2K) y Linux (Mdk 10.1). Servidor de base de datos: PostgreSQL 8.0.3 (corriendo en ambas plataformas).
48	48
49	49		### Instalación
50	50
51	51		- In the lazarus/components directory, untar (unzip) the files from psql-laz-package-\<version\>.tar.gz file. The psql folder will be created.
52	52		- Open lazarus
53	53		- Open the package psql_laz.lpk with Component/Open package file (.lpk)
54	54		- (Click on Compile only if you don't want to install the component into the IDE)
55	55		- Click on Install and answer 'Yes' when you are asked about Lazarus rebuilding. A new tab named 'PSQL' will be created in the components palette.
56	56
57	57		Nota importante para los usuarios de Win32.
58	58
59	59		`En caso de experimentar dificultades a la hora de compilar los ficheros Pascal del paquete, puede que se necesite añadir la siguiente trayectoria:`\
60		-	\
	60	+
61	61		` `\
62	62		`<some-drive>:<some-path>\lazarus\lcl\units\i386-win32 `\
63	63		`(ie: c:\programs\lazarus\lcl\units\i386-win32)`\
64	64		` `\
65	65		`to the 'Other unit files ...' in 'Paths' tab of 'Compiler Options' of the lazarus package manager `\
66	66		`window.`
67	67
68	68		### Usage
69	69
70	70		Drop a TPSQLDatabase component on a form, for any different PostgreSQL database your application needs to connect to. Mandatory property of this component you have to set are:
71	71
72	72		- DatabaseName : The name of the PostgreSQL database that your application needs to connect to.
73	73		- HostName : the IP address or the URL of the PC hosting the PostgreSQL server.
74	74		- UserName : The name of an user having permission to access to host/database.
75	75
76	76		Optionally you may need to set Password property for correct connection to server. Then, to activate the connection, you neet to set the Connected property to 'True'. An exception will be raised if connection failed (wrong parameters, user with no permission to access the host/database, network errors or PostgreSQL server not active). Set this property to 'False' for closing connection.
77	77
78	78		- Note about the ClientEncoding property.
79	79
80	80		`The ClientEncoding property allows user to set a character set for the client`\
81	81		`application different from the one defined for the database. The PostgreSQL server`\
82	82		`make a 'translation' between the two sets. However a "ClientEncoding change failed" `\
83	83		`exception may be the result of a ClientEncoding property change. This may be due to`\
84	84		`a database character set incompatible with the clientencoding you selected. IE, `\
85	85		`the char set 'LATIN9' is not compatible with a 'WIN1250'. You select the default`\
86	86		`char set for the whole database cluster when you create it with the command`\
87	87		`'initdb', using the -E option: IE. 'initdb -E UNICODE'. Also, you can define a`\
88	88		`different character set for any database you create (different from the `\
89	89		`default one of the whole db cluster), also with the -E option:`\
90		-	\
	90	+
91	91		`IE. 'createdb -E UNICODE Test' `\
92	92		` `\
93	93		` or`\
94		-	\
	94	+
95	95		`CREATE DATABASE TEST WITH ENCODING 'UNICODE';`\
96		-	\
	96	+
97	97		`(note you must quote the character set name in the 'CREATE DATABASE' command).`\
98		-	\
	98	+
99	99		`I suggest to set UNICODE character set as the default for your db cluster (or for the`\
100	100		`database you create), because it is compatible with the whole set of charset available`\
101	101		`for the client, except the MULE_INTERNAL.`
102	102
103	103		Now you may drop a TPSQLDataset component on the form for any table connection you need. The main property to set on this component type is the Database one. A dropdown menu allows you to select one of any TDatabase descendant component present on form (of course, you must select a TPSQLDatabase component).
104	104
105	105		You also need to provide a valid SQL statement in SQL property. Now, you are able to open the TPSQLDataset, setting to 'True' the Active property. Several exceptions are provided for signaling failing conditions. Please, refer to TDataSet documentation for infos and examples about using the TPSQLDataset component in order to access to SQL retrieved data rows as well as conneting to Data Controls components. However, procedures and functions added to parent class are explained here:
106	106
107	107		\- function commandQuery ( query : String) : ShortInt.
108	108
109	109		`Use this function for submit queries that doesn't returns data columns, as update queries`\
110	110		`(ie. update, insert, delete etc.). Current dataset is not affected, however it will reflect `\
111	111		`changes made by execution of commandQuery itself, if it has some influence on current `\
112	112		`dataset.Function returns 0 if succeded, -1 if failed. No exceptions are provided.`
113	113
114	114		\- procedure beginTransaction
115	115
116	116		` Starts a SQL transaction session. Changes to table may be submitted`\
117	117		` using the commandQuery function.`
118	118
119	119		\- procedure commitTransaction
120	120
121	121		` Ends a SQL transaction session, commiting changes submitted starting`\
122	122		` from last beginTransaction execution.`
123	123
124	124		\- procedure rollbackTransaction
125	125
126	126		` Ends a SQL transaction session, aborting changes.`
127	127
128	128		---
129	129		From the Free Pascal wiki, page "TPSQL/es", as it stood on 2012-05-22 after a change by Iskraelectrica, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's [[Licensing]] page. If you have concerns about this material, [message the admin](/wiki-contact).
130	130		Category: Castellano
131	131		Category: Español

Back to history