[lazarus] MySQL components and MySQL 5.1.xx

2006-10-30 Thread Seth Grover
Before I dig in and spend a lot of time trying to figure out what's going on here, I thought I'd save the legwork ask to see if someone else has tried to do this. My question: will the TMySQL50Connection component work with a MySQL 5.1 (I think I'm running the 5.1.11 beta) server? I modified

Re: [lazarus] MySQL components and MySQL 5.1.xx

2006-10-30 Thread Seth Grover
Interesting. You're right: when I take out all of the fancy stuff the demo is trying to do (list the databases, list the tables, list the fields, etc.) it seems I can execute queries just fine. I'll research further into the API on how to do the fancy listing stuff without using the fake

Re: [lazarus] MySQL components and MySQL 5.1.xx

2006-10-30 Thread Burkhard Carstens
Am Montag, 30. Oktober 2006 18:13 schrieb Seth Grover: Interesting. You're right: when I take out all of the fancy stuff the demo is trying to do (list the databases, list the tables, list the fields, etc.) it seems I can execute queries just fine. I'll research further into the API on how to

Re: [lazarus] MySQL components and MySQL 5.1.xx

2006-10-30 Thread Joost van der Sluis
On Mon, 2006-10-30 at 17:49 +0100, Michael Van Canneyt wrote: On Mon, 30 Oct 2006, Seth Grover wrote: Before I dig in and spend a lot of time trying to figure out what's going on here, I thought I'd save the legwork ask to see if someone else has tried to do this. My question: will

Re: [lazarus] MySQL Components

2006-10-19 Thread Joost van der Sluis
On Thu, 2006-10-19 at 00:02 +0200, Michael Van Canneyt wrote: On Wed, 18 Oct 2006, Terry A Haimann wrote: My real question is how do you execute in the sql in these fields? Is there some sort of hook, like maybe from the dbnavigator? They are used automatically when you execute the

[lazarus] MySQL Components

2006-10-18 Thread Terry A Haimann
I noticed that now on the mysql connection component there is a DeleteSQL, UpdateSQL and InsertSQL varibles of TStrings. How do I use them? I am running Lazarus 0.0.18 beta on a FC4 machine. Thx, Terry -- Terry A Haimann [EMAIL PROTECTED]

Re: [lazarus] MySQL Components

2006-10-18 Thread Michael Van Canneyt
On Wed, 18 Oct 2006, Terry A Haimann wrote: I noticed that now on the mysql connection component there is a DeleteSQL, UpdateSQL and InsertSQL varibles of TStrings. How do I use them? I am running Lazarus 0.0.18 beta on a FC4 machine. Just enter something like Update MyTable Set

Re: [lazarus] MySQL Components

2006-10-18 Thread Terry A Haimann
My real question is how do you execute in the sql in these fields? Is there some sort of hook, like maybe from the dbnavigator? On Wed, 2006-10-18 at 21:31 +0200, Michael Van Canneyt wrote: On Wed, 18 Oct 2006, Terry A Haimann wrote: I noticed that now on the mysql connection component

Re: [lazarus] MySQL Components

2006-10-18 Thread Michael Van Canneyt
On Wed, 18 Oct 2006, Terry A Haimann wrote: My real question is how do you execute in the sql in these fields? Is there some sort of hook, like maybe from the dbnavigator? They are used automatically when you execute the dataset's Delete and Post methods ? So something like