MySQL BUG

2002-12-20 Thread deep kapasi
Hi, I am facing strange problem while accessing a LONGTEXT field. I've been using VisualBasic 6.0 & MySQL 4.0.4 via ADO 2.0 by using MyODBC 3.51.04 on WIN2k Server (SP 2). Pls follow the below steps to generate a bug --> '/' 1. Create a Tabl

BUG in InnoDB tables

2002-09-19 Thread deep kapasi
Hi, I am using MySQL 4.0.3 and Innodb tables for my application, I have created a unique index on multiple column but its not working, here is sql script to generate an bug CREATE TABLE TESTING ( ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY , FLD1 VARCHAR(100) NOT NULL , FLD2 VARCHAR(15) NOT NUL

Problem with BLOB Field

2002-08-13 Thread deep kapasi
Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyODBC 3.51.03 I have create a table which has BLOB field in which i want to save a bitmap file. To save record i create a AD

Re: Problem with BLOB field

2002-08-08 Thread deep kapasi
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > deep, > Thursday, August 08, 2002, 4:08:22 PM, you wrote: > > dk> It looks like a simple bug but I have spent lots > of > dk> hours try to solved it but not success yet. > > dk> Application: Visual Basic 6.0 > dk> Database used: MySQL 4.0.1 & MySQL 4.

Need help on Multi-table update queries

2002-07-29 Thread deep kapasi
Hi, I m using MySQL 4.0.2 which now supports multi-table update query I am getting error while throwing multi-table UPDATE query, I don't know what the problem is To generate an error run below query, it will create a 2 InnoDB table and inserts a dummy record in it CREATE TABLE `systemdefault`

Need help on Multi-table update queries

2002-07-28 Thread deep kapasi
Hi, I m using MySQL 4.0.2 which now supports multi-table update query I am getting error while throwing multi-table UPDATE query, I don't know what the problem is To generate an error run below query, it will create a 2 InnoDB table and inserts a dummy record in it CREATE TABLE `systemdefault`