Thank you, Quentin,
Hey, does anyone know where the problem lies here? Where in Windows ME /
2000? Why does Access still import OK? Is there something that needs to be
done with MyODBC to handle BIGINT types in the future?
Thank you,
Laszlo
----- Original Message -----
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "'Laszlo G. Szijarto'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:30 PM
Subject: RE: Windows ME / 2000 VB problem with BIGINT data type
> Hi,
>
> Don't you love M$.
>
> ALTER TABLE CHANGE COLUMN myname myname INTEGER;
>
> Regards
>
> Quentin
>
>
> -----Original Message-----
> From: Laszlo G. Szijarto [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 18 January 2001 08:28
> To: Laszlo G. Szijarto; [EMAIL PROTECTED]
> Subject: Re: Windows ME / 2000 VB problem with BIGINT data type
>
>
> I isolated the problem because if I do a
> "select * from table" -- I get the error.
> but if I do "select field1, field3, field4 from table", where I leave out
> the BIGINT column, I'm fine.
> and when I do a "select field2 form table" where field2 is the BIGINT
> column, I get the same error
> finally, I created a new table, with the definitions being all the same
> except that I replaced BIGINT columns with INT columns -- and everything
> worked properly. Is there and ALTER table statement in SQL that will
change
> data type definitions -- ps, all my data will currently fit into the INT
> size type. I think I was a bit ambition in first defining the tables.
> Thank you,
> Laszlo Szijarto
>
> ----- Original Message -----
> From: "Laszlo G. Szijarto" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 17, 2001 2:22 PM
> Subject: Windows ME / 2000 VB problem with BIGINT data type
>
>
> I wrote to the list earlier on the above problem. I had a VB app that
> accessed a mysql (on Linux) table through MyODBC. Apparently the problem
is
> that the new ODBC connection providers in Windows ME / 2000 do not like
the
> BIGINT datatype. Yet, strangely, MS Access 97 can import the data from
said
> table just fine (in Windows ME and 2000). And the VB app worked just fine
> on Windows 98. Can someone offer insight into this problem? What could
be
> going on here? Also, if possible, does someone know the SQL syntax for
> changing the datatype of an existing column from BIGINT to INT. Thank you
> very much,
> Laszlo Szijarto
>
>
>
> ----- Original Message -----
> From: "Laszlo G. Szijarto" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 17, 2001 2:22 PM
> Subject: Windows ME / 2000 VB problem with BIGINT data type
>
>
> I wrote to the list earlier on the above problem. I had a VB app that
> accessed a mysql (on Linux) table through MyODBC. Apparently the problem
is
> that the new ODBC connection providers in Windows ME / 2000 do not like
the
> BIGINT datatype. Yet, strangely, MS Access 97 can import the data from
said
> table just fine (in Windows ME and 2000). And the VB app worked just fine
> on Windows 98. Can someone offer insight into this problem? What could
be
> going on here? Also, if possible, does someone know the SQL syntax for
> changing the datatype of an existing column from BIGINT to INT. Thank you
> very much,
> Laszlo Szijarto
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
> The information contained in this email is privileged and confidential
> and intended for the addressee only. If you are not the intended
> recipient, you are asked to respect that confidentiality and not
> disclose, copy or make use of its contents. If received in error
> you are asked to destroy this email and contact the sender immediately.
> Your assistance is appreciated.
>
---------------------------------------------------------------------
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
