ANN: Upscene releases Database Workbench 5.6.0

2019-02-26 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.6.0 " This new release brings you the Command Line Data Pump & Favorites feature (Pro Edition) and a few important bugfixes. Version 5.5 brought you

ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL

2019-01-15 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.5.0 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.5.0 " This new release brings you support for the latest versions of supported database systems, that

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

2018-10-30 Thread Martijn Tonies (Upscene Productions)
Hi there, In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB

ANN: Upscene releases Database Workbench 5.4.6

2018-10-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.6 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.4.6 " This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.7 and

ANN: Upscene releases Database Workbench 5.4.4

2018-07-09 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.4 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a

ANN: Stored routine debugger Hopper, version 2.0.1 released

2018-06-27 Thread Martijn Tonies (Upscene Productions)
ts, binary data in variables and much more. For more information, see http://www.upscene.com/go/?go=news=20180627 With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Upscene releases Database Workbench 5.4.2

2018-03-06 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.2 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.2 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version

ANN: Upscene releases Database Workbench 5.4.0

2018-02-05 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.0 " This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a

In MySQL 8.0, how does one recognize roles?

2018-01-09 Thread Martijn Tonies (Upscene Productions)
Hi, In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users But how does one distinguish between roles and users? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL

ANN: Upscene releases Database Workbench 5.3.4

2017-10-27 Thread Martijn Tonies (Upscene Productions)
ed routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Mar

ANN: Stored routine debugger Hopper, version 2.0 released

2017-10-20 Thread Martijn Tonies (Upscene Productions)
Dear ladies and gentlemen, Upscene Productions is proud to announce version 2 of "Hopper", a stored routine debugger for InterBase, Firebird and MySQL. This version includes support for Firebird 3 packages and stored functions, MySQL diagnostic-statements, binary data in variables and much more.

Upscene releases Database Workbench 5.3.2

2017-06-30 Thread Martijn Tonies (Upscene Productions)
debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonie

Upscene releases Database Workbench 5.3

2017-04-19 Thread Martijn Tonies (Upscene Productions)
Firebird 3 Stored Functions and Packges and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Producti

Starting MySQL takes a long long time

2016-10-10 Thread Martijn Tonies (Upscene Productions)
is causing the delay between starting InnoDB and finishing this startup? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Database Workbench 5.2 now includes PostgreSQL support

2016-09-08 Thread Martijn Tonies (Upscene Productions)
different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers tunnell

ANN: Upscene releases Database Workbench 5.1.12

2016-03-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.12 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.12 “ This release adds a few small features and useful enhancements. The full version 5.1.x change log is available here:

Upscene releases Database Workbench 5.1.10

2015-12-16 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5.1.10 This release adds a few small features and includes Windows Terminal Server support. The full version 5.1.x change log is available here:

ANN: 20% discount on Database Workbench Basic or Pro!

2015-11-04 Thread Martijn Tonies (Upscene Productions)
here: http://www.upscene.com/database_workbench/ Thank you. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!

ANN: 20% discount on Database Workbench Basic or Pro!

2015-10-23 Thread Martijn Tonies
pscene.com/database_workbench/ Thank you. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!

Upscene releases Database Workbench 5.1.6

2015-10-09 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.6 " This version is the next big release after version 5 and includes new features, enhancements and fixes. The full version

Upscene releases Database Workbench 5.1.2

2015-07-15 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.2 This version is the next big release after version 5 and includes new features, enhancements and fixes. The change log is available here:

Upscene releases Database Workbench 5.1.0

2015-06-24 Thread Martijn Tonies (Upscene Productions)
For immediate release: http://www.upscene.com/news/item/20150624 Upscene releases Database Workbench 5.1.0 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1 This version is the next big release after version 5 and

Upscene releases Database Workbench 5.0.10

2015-02-20 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 This release fixes several issues as reported by our customers. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.0.10id=12 Version 5 added

ANN: Upscene releases Database Workbench 5.0.8

2015-01-21 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.8 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 This release fixes several issues as reported by our customers. The change log is available here:

ANN: Advanced Data Generator 3.3.0 released

2014-12-17 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20141217 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Database Workbench 5.0.6 released

2014-12-15 Thread Martijn Tonies (Upscene Productions)
and Microsoft SQL Server. With regards, Martijn Tonies

Re: alter table for foreign key

2014-11-17 Thread Martijn Tonies (Upscene Productions)
Hi, This is an example: ALTER TABLE cart ADD CONSTRAINT fk_cart_customers FOREIGN KEY (custid) REFERENCES customers (custid) ON DELETE CASCADE ON UPDATE NO ACTION; (take from the GUI tool Database Workbench, avoids having to know the syntax ;) ) With regards, Martijn Tonies Upscene

Re: alter table for foreign key

2014-11-17 Thread Martijn Tonies (Upscene Productions)
a unique constraint (either a primary of a secondary unique constraint) to point to: when there's no uniqueness in the parent table, it cannot point to a record in that table. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL

ANN: Upscene releases Database Workbench 5.0.4

2014-10-16 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.4 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5 Version 5.0.4 introduces some small new features and a list of fixes base on user feedback. The change log is available here:

ANN: Upscene releases Database Workbench 5.0.2

2014-09-18 Thread Martijn Tonies (Upscene Productions)
release, all minor issues but also a lack of documentation showing in the trial version. I'm proud of the team that thoroughly tested the version 5 release, says Martijn Tonies, founder of Upscene Productions. The major version 5 release adds adds code editor features, has diagramming

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! There is so much new in Database Workbench 5, I don't know where to start, says Martijn Tonies, founder of Upscene

Re: Stored procedure debuggers

2014-08-21 Thread Martijn Tonies (Upscene Productions)
called Hopper, I haven tried it under Wine yet, but there's a good chance it runs fine. Here's my latest (successful) attempt running Database Workbench under Wine, as a complete Linux novice. ;) http://www.upscene.com/support.php?page=dbw_ubuntu_wine With regards, Martijn Tonies Upscene

Re: Cannot Update, at least not how I'm telling it to!

2014-07-09 Thread Martijn Tonies (Upscene Productions)
The AND in your UPDATE clause makes this a logical operator instead of being a SQL keyword. Your syntax is wrong: UPDATE ... SET mycol = value, mycol2 = value [WHERE ... ] With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL

ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

2014-06-17 Thread Martijn Tonies (Upscene Productions)
=newsid=20140617 Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies

ANN: Hopper - Stored Routine debugger - v1.5.1 released

2014-06-16 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains new features and bugfixes, see http://www.upscene.com/go/?go=newsid=20140616 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

Three days left on the 75% FIFA World Cup Discount!

2014-06-09 Thread Martijn Tonies (Upscene Productions)
Dear reader, There’s 3 days left on our FIFA World Cup special: 75% discount on all our database development products! http://www.upscene.com/ With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: 75% special FIFA World Cup 2014 discount on all our products

2014-05-26 Thread Martijn Tonies (Upscene Productions)
Hello everyone, We’re currently offering a 75% discount on all our (Windows based) products! This includes test data generator, development and debugging tools, feel free to take a look at http://www.upscene.com Thank you for your attention. With regards, Martijn Tonies Upscene

ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!

2014-04-29 Thread Martijn Tonies (Upscene Productions)
and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.5.0 released

2014-04-01 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains new features and bugfixes, see http://www.upscene.com/go/?go=newsid=20140401 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Database Workbench 4.4.5, special MySQL discount!

2014-03-19 Thread Martijn Tonies (Upscene Productions)
) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions

ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!

2014-01-27 Thread Martijn Tonies (Upscene Productions)
and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com

ANN: Advanced Data Generator 3.2.0 released

2014-01-07 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20140107 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Advanced Data Generator 3.1.2 released

2013-12-02 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20131202 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.4.1 released

2013-12-02 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes, see http://www.upscene.com/go/?go=newsid=20131202b for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!

2013-11-27 Thread Martijn Tonies (Upscene Productions)
supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database

ANN: Database Workbench 4.4.2, the multi-DBMS IDE now available!

2013-10-24 Thread Martijn Tonies (Upscene Productions)
( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com

ANN: Advanced Data Generator 3.1.1 released

2013-10-14 Thread Martijn Tonies (Upscene Productions)
information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20131014 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.4.0 released

2013-10-09 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes and improvements, see http://www.upscene.com/go/?go=newsid=20131009 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Database Workbench 4.4.1, the multi-DBMS IDE now available!

2013-08-19 Thread Martijn Tonies
( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

ANN: Advanced Data Generator 3.1 released

2013-08-05 Thread Martijn Tonies
information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20130805 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL General Mailing List For list archives

ANN: Database Workbench 4.4.0, free Lite Editions now available!

2013-07-17 Thread Martijn Tonies
, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing

ANN: Hopper - Stored Routine debugger - v1.3.0 released

2013-06-03 Thread Martijn Tonies
INTO ...) RETURNING-clause not working in Firebird version - assigning values to output parameters fails using Trace Into in MySQL - possible errors on using built in function in SQL queries in MySQL With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General

ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!

2013-04-24 Thread Martijn Tonies
Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http

ANN: beta 2 of Advanced Data Generator 3 released

2013-03-19 Thread Martijn Tonies
With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: Hopper - Stored Routine debugger - v1.2.0 released

2013-03-15 Thread Martijn Tonies
, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: Database Workbench 4.3.2, free Lite Editions now available!

2013-02-04 Thread Martijn Tonies
, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing

ANN: Hopper, version 1.1.0 released

2013-01-29 Thread Martijn Tonies
://www.upscene.com/go/?go=hopper This release contains bugfixes and some small new features, see http://www.upscene.com/displaynews.php?item=20130129 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available!

2012-11-12 Thread Martijn Tonies
) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

ANN: Database Workbench 4.3.1, free Lite Editions now available!

2012-09-25 Thread Martijn Tonies
, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing

ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!

2012-08-20 Thread Martijn Tonies
Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list

ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!

2012-08-13 Thread Martijn Tonies
, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com

Re: create roles/groups in MYSQL

2012-08-02 Thread Martijn Tonies
There's nothing built in but if you want explore this it is an extension http://www.securich.com/ That seems like a nice extension. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL

ANN: Hopper (stored procedure debugger), version 1.0.3 released

2012-08-01 Thread Martijn Tonies
error with the MySQL version, amongst other small issues. For more information, see http://www.upscene.com/displaynews.php?item=20120801 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

ANN: Hopper, version 1.0.2 released

2012-07-13 Thread Martijn Tonies
://www.upscene.com/displaynews.php?item=20120713 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released

2012-06-25 Thread Martijn Tonies
that you started out by implying I worshipped Bill Gates, I'll take it you aren't willing to make new friends either. Website has been modified, product announcement as well. Can we close the book on this now? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download

Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released

2012-06-22 Thread Martijn Tonies
the required OS on our website, I do find your juvenile comments about worshipping, changing product names etc just that. I'll adjust the website and announcements. :) Have a nice weekend. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench

ANN: Hopper (stored procedure debugger), version 1.0.1 released

2012-06-20 Thread Martijn Tonies
/displaynews.php?item=20120620 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: Database Workbench 4.2.4, free Lite Editions now available!

2012-06-01 Thread Martijn Tonies
, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer

ANN: Only 2 days left, 70% discount on all products!

2012-05-30 Thread Martijn Tonies
-- With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: ANN: Hopper for MySQL, first public beta available!

2012-05-30 Thread Martijn Tonies
Welcome to Hopper! Claudio Thank you Claudio, we hope it will serve it's purpose and we get lots of feedback on it. 2012/5/25 Martijn Tonies m.ton...@upscene.com Dear ladies and gentlemen, Upscene Productions is happy to announce the launch of a new database-developer tool: Hopper

ANN: Hopper for MySQL, first public beta available!

2012-05-25 Thread Martijn Tonies
=20120525 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: 70% Ten Year Anniversary discount on all our products!

2012-05-14 Thread Martijn Tonies
Upscene Productions is celebrating it's 10 year anniversary with a massive discount on all our products: 70% discount until the end of May. Don't forgot to blog and twitter about this! We produce database development, management and testing tools for: * Oracle * Microsoft SQL Server * MySQL *

ANN: Database Workbench 4.2.4 released, 70% discount!

2012-05-10 Thread Martijn Tonies
.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing

List of global/session variables (@myvar)

2012-04-02 Thread Martijn Tonies
Hi, Is there a way to get the currently available global variables that are defined by, for example, a Stored Procedure that returns stuff as set @myvar = 'result'; when outside the stored procedure? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database

ANN: Very early preview movie of Hopper, Stored Routine Debugger

2012-03-30 Thread Martijn Tonies
Firebird version) http://www.upscene.com/go/?go=hopper Here's a small demo movie so you get an idea of how it works: http://www.upscene.com/products/hopper/demos/hopper_mysql_alpha1.htm Thanks for watching! With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download

Re: Database Workbench 4.2.3, the multi-DBMS IDE now available!

2012-03-26 Thread Martijn Tonies
tie together. Full native SQLite is not planned. You probably can access it as a read only datasource, run queries etc, via ODBC, I haven't tested that. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL

ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!

2012-03-23 Thread Martijn Tonies
, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available!

2012-02-15 Thread Martijn Tonies
- XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench

Stored Procedure Debugging?

2012-02-15 Thread Martijn Tonies
/tools_debugger_basics.htm Would you like to be able to debug stored routines like this? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list

Database Workbench 4.2.0, the multi-DBMS IDE now available!

2011-12-12 Thread Martijn Tonies
InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database

Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-18 Thread Martijn Tonies
list platform requirements, the developer hasn't thought beyond the dominant paradigm. You sure have a point, I'll list it in the future. However, I should note that Database Workbench users have succesfully used it under Wine. With regards, Martijn Tonies Upscene Productions http

ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-16 Thread Martijn Tonies
, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http

ANN: Advanced Data Generator 2.5.2 released

2011-06-16 Thread Martijn Tonies
- InterBase Edition - Firebird Edition - MySQL Edition More info and a 30-day trial version on www.upscene.com Pricing information available on: http://www.upscene.com/purchase.php#adg With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL

Re: Any table visualization tools with wires connecting the actual columns?

2011-04-12 Thread Martijn Tonies
Hi, Also take a look at Database Workbench - www.upscene.com The free Lite Edition doesn't do diagramming, but the Pro does. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase

ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available!

2011-03-30 Thread Martijn Tonies
supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn

ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available!

2011-02-16 Thread Martijn Tonies
support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Which row in which table has been accessed at which time?

2011-01-12 Thread Martijn Tonies
Hi, I could envision a way of doing this when accessing your tables only via Stored Procedures instead of using them directly. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase

ANN: New Year's Sale at Upscene Productions, 25% discount!

2011-01-03 Thread Martijn Tonies
New Year's Sale at Upscene Productions, 25% discount! Dear reader, We wish you the best for 2011. We would like to point you to our New Year's Sale! Go to http://www.upscene.com and use coupon code NY2011 when ordering. With regards, Martijn Tonies Upscene Productions www.upscene.com

ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!

2010-12-24 Thread Martijn Tonies
) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL

Re: Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread Martijn Tonies
I use Database Workbench, but might be biased ;-) www.upscene.com - there's a free Lite edition available. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird

Re: Triggers and FOR EACH ROW

2010-07-13 Thread Martijn Tonies
, or to each UPDATEd row? Each updated row, as per documentation: It can be BEFORE or AFTER to indicate that the trigger activates before or after each row to be modified. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL

ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!

2010-07-13 Thread Martijn Tonies
: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies

ANN: Database Workbench 4.0.2 released - including Free Lite Editions

2010-06-09 Thread Martijn Tonies
) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Re: Mysql Schema design Rollback necessity Question

2010-05-25 Thread Martijn Tonies
the same transaction, things become different. Have you ever read about atomicy on database transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird

Re: test - please ignore

2010-05-19 Thread Martijn Tonies
i said: ignore! But did it work? ;-) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http

ANN: Database Workbench 4.0.1 Pro released

2010-04-29 Thread Martijn Tonies
( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: order by numeric value

2010-04-28 Thread Martijn Tonies
the trick. Jesper Perfectamundo! I thought there would have been a more elegant way but this works just fine. Thanks. There is a more elegant way: do not do your $ at the database, but rather in the presentation layer. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

Re: How to select rows from only the first N rows in a table?

2010-04-27 Thread Martijn Tonies
It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? LIMIT usually works fine ;-) http://dev.mysql.com/doc/refman/5.0/en/select.html With regards, Martijn

  1   2   3   4   5   6   7   8   9   10   >