Re: Delphi MySQL Access Components
Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: M$ Acesss Front MySql-Backend field datatype issues using Myodbc
I may be a little OT, but the current myODBC driver does work quite well with Access. So you can use Access to write your queries and app etc and have mySQL as your backend. I've mainly used Access and myODBC to port manipulate Access data to mySQL. For writing mySQL frontends my preferred development tool is Delphi. Hope this helps Pierre http://www.finalfiler.com chuck amadi wrote: Hi again . I have a project whereby the client has a legacy M$ Access ( as far as im concerned ) and i'm to design.build and construct a MySql v4 Back-end and more than likely pursue a front-end with MS Access due to easability and conversant of it's user's nevertheless are there any field datatype issues and if so is there a site or FAQ that suggests prior to development the tried and tested field datatype that will run smoothly between both front back end . If it is clumbberson i more than likely use MySql-Front. Plz can someone confirm that MySql Front has similiar look feel in relation to Forms , buttons and alike. Plz post any good links regarding field datatypes or Sample Projects built with MySql v4 Front. -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to add/ edit records - Help needed!
Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to add/ edit records - Help needed!
Nevermind- I just re-installed mySQL and rebooted. everything works again. Pierre Pierre du Parte wrote: Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP - Insight into dates, please
Excuse this old ACCESS/ CLARION hack for asking such a basic question,
but the mySQL docs have given me a head-ache :-)
I want to move an ACCESS database to mySQL. I am writing the Code in Delphi.
My problem is assigning the date values in the SQL INSERT INTO string.
In the system I'm using dates are returned as REAL numbers and generally
I would format it to suit the occasion, ie
formatdatetime('-mm-dd',myDate.value).
So, in mySQL
sql := 'INSERT INTO myTable SET myDate = ' + formatdatetime(datemask
,myDate.value);
Looking at the mySQL docs AFAI can work out datemask should be
-mm-dd but this doesn't work.
what is the expected 'datemask'? Or have I got wrong?
More importantly are there functions in mySQL I can call to convert a
standard date, ie mmdd to the expected mySQL value?
Any help to get me over this confusing hump is appreciated.
--
Pierre du Parté
Final Filer Software
349 Worrigee Road
Worrigee, NSW, Australia 2540
http://www.finalfiler.com
Phone 61 2 44216374
Mobile 0413 483 066
If it feels good, do it!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP - Insight into dates, please
Many thanks for the, Richard... You wrote: I'm not so sure what you are asking here but from this statement, More importantly are there functions in mySQL I can call to convert a standard date, ie mmdd to the expected mySQL value?. Yeah, I was a bit vague :-) But your example provided the clue- I had neglected the string delimiters :-( I had coded SET myDate = mmdd I should have coded SET mydate = 'mmdd' which worked. Again, many thanks Pierre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GUI for mySQL
I am gradually winning the war in promoting opensource to a number of my key customers. Notably a couple have made the move to OpenOffice.org, albeit on Windows. I am currently re-writing a key application to use mySQl (previously Access), so in all I'm pleased. However, the head bean counter in one office tackled me on this - In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql? Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia 2540 http://www.finalfiler.com If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with query
Depends on how the fee paymnents are defined. At its simplest: SELECT Members..Name FROM Members WHERE NOT(Members.MemberID = FEE_PAYMENTS.MenmbersID) would select members that have no fee payment records. You could build on it from there... For the mySQL gurus, sorry about the syntax guys, I've been with Access to long but I'm coming over quickly :-) Pierre Torkil Johnsen wrote: I am having a small problem with a small mysql query... I want to make a list of: WHO HAS NOT PAID THEIR MEMBERSHIP FEE. I guess I could maybe solve this one myself, its not too hard ... I have one table with members MEMBERS -- | MemberID | Name | etc. One table with fee payments FEE_PAYMENTS -- | MemberID | date | price | etc... Now: How would I make a query that would list all members that have not paid their fee? How would I make a query that would list all members that have paid their fee? I'm just too tired to think it out myself :) Forgive me :) - Med vennlig hilsen, Torkil Johnsen [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: new windows Tool
I have no objection to you promoting your wares in this group of to your entrepreneurial skills. But to get the message This trial has expired on the first run after installing the 9 meg plus download is a bit rough, isn't it? And definitely not the way to win customers! Pierre amr salah wrote: Hello MYsql lovers; I wanna announce a new tool for windows users . Same interface as SQL server 2000 query analyzer but loaded with Visual Studio capabilities . SQL server users will love it . http://amr.activechannel.net http://amr.activechannel.net/setup.zip _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Free Quote
the program argument list and exit --no-defaults Don't read default options from any options file --defaults-file=# Only read default options from the given file # --defaults-extra-file=# Read this file after the global files are read -Original Message- From: Peter Romianowski [mailto:[EMAIL PROTECTED]] Sent: 09 April 2002 12:08 To: [EMAIL PROTECTED] Subject: check, analyze and optimize table Hi, I am writing a maintenance-deamon which is executing CHECK TABLE, ANALYZE TABLE and OPTIMIZE TABLE once at night. If CHECK TABLE fails for at least one table, then the rest will be skipped. The question is if the order of the statements is ok this way. A second question would be, if I should run a REPAIR statement automatically if CHECK fails. Are there any more tasks that I should perform nightly in order to keep my database healthy and in a high performance shape? And another general question: Do I have to take down my Application that is using the MySQL-DB in order to perform the CHECK, ANALYZE and OPTIMZE commands? thanks in advance, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php From - Tue Apr 09 21:29:33 2002 X-UIDL: 1018351804.001 X-Mozilla-Status: X-Mozilla-Status2: Return-Path: [EMAIL PROTECTED] Received: from hotmail.com ([216.33.237.84]) by ; Tue, 09 Apr 2002 06:28:33 -0500 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 9 Apr 2002 04:28:32 -0700 Received: from 65.32.124.113 by lw7fd.law7.hotmail.msn.com with HTTP; Tue, 09 Apr 2002 11:28:32 GMT X-Originating-IP: [65.32.124.113] From: J Williamson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Bcc: Subject: Re: Free Quote Date: Tue, 09 Apr 2002 07:28:32 -0400 Mime-Version: 1.0 Content-Type: text/html Message-ID: [EMAIL PROTECTED] X-OriginalArrivalTime: 09 Apr 2002 11:28:32.0473 (UTC) FILETIME=[AE071C90:01C1DFB9] X-Rcpt-To: [EMAIL PROTECTED] X-DPOP: DPOP Version 2.4a X-UIDL: 1018351804.001 Status: U htmldiv style='background-color:'DIV PMy apologies, I thought I hit reply, not reply all../P Pnbsp; Thanks for the reply though, I'll be more careful next time, just tired of wading through 20 junk mails to find 1 that I actually wanted./P Pnbsp;/P Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; JBRBR/P/DIV DIV/DIVBRBRBR DIV/DIV DIV/DIVJim DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Pierre du Parte [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: J Williamson [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Free Quote DIV/DIVgt;Date: Mon, 08 Apr 2002 11:40:15 +1000 DIV/DIVgt;MIME-Version: 1.0 DIV/DIVgt;Received: from [209.15.2.37] by hotmail.com (3.2) with ESMTP id MHotMailBE7A402C00064136E822D10F022512E20; Sun, 07 Apr 2002 18:41:01 -0700 DIV/DIVgt;Received: (qmail 24322 invoked from network); 8 Apr 2002 01:41:01 - DIV/DIVgt;Received: from mercury.hosting4u.net (HELO finalfiler.com) (209.15.2.5) by mail-gate.hosting4u.net with SMTP; 8 Apr 2002 01:41:01 - DIV/DIVgt;Received: from finalfiler.com ([210.10.218.102]) by finalfiler.com ; Sun, 07 Apr 2002 20:40:57 -0500 DIV/DIVgt;From [EMAIL PROTECTED] Sun, 07 Apr 2002 18:42:33 -0700 DIV/DIVgt;Message-ID: lt;[EMAIL PROTECTED]gt; DIV/DIVgt;Organization: Final Filer Software DIV/DIVgt;User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:0.9.4) Gecko/20011019 Netscape6/6.2 DIV/DIVgt;X-Accept-Language: en-au, en-us DIV/DIVgt;References: [EMAIL PROTECTED] DIV/DIVgt;X-Rcpt-To: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;G'day Jim, DIV/DIVgt; DIV/DIVgt;Know how you feel. But I reckon instead of Dave's mailbox it went DIV/DIVgt;to DIV/DIVgt;everyone elses, including mine. DIV/DIVgt; DIV/DIVgt;SOmething's gotta be done about these bastards! DIV/DIVgt; DIV/DIVgt;All the best DIV/DIVgt; DIV/DIVgt;Pierre du Parté DIV/DIVgt;Final Filer Software DIV/DIVgt;349 Worrigee Road DIV/DIVgt;Worrigee, NSW, Australia 2540 DIV/DIVgt;http://www.finalfiler.com DIV/DIVgt; DIV/DIVgt;Phone 61 2 44216374 DIV/DIVgt;Mobile 0413 483 066 DIV/DIVgt; DIV/DIVgt;If it feels good, do it! DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;J Williamson wrote: DIV/DIVgt; DIV/DIVgt;gt;Hey Dave! You no good spamming, ignorant jackass. DIV/DIVgt;gt; DIV/DIVgt;gt;Take your BS tips and shove them up your stupid ass, I am sick of DIV/DIVgt;gt;the DIV/DIVgt;gt;spam, and I hope everyone else replies to you as well just so DIV/DIVgt;gt;you're DIV/DIVgt;gt;email box blows up :) DIV/DIVgt;gt; DIV/DIVgt;gt
: myODBC and WinXP/ Access 2000
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query I am flabbergasted! I think the list needs a better spamfilter - below is my message... I had myODBC working reasonably well with mySQL under Win2K. However, under XP I now get a weird unknown error What's the experience? Should myODBC work with WinXP? -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to MySQL - can't start server :-(
Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: migrate Microsoft Access Data into MySQL
I've had good success with QUOTE ' exportSQL version 2.0 ' www.cynergi.net/prod/exportsql/ ' ' (C) 1997-98 CYNERGI - www.cynergi.net, [EMAIL PROTECTED] ' (C) Pedro Freire - [EMAIL PROTECTED] (do not add to mailing lists without permission) ' ' This code is provided free for anyone's use and is therefore without guarantee or support. ' This does NOT mean CYNERGI delegates its copyright to anyone using it! You may change the ' code in any way, as long as this notice remains on the code and CYNERGI is notified (if you ' publish the changes: if your changes/corrections prove valuable and are added to the code, ' you will be listed in a credit list on this file). END QUOTE ExportSQL writes a 'sql dump' file for the recreation of the database. ALso have a look at mysql.com's download section. There's a range of utilities there that will help, although I found all lacking one thing or another. ExportSQL is probably the pick of them. myODBC works, but AFAIK you'd need to create the tables and structures first. I am currently working on an application in Delphi that will use ADO and pump structure and data to mySQL using a 'wizard' interface. It'll be offered in the spirit of mySQL, ie free. I'm nearly done, but need to work out how to handle Access' dbOLE fields. Pierre Admin wrote: How to migrate Microsoft .mdb Database into MySQL under Unix environment?? Who can tell me?? Any Doc?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia http://www.finalfiler.com 61 2 44220442 61 413483066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delphi, ADO and SQL
Don't know if this is the right forum, but you can always flame me if I'm wrong :-) I tried using the mySQL OLEdb (ADO) driver with Delphi. ALthough I can get a data connection and see the table names, the field lists don't appear. Calling a valid field name in a SQL clause causes a 'field not found error' Anyone have any knowledge about this that may help me solve the problem (yeah, I know don't use ADO) :-) TIA -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia http://www.finalfiler.com 61 2 44220442 61 413483066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
