Hi Chris,
My apologies, I didn't correctly explain what I was looking for. I mean
more of a solution to creating a client program. I'm thinking of php-gtk
but not sure how well this works under windows, especially for printing
reports.
Thanks,
Bryan
On Sat, 17 Jan 2004, Chris Nolan
I wanted to thank everyone for their responses and information regarding
this. I apologize, I thought I had already replied.
Anyhow, I proved my point to our software guy, enough that he is willing
to look into it further. Although I have a feeling he isn't going to want
to do it (but at least he
Hmm...have you looked at Rekall?
www.total-rekall.co.uk
Also, you might want to check out OpenOffice.org's database interface
features
Regards,
Chris
On Sat, 2004-01-17 at 11:12, Bryan Koschmann - GKT wrote:
I wanted to thank everyone for their responses and information regarding
this. I
Direct your developer to www.vbmysql.com. This site is dedicated to supporting
developers who want to use MySQL with VB. We will be happy to help him with anything
he runs into while writing your system for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
DK It depends why step 3 failed.
DK If you want to rollback the transaction to the beginning on any error,
DK you
correction:
D Data integrity logic should be ensured by client application
should be read as:
Data integrity logic should be defined by client application
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Quoting DeBug [EMAIL PROTECTED]:
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
DK It depends why step 3 failed.
DK If you want to rollback the transaction
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston
Subject: Re: Can MySQL table handle 3 million+ entries?
Newsgroups: comp.lang.php
Date: 2003-04-11 15:20:10 PST
MySQL is NOT a toy database - it is far superior to many I have used in my
long
At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote:
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS SQL). It is all
windows based software (written in VB).
So far his arguments against it are this (not my words):
-No
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS SQL). It is all
windows based software (written in VB).
So far his arguments against it are this (not my words):
-No explicit transactional support
-MySQL is still
transactional support
InnoDB tables have transaction support.
-MySQL is still buggy
No it's not. That's a bit of a nebulous claim.
-MyODBC is buggy and not used in production environments
Not for us. We've been using it in a production environment for 4 years
with no issues.
-Only way to connect
Bryan,
Although this doesn't answer your initial request...why are you wanting to
'argue' with this guy over the database to use. If he won't code for the
application to use MySQL (which isn't all that hard in VB regardless of what
he says) then get another coder...as simple as that.
On Jan 5, 2004, at 9:37 PM, Bryan Koschmann - GKT wrote:
-No explicit transactional support
Wrong. InnoDB tables support transactions.
-MySQL is still buggy
Care to have him specify what bugs he is referring to? I've been using
MySQL for 2 years now, and use Microsoft SQL Server for about 3
comfortable with M$ products and just
doesn't see the need to look at MySQL.
Here is the explanation I just received when asking for the difference
between transaction support:
-
MySQL uses single-action implicit and explicit transactions, but they do
not
automatically roll back on failure.
SQL
%40posting.google.comrnum=1
Yours sincerely
Morten Gulbrandsen
- Original Message -
From: Bryan Koschmann - GKT [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, January 06, 2004 3:37 AM
Subject: transaction support
Hi,
I'm trying to get a software designer to write us
Bryan Koschmann - GKT [EMAIL PROTECTED] [2004:01:05:18:58:12-0800] scribed:
snip /
Here is the explanation I just received when asking for the difference
between transaction support:
-
MySQL uses single-action implicit and explicit transactions, but they do
not
automatically roll
Bryan Koschmann - GKT wrote:
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
if this failed at step 3 the transaction would be hung and even if rolled
back by server
Peter
Copenhagen denmark
- Original Message -
From: Bryan Koschmann - GKT [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, January 06, 2004 3:37 AM
Subject: transaction support
Hi,
I'm trying to get a software designer to write us some software using
MySQL
Hi
We have been running MySql since 1998 and have never had any data corruption
We have servers running millions of queries a day and they are bullet proof.
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS
i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this
oledb provider does not support transaction.
is there any oledb provider that does support transaction?
thanks
Hi,
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
Did you know MySQL has documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.
# [EMAIL PROTECTED] / 2003-06-24 12:29:33 +0200:
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
Did you know MySQL has documentation?
# [EMAIL PROTECTED] / 2003-06-24
Palaparthy [EMAIL PROTECTED] wrote:
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
Yes.
http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote:
Dear Friends,
The last help I got was truly worth a zillion.
Such a bargin!
1. How can i have commit/rollback functions using
MyIsam database which is default database engine for
MySql? i am using vb
You cannot. MyISAM
]
Sent: Wednesday, March 26, 2003 11:48 PM
To: Nitin Nanivadekar
Cc: [EMAIL PROTECTED]
Subject: Re: Transaction Support with MyISAM
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote:
Dear Friends,
The last help I got was truly worth a zillion.
Such a bargin!
1. How can i have
Hello,
I experiencing a problem I hope someone here can help with:
I have several C-coded clients running and performing inserts and
updates on a database. I would like to make sure that the -entire-
client session is atomic. i.e. if a client dies in the middle of the
computation (not
Dear Friends,
The last help I got was truly worth a zillion.
1. How can i have commit/rollback functions using
MyIsam database which is default database engine for
MySql? i am using vb
2. is there any intelligent program (not ODBC/JDBC
drivers anyway) available that can be run on a server
provide
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but cannot
use rollback on it.
the error i get in my jsp is transactions not
supported.
please advice me on how i
Correct me if I am wrong, but I believe mysql 3.23.54 does not support
transaction support, version 3.23.54 has row locking only. Transaction
feature starts with version 4.0.x.
Bob
- Original Message -
From: Nirmal Shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote:
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Tam wrote:
Correct me if I am wrong, but I believe mysql 3.23.54 does not support
transaction support, version 3.23.54 has row locking only. Transaction
feature starts with version 4.0.x.
Bob
You're corrected :)
3.23.54 supports InnoDB
PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 9:44 AM
Subject: Re: Transaction Support in mysql13.23.54
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote:
hi,
i have installed mysql3.23.54 on windows and have
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but cannot
use rollback on it.
the error i get in my jsp is transactions not
supported.
please advice me on how i
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but cannot
use rollback on it.
the error i get in my jsp is transactions not
supported.
please advice me on how i
Hello All,
I would like to know the some details regarding the transaction
support in Mysql Version 4. May i know where can i find the related
stuffs.
Thanx in advance
--
You feel a whole lot more like you do now than you did when you used to.
Regards,
Charitha
Hello All,
I would like to know the some details regarding the transaction
support in Mysql Version 4. May i know where can i find the related
stuffs.
Transactions are supported in the current 3.23.53 release of MySQL-Max and
MySQL 4 (Pro version I think) with the InnoDB table type
Has anyone tried to incorporate the Transaction
Support of InnoDB Databases in MySQL to the
setcomplete and setabort commands of Microsoft
Transaction Server? Is it possible to do this? Thank
you for your support.
=
Regor Vincent M. Nono
Junior Programmer
Content Sciences, Inc.
SPI Bldg
I have a managed dedicated server that was recently upgraded to MySQL
version
3.23.51 in order to take advantage of transaction processing. However, when
my script tries to turn off auto-commit, I receive this message...
Transactions not supported by database. Are there any configuration
settings
Hi,
I am using MySQL 3.23.40 on LINUX Redhat 7.1 version.
My application is an OLTP application and depends
heavily on transactions. Since MySQL doesn't support
transactions for the stable releases, is there any
work around to solve this problem.
Could any one help how to cope up without
Hi Arawind,
Could any one help how to cope up without transactons
in mysql. The Help manual provided with the software
doesn't help a great deal.
Oneway is to incorporte transaction processing functionalities in the
middle layer application. eg. before commiting persistent objects used for
/InnoDB_restrictions.html
Any suggestions with which type to go with? What have been the experience
with either/both? How does the future look for both?
Both maintain log files to do rollbacks. Is this how PGSQL does this too?
How do these tables compare to dbs with native transaction support (like
Oracle, MSSQL
more granular locks.
Both maintain log files to do rollbacks. Is this how PGSQL does this
too?
InnoDB uses a mult-versioning scheme, which is what PostreSQL does.
So in that respect they're quite similar.
How do these tables compare to dbs with native transaction support
(like Oracle, MSSQL
What you are trying to perform is doable with InnoDB table handler.
Unlike BDB, InnoDB has multi-versioning and consistent reads.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime
1. Please explain the above in detail.
It depends on the type of table you're using. If you're using a table type
that only supports table-level locking, then each transaction is isolated by
being suspended until the previous transaction is done. This is slower
if you do a lot of longer
Hi.
I downloaded mysql 3.23.40 from www.mysql.com.
This site announces that this mysql version supports transaction which was
not supported in older mysql.
I was so happy to find that. So I tested that support. The case was
following.
I launched two mysql - one in A terminal window and other in
What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
On Fri, 22 Jun 2001 15:17:18 -0700, Alberni-dot-Net Tech Mailing Lists
[EMAIL PROTECTED] wrote:
What sort of support for transactions and table/record locking is there in MySQL
right now? I had heard that only table locking was supported, and limited support
for transactions.
we've had
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The Ohana Foundation
1099 Alakea st
22nd floor
Honolulu, HI, 96813
1-877-61-ohana
[EMAIL PROTECTED]
-
Before posting, please check:
Matthew Hafner wrote:
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The Ohana Foundation
1099 Alakea st
22nd floor
Honolulu, HI, 96813
1-877-61-ohana
[EMAIL PROTECTED]
RTFM
www.mysql.com
MySQL supports transactions in beta form if you use a Berkley table. Check
the homepage for more information.
Triggers are in the todo pile though.
At 09:44 AM 4/24/2001 -1000, Matthew Hafner wrote:
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth [EMAIL PROTECTED] wrote:
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear ;) *grin*
P
On Tue, 24 Apr 2001, Steve Ruby
wrote:
Now gentlemen please let's use appropriate language when posting to the
list, after all it is a public list and we don't want to offend anybody
At 22:04 24/04/2001 +0100, Peter Skipworth wrote:
Like duh! =)
On Tue, 24 Apr 2001, Rene Tegel wrote:
RTFM=Read The Fucking Manual
now you
Like duh! =)
On Tue, 24 Apr 2001, Rene Tegel wrote:
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth [EMAIL PROTECTED] wrote:
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear
Hi,
Does anyone know if the DBD Transaction Safe Table support has been
implemented (and working) for the NT release of 3.23.33 ?
I have created tables with type=BDB but fail to have any joy with
transactions
Cheers,
Bruce Percy
Peopledoc Ltd.
I'm wondering if MySQL supports transaction?
Since I have an application to use MySQL JDBC to perform several insert
statements and then do a rollback, all data saved to the database without
rolling back.
-Eric
-
Before
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB
-tcl.
On Tue, 13 Feb 2001, Eric Kwong wrote:
I'm wondering if MySQL supports transaction?
Since I have an
57 matches
Mail list logo