i did some research a while back (not a huge amount of research) but i found out that at the time, neither MySQL or PostgreSQL supported multiple table updates...IE:
update tableA,tableB set TableA.id=tableB.id where TableA.Date >= '05/15/1981' but R:Base did. I dont know if thats the case anymore, but it was about 6 months ago. There might be other things which are supported in one but not the other but ::shrug:: i dont really know :P ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 4:28 PM Subject: RE: Witango-Talk: MySQL on Mac and Dev Studio 5.0 on windows > Supposedly stored procedures are coming in V.5. I've been reading alot about > firebird, an opensource database engine descended from Interbase. It does most > everything, inlcuding triggers, stored procedures, and transactions. No > experience with it, though. > > John > > Does MySQL support stored procedures yet? > > > > Ben Johansen - http://www.pcforge.com > > Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm > > Authorized MDaemon Mail Server Reseller > > http://www.pcforge.com/AltN.htm > > > > > > -----Original Message----- > > From: Steve Smith [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 30, 2003 1:15 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: RE: Witango-Talk: MySQL on Mac and Dev Studio 5.0 on windows > > > > If you go to the www.mysql.com site, I believe what you are looking for > > is > > MyODBC or Connector/ODBC which is what it now appears to be called. I've > > been running MySQL on Windoze for over a year. I've added MySQL on my OS > > X > > box in the past month. After playing with GRANT and permissions, I've > > been > > able to get Dev Studios and App Servers to talk to MySQL on the other > > boxes. > > > > Hope this helps, > > > > Steve Smith > > > > Oakbridge Information Solutions > > Office: (519) 624-4388 > > GTA: (416) 606-3885 > > Fax: (519) 624-3353 > > Cell: (416) 606-3885 > > > Email: [EMAIL PROTECTED] > > Web: http://www.oakbridge.ca > > > > > > > -----Original Message----- > > > From: Dan Stein [mailto:[EMAIL PROTECTED] > > > Sent: May 30, 2003 1:49 PM > > > To: [EMAIL PROTECTED] > > > Subject: Witango-Talk: MySQL on Mac and Dev Studio 5.0 on windows > > > > > > > > > OK this one will have some content. Sorry. > > > > > > I am setting up MySQL on Mac which has gone well and was really easy > > with > > > the tools Jason suggested. I'm all set up and connected to the > > database > > > which I can see and edit with either of the Mac GUI tools I'm testing. > > > > > > I want to use my Windows 5.0 editor for this project so I need to > > > set up an > > > ODBC connection to the Databases running on the Mac. > > > > > > Is there a ODBC driver I need to download for MySQL on Windows 2000 > > and > > > Windows XP so I can create the connection? > > > > > > If so does someone have the link? > > > > > > -- > > > Dan Stein > > > Digital Software Solutions > > > 799 Evergreen Circle > > > Telford PA 18969 > > > Land: 215-799-0192 > > > Mobile: 610-256-2843 > > > Fax 413-410-9682 > > > > FMP, WiTango, EDI,SQL 2000 > > > [EMAIL PROTECTED] > > > www.dss-db.com > > > > > > > > > > > ________________________________________________________________________ > > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
