Trying to control OKI Microline 590 24-pin printer

Kay C Lan lan.kc.macmail at gmail.com
Tue May 29 21:47:09 EDT 2007


On 5/29/07, Stephen Barncard <stephenREVOLUTION at barncard.com> wrote:
>
>
> For accessing and uploading data there's CocoaMySQL for the Mac. Many
> others for PC. new beta


http://cocoamysql.sourceforge.net/beta/CocoaMySQL_0.7b5.zip


I've been using CocoaMySQL-SBG 0.7.1 and love it. Don't know what the SBG is
about so downloaded the above to see which is the latest and discovered a
HUGE BUG in 0.7b5.

0.7b5 is 'more up to date' than SBG 0.7.1, it's got more colour, has extra
features and the data presentation is way more efficient; BUT if you have
any VARCHAR columns (haven't tested anything else) larger than 100 char you
risk having your data truncated to 100 char and the data in other columns
mangled!

You may need to download CocoaMySQL-SBG 0.7.1 or some other data viewing app
to test this:

http://www.theonline.org/cocoamysql/

To test, COPY an existing DB that has VARCHAR >100 column. DO NOT USE A
WORKING DB!!!!!!!!!!

I'm going to assume the VARCHAR column is called "remarks"

1) In 0.7b5 view the 'remarks' column. To start with you'll note that the
initial data is displayed with a ellipsis [three dots which is a single
char] at the end. Widen the column as much as possible. The data will now be
displayed with (...) [not an ellipsis but three periods enclosed in
brackets] at the end, even though there might be space at the right side of
the column to display more text. ie char 101 to 105 is (...)

2) Add a new row. Type in data where necessary, and in the remarks column
make sure you exceed 105 char. Tab out of the column and it will be
truncated with (...). If you have to add data to other columns in your DB,
do so, BUT DO NOT GO BACK to the 'remarks' column. Once you've entered all
the data click in another row so that you know the row has been written and
there are no errors.

3) Quit 0.7b5 and Open SBG 0.7.1. Go to the last row in your DB and widen
the remarks column and you'll see all the data is displayed correctly and
can be edited if necessary. Quit SBG 0.7.1

4) Open 0.7b5 and go to your DB and the last row. Tab through the field to
the 'remarks' column as if you wanted to edit it. Note that your data ends
with (...), and hasn't been replace with the full data. Click another row so
that you haven't changed any data in the last row.

5) Quit 0.7b5 and Open SBG 0.7.1. Go to the last row in your DB and you'll
see that the remarks column now ends with (...). Your data is GONE!

ALSO, check other columns, in my case columns 2 thru 5, which in my case are
decimal columns of various sizes, were overwritten with 99.9 thru
99999.9depending on the max size of the column.

I'd steer way clear of 0.7b5.

I'm using this on:
MacBook Pro Intel CD 2GHz 1GB RAM
OSX 10.4.9
MySQL 5.0.27
No problems with CocoaMySQL-SBG 0.7.1



More information about the use-livecode mailing list