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 wrot
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 a
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
the Real Basic
language. I'm pretty sure you can get a demo version to evaluate whether or
not it supports all the functionality you want. I don't personally have any
experience creating solutions that require transaction support, but I
believe it supports at least the basic elements of t
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
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=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 ca
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 r
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 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 to the beginning on any error,
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 u
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 requ
st regards
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
>
>
>
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 ad
Bryan Koschmann - GKT <[EMAIL PROTECTED]> [2004:01:05:18:58:12-0800] scribed:
> 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
r=&ie=UTF-8&oe=UTF-8&selm=60ca69db.0308210016.822e230%40posting.google.com&rnum=1
Yours sincerely
Morten Gulbrandsen
- Original Message -
From: "Bryan Koschmann - GKT" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06,
open to MySQL to a point.
The problem is he is perfectly 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 tra
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 ye
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. The
licit 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.
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 bug
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
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=ens
# [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
# [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.s
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]
[mailto:[EMAIL PROTECTED]
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.
S
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. MyIS
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
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 uncommon)
>
To: "Nirmal Shah" <[EMAIL 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 Sha
-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 I
-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 us
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]&
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
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
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
> 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
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
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
setting
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 f
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 transacto
faster and scales
better than BDB, and it uses 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 comp
c/I/n/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 (lik
> 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 trans
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
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 B
"Alberni-dot-Net Tech Mailing Lists" <[EMAIL PROTECTED]> writes:
> 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.
It varies, depending on table type - look a
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
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:
h
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 lo
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
lol.
since i'm not native english, what does 'duh' mean ?
:)
rene
On Tue, 24 Apr 2001 22:04:37 +0100 (BST)
Peter Skipworth <[EMAIL PROTECTED]> wrote:
> Like duh! =)
>
> On Tue, 24 Apr 2001, Rene Tegel wrote:
>
> > RTFM=Read The Fucking Manual
> >
> > now you know.
> >
> >
> > On Tue, 24 A
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
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:
> Matthew Hafner wrote:
> >
> > does mySql support triggers or transactions
> >
> > Matthew Hafner
> > Web Applications Engineer
> > The Oha
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
>Th
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
-
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:
http://
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.
-
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 appli
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 posting
61 matches
Mail list logo
