Re: M$ Acesss Front & MySql-Backend field datatype issues using Myodbc

2002-07-24 Thread Pierre du Parte
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 d

Re: Delphi MySQL Access Components

2002-07-24 Thread Pierre du Parte
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

Re: Unable to add/ edit records - Help needed!

2002-06-22 Thread Pierre du Parte
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

Unable to add/ edit records - Help needed!

2002-06-22 Thread Pierre du Parte
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 a

Re: HELP - Insight into dates, please

2002-05-19 Thread Pierre du Parte
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 exa

HELP - Insight into dates, please

2002-05-19 Thread Pierre du Parte
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 da

GUI for mySQL

2002-04-20 Thread Pierre du Parte
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

Re: Problem with query

2002-04-17 Thread Pierre du Parte
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

Re: new windows Tool

2002-04-15 Thread Pierre du Parte
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 w

Re: Free Quote

2002-04-09 Thread Pierre du Parte
; 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:01C1D

: myODBC and WinXP/ Access 2000

2002-03-31 Thread Pierre du Parte
[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 -

Re: New to MySQL - can't start server :-(

2002-03-17 Thread Pierre du Parte
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 Wi

Delphi, ADO and SQL

2002-02-24 Thread Pierre du Parte
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 n

Re: migrate Microsoft Access Data into MySQL

2002-02-24 Thread Pierre du Parte
I've had good success with ' 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 theref