Cool!


-----Original Message-----
From: Electronic Medical Record - Enid [mailto:[log in to unmask]]
On Behalf Of Osburn, Gene (HSC)
Sent: Thursday, March 04, 2004 2:56 PM
To: [log in to unmask]
Subject: Re: MySQL

Jim,
 
I have finally solved what I think is the last barrier to using MySQL as
the database for the program. You have to specify client side cursors
for the ODBC driver that MySQL uses. Like the old Access and some old
DOA drivers. Data returned from SQL queries were pretty flakey and
confusing before I stumbled on this solution.
 
I will do some more testing the next couple days, but I think you can
now run the program with MySQL in instead of M$SQL if you prefer.
Trapping the backslash escape characters and formating stored dates in
the YYYY-MM-DD HH:MM:SS format was the easy part.
 
I have also found some programs which claim they can convert VB 6 code
to pure Java code. I will check those out soon.
 
Gene