Commit graph

118 commits

Author SHA1 Message Date
Benoît Minisini
ac15f27a96 Correctly check if the RETURNING keyword is available.
[GB.DB.MYSQL]
* BUG: Correctly check if the RETURNING keyword is available, by searching for "MariaDB" in the full version string, and checking the version number.
2023-08-25 04:24:35 +02:00
Benoît Minisini
f3c2d461de MySQL 8.0.34 does not support automatic reconnection anymore.
[GB.DB.MYSQL]
* NEW: MySQL 8.0.34 does not support automatic reconnection anymore.
2023-08-18 13:39:04 +02:00
Benoît Minisini
72971105ef Support for new 'Connection.FullVersion' property in database drivers. Tells if 'RETURNING' keyword is implemented.
[GB.DB.MYSQL]
* NEW: Support for new 'Connection.FullVersion' property.
* NEW: Tells if 'RETURNING' keyword is implemented.

[GB.DB.ODBC]
* NEW: Support for new 'Connection.FullVersion' property.
* NEW: Tells if 'RETURNING' keyword is implemented.

[GB.DB.POSTGRESQL]
* NEW: Support for new 'Connection.FullVersion' property.
* NEW: Tells if 'RETURNING' keyword is implemented.

[GB.DB.SQLITE2]
* NEW: Support for new 'Connection.FullVersion' property.
* NEW: Tells if 'RETURNING' keyword is implemented.

[GB.DB.SQLITE3]
* NEW: Support for new 'Connection.FullVersion' property.
* NEW: Tells if 'RETURNING' keyword is implemented.
2023-07-14 12:08:51 +02:00
Benoît Minisini
6a793ddeb7 Replace my old depracted gmail mail by the new one.
[CONFIGURATION]
* NEW: Replace my old depracted gmail mail by the new one.
2022-09-12 15:13:13 +02:00
Benoît Minisini
415de7b257 Update configuration files to autoconf 2.71.
[CONFIGURATION]
* NEW: Update configuration files to autoconf 2.71.
2022-09-03 13:24:51 +02:00
Benoît Minisini
fda74fceaf Use VARCHAR for string fields up to 65535 characters maximum length.
[GB.DB.MYSQL]
* BUG: Use VARCHAR for string fields up to 65535 characters maximum length.
2022-08-07 20:36:35 +02:00
gambas
874919155c Still trying to adapt option management to old version of mysql.
[GB.DB.MYSQL]
* BUG: Still trying to adapt option management to old version of mysql.
2022-04-09 16:42:14 +02:00
gambas
23c1e03580 BUG: Still trying to adapt option management to old version of mysql.
[GB.DB.MYSQL]
* BUG: Still trying to adapt option management to old version of mysql.
2022-04-09 16:21:10 +02:00
gambas
337c5e1f3b Fix a forgotten comma.
[GB.DB.MYSQL]
* BUG: Fix a forgotten comma.
2022-04-09 16:04:13 +02:00
gambas
abd3634e3f Adapt options management to the different mysql versions.
[GB.DB.MYSQL]
* BUG: Adapt options management to the different mysql versions.
2022-04-09 15:45:18 +02:00
gambas
9402047435 Support for the 'Collection.Options' property.
[GB.DB.MYSQL]
* NEW: Support for the 'Collection.Options' property.

[GB.DB.ODBC]
* NEW: Support for the 'Collection.Options' property.

[GB.DB.POSTGRESQL]
* NEW: Support for the 'Collection.Options' property.

[GB.DB.SQLITE2]
* NEW: Support for the 'Collection.Options' property.

[GB.DB.SQLITE3]
* NEW: Support for the 'Collection.Options' property.
2022-04-09 13:30:42 +02:00
gambas
072bd1cc77 All UTF-8 charsets variants are now returned as "utf8".
[GB.DB.MYSQL]
* BUG: All UTF-8 charsets variants are now returned as "utf8".
2021-08-27 13:08:22 +02:00
gambas
8849435381 Creating a numeric field with a default value works correctly now.
[GB.DB.MYSQL]
* BUG: Creating a numeric field with a default value works correctly now.
2021-08-26 13:31:19 +02:00
gambas
68ecfe8d0f Unlimited string fields now use 'MEDIUMTEXT' type instead of 'TEXT', so that their actual maximum size is now 16 Mb.
[GB.DB.MYSQL]
* BUG: Unlimited string fields now use 'MEDIUMTEXT' type instead of 'TEXT', so that their actual maximum size is now 16 Mb.
2021-06-21 19:05:07 +02:00
gambas
50e3b33eaf Update to the new signature of Result.Release() driver API.
[GB.DB.MYSQL]
* NEW: Update to the new signature of Result.Release() driver API.

[GB.DB.POSTGRESQL]
* NEW: Update to the new signature of Result.Release() driver API.

[GB.DB.SQLITE2]
* NEW: Update to the new signature of Result.Release() driver API.

[GB.DB.SQLITE3]
* NEW: Update to the new signature of Result.Release() driver API.
2021-04-10 16:23:00 +02:00
Bastian Germann
f0cf49ada7 Compile with MySQL version >= 8.0.1
The my_bool type was removed with MySQL 8.0.1:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-1.html#mysqld-8-0-1-compiling

Replace my_bool with char which was the typedef in older MySQL versions
and still is in MariaDB.

[GB.DB.MYSQL]
* BUG: Compile with MySQL version >= 8.0.1.
2020-03-08 22:26:02 +01:00
gambas
af5859f1ca Fix compilation.
[GB.DB.MYSQL]
* BUG: Fix compilation.
2020-01-25 19:25:25 +01:00
gambas
0c2345925f Print a warning message if disabling SSL connection is not supported.
[GB.DB.MYSQL]
* NEW: Print a warning message if disabling SSL connection is not supported.
2020-01-25 17:30:17 +01:00
gambas
08efaddf79 Detect SSL_MODE_DISABLED at configure time, to make the component compile on older mysql clients.
[GB.DB.MYSQL]
* BUG: Detect SSL_MODE_DISABLED at configure time, to make the component compile on older mysql clients.
2020-01-25 10:18:23 +01:00
gambas
1e7d80c8a1 Make 'gb.db.mysql' compile with MySQL version < 8.0.0.
[GB.DB.MYSQL]
* BUG: Make 'gb.db.mysql' compile with MySQL version < 8.0.0.
2020-01-25 07:15:29 +01:00
gambas
9613341c41 Make 'gb.db.mysql' compile with MySQL version < 5.7.11.
[GB.DB.MYSQL]
* BUG: Make 'gb.db.mysql' compile with MySQL version < 5.7.11.
2020-01-25 06:48:19 +01:00
gambas
bb87e1885b Make 'gb.db.mysql' compile with MySQL version < 5.6.36.
[GB.DB.MYSQL]
* BUG: Make 'gb.db.mysql' compile with MySQL version < 5.6.36.
2020-01-25 06:17:09 +01:00
gambas
902fd4aae2 Add support for GB_DB_MYSQL_NOSSL environment variable, that allows to disable SSL connections. They are buggy in some versions of the mysql client library.
[GB.DB.MYSQL]
* NEW: Add support for GB_DB_MYSQL_NOSSL environment variable, that allows to disable SSL connections. They are buggy in some versions of the mysql client library.
2020-01-24 08:33:54 +01:00
Christian Ehrhardt
38b9915c42 build with newer mysql/mariadb
Recent releases only need to include mysql.h for a long time and in the
meantime even removed most other headers.
Un-break gb.db.mysql/configure.ac by not strictly requiring this old header.
2019-09-04 23:42:18 +02:00
gambas
234c2c690a [GB.DB]
* NEW: Add a driver API that handles debugging messages.
* NEW: Print the current date/time before any debugging message.

[GB.DB.MYSQL]
* NEW: Use the new driver API to print debugging messages.

[GB.DB.ODBC]
* NEW: Use the new driver API to print debugging messages.

[GB.DB.POSTGRESQL]
* NEW: Use the new driver API to print debugging messages.

[GB.DB.SQLITE2]
* NEW: Use the new driver API to print debugging messages.

[GB.DB.SQLITE3]
* NEW: Use the new driver API to print debugging messages.
2019-08-30 09:09:16 +02:00
Bastian Germann
b6a00614ef Changes to the build system 2018-08-29 01:11:22 +00:00
gambas
e07ac2e4f2 Connection.LastInsertId is a new property that returns the value of the serial field used in the last inserted row.
[GB.DB]
* NEW: Connection.LastInsertId is a new property that returns the value of the serial field used in the last inserted row. It is supported on MySQL, PostgreSQL and SQLite3 only.
* BUG: Connection.Handle is correctly declared now.

[GB.DB.MYSQL]
* NEW: Support for Connection.LastInsertId.

[GB.DB.ODBC]
* NEW: Raise an error if Connection.LastInsertId is used.

[GB.DB.POSTGRESQL]
* NEW: Support for Connection.LastInsertId.

[GB.DB.SQLITE2]
* NEW: Raise an error if Connection.LastInsertId is used.

[GB.DB.SQLITE3]
* NEW: Support for Connection.LastInsertId.
2018-03-20 16:05:33 +01:00
gambas
09a0573e61 Replace my old sourceforge mail address by the new one.
[CONFIGURATION]
Replace my old sourceforge mail address by the new one.
2018-02-12 02:53:46 +01:00
Laurent Carlier
8dc6679530 Remove 'missing' file ,generated by autotools, from the repository 2017-08-13 16:13:06 +02:00
Benoît Minisini
82eddfd5c9 [CONFIGURATION]
* NEW: Remove all 'depcomp' files. Apparently they are not used anymore by autoconf.

[INTERPRETER]
* BUG: Fix some gcc 6 warnings.

[GB.DEBUG]
* BUG: Fix some gcc 6 warnings.

[GB.GTK]
* BUG: Fix some gcc 6 warnings.
* BUG: Fix a ';' mistake in a focus management test.

[GB.GTK3]
* BUG: Fix some gcc 6 warnings.
* BUG: Fix a ';' mistake in a focus management test.

[GB.IMAGE]
* BUG: Fix some gcc 6 warnings.


git-svn-id: svn://localhost/gambas/trunk@8101 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2017-02-18 17:24:01 +00:00
Benoît Minisini
5e35328bf5 [GB.DB.MYSQL]
* BUG: Deleting an index does not crash anymore.


git-svn-id: svn://localhost/gambas/trunk@8077 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2017-02-01 01:27:57 +00:00
Benoît Minisini
adc86b9e39 [GB.DB.MYSQL]
* BUG: Use MEDIUMTEXT instead of TEXT for unlimited text fields, so that the maximum length is 16MB and not 64K.


git-svn-id: svn://localhost/gambas/trunk@8072 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2017-01-30 21:37:56 +00:00
Benoît Minisini
b225eba20f [CONFIGURATION]
* NEW: Update copyright year in all source files.


git-svn-id: svn://localhost/gambas/trunk@8056 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2017-01-13 03:29:42 +00:00
Benoît Minisini
59d84053a9 [GB.DB.MYSQL]
* BUG: Use "START TRANSACTION" instead of "BEGIN", because I was told that BEGIN actually does nothing as autocommit is set by default.


git-svn-id: svn://localhost/gambas/trunk@7756 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2016-05-04 14:56:57 +00:00
Benoît Minisini
dc0607ac4a [GB.DB.MYSQL]
* BUG: TINY(1) field are now correctly converted into Gambas booleans in all cases.


git-svn-id: svn://localhost/gambas/trunk@7721 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2016-04-05 21:02:58 +00:00
Benoît Minisini
ba3fe3f1dd [GB.DB.MYSQL]
* BUG: Remove useless "set autocommit" at each transaction. Why that?


git-svn-id: svn://localhost/gambas/trunk@7655 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2016-03-21 14:35:41 +00:00
Benoît Minisini
03fd5166f1 [GB.DB.ODBC]
* NEW: Support for "forward only" query result.


git-svn-id: svn://localhost/gambas/trunk@7316 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2015-09-16 19:50:55 +00:00
Benoît Minisini
3818ea749e [GB.DB.MYSQL]
* BUG: USe the MySQL documentation trick to make the difference between a
  blob field and a text field. This should work far better than using the
  "max_length" value returned by the MySQL API that seems to randomly 
  change between MySQL versions.


git-svn-id: svn://localhost/gambas/trunk@7229 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2015-08-19 22:33:20 +00:00
Benoît Minisini
08c0e1037e [DEVELOPMENT ENVIRONMENT]
* NEW: Farm client: Always draw software icon to the left.

[GB.DB.MYSQL]
* NEW: Use the a void database name by default, instead of explicitly 
  connecting to the "mysql" database.

[GB.GTK]
* BUG: Window.NoTakeFocus works correctly now.

[GB.GTK3]
* BUG: Window.NoTakeFocus works correctly now.

[GB.QT4]
* BUG: Non modal windows opened on top of modal windows now are correctly 
  closable now.
* BUG: Default window title is correctly initialized now.

[GB.QT5]
* BUG: Non modal windows opened on top of modal windows now are correctly 
  closable now.
* BUG: Window.NoTakeFocus should work in all cases now.
* BUG: Default window title is correctly initialized now.


git-svn-id: svn://localhost/gambas/trunk@7205 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2015-08-01 09:13:03 +00:00
Benoît Minisini
706648c7c8 [WEBSITE MAKER]
* NEW: Upgrade to 3.7.1 version.

[GB.DB]
* NEW: Connection.SQL is a new property that returns a new SQLRequest 
  object that can be used for forging a SQL request whose syntax is adapted
  to the target connection.
* NEW: SQLRequest is a new class that helps to build a SQL request whose 
  syntax is adapted to a specific connection. The name of table fields are 
  always quoted so that they can include reserved characters.

[GB.DB.FORM]
* NEW: Use the new SQL property of the Connection object to build request.
* BUG: Fields with special characters in their name are now correctly
  quoted, thanks to the new SQL forgin mechanism.

[GB.DB]
* BUG: Don't crash when a SQLite database is not found and if the hostname 
  is null.
* NEW: GB_DB_DEBUG is a new environmental variable that allows to 
  externally set the DB.Debug property.
  
[GB.EVAL.HIGHLIGHT]
* NEW: SQL higlighting: the '`' quote character is taken into account now.


git-svn-id: svn://localhost/gambas/trunk@7020 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2015-04-03 21:11:18 +00:00
Benoît Minisini
ffff20444b [GB.DB.MYSQL]
* BUG: Blob fields and unlimited text fields should be detected correctly 
  in all cases now.


git-svn-id: svn://localhost/gambas/trunk@7018 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2015-04-03 01:30:54 +00:00
Benoît Minisini
980d9cc8e9 [GB.DB.MYSQL]
* BUG: Don't crash when removing something from the metadata cache.


git-svn-id: svn://localhost/gambas/trunk@7000 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2015-03-25 20:53:20 +00:00
Benoît Minisini
b0bb9fa480 [DEVELOPMENT ENVIRONMENT]
* BUG: Expression analyze now works correctly when ME or SUPER is used.

[FARM SERVER]
* NEW: Use the new automatic database creation feature.

[WIKI SERVER]
* NEW: Support for babelmark markdown syntax comparison.

[GB.DB]
* BUG: Don't crash at connection opening when no database name is 
  specified.
* NEW: The Connection class has now a part written in Gambas, and the C 
  part has been put in a parent hidden class named '_Connection'.
* NEW: Connection.GetTemplate() is a new method that return the description
  of the database as a string template.
* NEW: Connection.ApplyTemplate() is a new method that takes the previous
  template to initialize the structure of the database. If a table included
  in the description already exists, it is silently ignored.
* NEW: Connections.Create() is a new static method that create a specific
  database from a named connection and its template as saved by the IDE
  in the current project.


git-svn-id: svn://localhost/gambas/trunk@6657 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2014-11-19 18:45:18 +00:00
Benoît Minisini
dd41b47ef3 [DEVELOPMENT ENVIRONMENT]
* NEW: The structure of databases is now stored in the *.connection files.
  It will be used for an automatic database initialization feature.

[WEBSITE MAKER]
* NEW: Update for 3.6.2.

[WIKI CGI SCRIPT]
* BUG: Fix the display of page without headers.
* NEW: Indexes are now displayed on two or more columns.

[INTERPRETER]
* NEW: New GB.AllocZero() API for allocating memory and filling it with 
  zeros.

[GB.DB.MYSQL]
* OPT: Cache metadata queries during 30 secondes to speed up things.

[GB.FORM]
* NEW: MenuButton displays a focus rectangle now.

[GB.GUI.BASE]
* BUG: ProgressBar now raises native control events.


git-svn-id: svn://localhost/gambas/trunk@6652 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2014-11-16 21:40:47 +00:00
Benoît Minisini
44f062f81f [GB.DB.MYSQL]
* BUG: Try to reconnect to a lost database server when listing existing 
  databases and the fields of a table.


git-svn-id: svn://localhost/gambas/trunk@6614 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2014-11-06 23:38:51 +00:00
Benoît Minisini
7fa6cd0569 [DEVELOPMENT ENVIRONMENT]
* NEW: Database editor: Support for the new Collation field property.

[EXAMPLES]
* BUG: PdfViewer: Some little fixes.

[GB.DB]
* NEW: Table.Fields.Add() method takes a new optional argument to define
  the field collation.
* NEW: Connection.Collations is a new property that returns the list of
  available collations as a String array.
* NEW: Field.Collation is a new property that returns the collation of a
  specific table field.

[GB.DB.MYSQL]
* NEW: Support for field collations.

[GB.DB.ODBC]
* NEW: Raise an error when trying to use collations. It is not supported.

[GB.DB.POSTGRESQL]
* NEW: Support for field collations.

[GB.DB.SQLITE2]
* NEW: Raise an error when trying to use collations. It is not supported.

[GB.DB.SQLITE3]
* NEW: Support for field collations.

[GB.QT4]
* BUG: ComboBox.Border property can be set even if it is in read-only mode.


git-svn-id: svn://localhost/gambas/trunk@6494 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2014-09-22 02:52:05 +00:00
Benoît Minisini
5e76433eeb [CONFIGURATION]
* NEW: Do not use deprecated autoconf macros anymore.
* NEW: The version information is now located in the 'version.m4' file in
  the source root directory.


git-svn-id: svn://localhost/gambas/trunk@6230 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2014-04-05 21:22:43 +00:00
Benoît Minisini
4f566fa199 [DEVELOPMENT ENVIRONMENT]
* BUG: Forgot the description of gb.opengl.sge.

[INTERPRETER]
* BUG: Propagate the GB_DATE_SERIAL structure changes to all components.


git-svn-id: svn://localhost/gambas/trunk@5879 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2013-10-13 12:39:56 +00:00
Benoît Minisini
c9ca5ab982 [CONFIGURATION]
* NEW: Update copyright year to 2013.

[GB.FORM]
* NEW: ImageView is a new control that allows to view an image inside a 
  scrolled view, at different zoom levels.
* BUG: FileProperties now works correctly if 'gb.desktop' is not used.
* NEW: The FileProperties preview tab now uses an ImageView control and has
  a toolbar to zoom the preview.
* BUG: Add the 'linux' and 'gnu' icon in the stock icon list.


git-svn-id: svn://localhost/gambas/trunk@5770 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2013-08-03 15:38:01 +00:00
Benoît Minisini
af5bdc6f45 [GB.DB.MYSQL]
* BUG: Database charset is correctly reset when an automatic reconnect 
  occurs.

[GB.FORM]
* OPT: LCDLabel highlight is now drawn with the Image.Fuzzy() method.

[GB.QT4]
* NEW: The drag & drop frame is now transparent.
* BUG: The drag & drop frame is now correctly hidden in all cases when dnd 
  operation is finished.


git-svn-id: svn://localhost/gambas/trunk@5539 867c0c6c-44f3-4631-809d-bfa615b0a4ec
2013-02-09 23:41:41 +00:00