No reply of my early mail Pls reply this mail

------=_NextPart_000_000F_01C5EAF4.7308E610
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Respected Sir,

This is my second mail earlier at 27-10-2005 i have mail the problem but
there was no response so please do needful to solve the query. I need the
solution because I have already implement VB with MySQL and my confidence
towards mysql is going down please help me. I have hereby attached the code
which works excellent in ms access.

Error :
1 without the text field table value is not inserted or updated
2 through ado recordset update (rs.update) is not updating with where
condition but it is updating the full table.

From Vishal Panchamia


------=_NextPart_000_000F_01C5EAF4.7308E610
Content-Type: text/plain; charset=us-ascii


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
------=_NextPart_000_000F_01C5EAF4.7308E610--

Re: No reply of my early mail Pls reply this mail

--=_alternative 005A5DA2852570BB_=
Content-Type: text/plain; charset="US-ASCII"

"vishal" wrote on 11/16/2005 10:56:47 AM:

> Respected Sir,
>
> This is my second mail earlier at 27-10-2005 i have mail the problem but
> there was no response so please do needful to solve the query. I need
the
> solution because I have already implement VB with MySQL and my
confidence
> towards mysql is going down please help me. I have hereby attached the
code
> which works excellent in ms access.
>
> Error :
> 1 without the text field table value is not inserted or updated
> 2 through ado recordset update (rs.update) is not updating with where
> condition but it is updating the full table.
>
> From Vishal Panchamia
>
>

As you can see, your attachment was stripped. However I believe the
problem lies in the ADO/ODBC relationship. Have you followed all of the
recommendations here:

http://dev.mysql.com/doc/refman/4.1/en/msaccess.html

and here:

http://dev.mysql.com/doc/refman/4.1/en/msvba.html

There was a MS patch recently released that broke the ability of MS Access
to form linked tables through MyODBC. Perhaps that is also related to the
inability to use .addNew()

http://lists.mysql.com/search.php?q=msjet40&list=&m=o&begin= 60

However, without your actual code or the actual error message or details
about the tables in question or details about what version of MySQL you
are using, these are only my best guesses.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

--=_alternative 005A5DA2852570BB_=--

No reply of my early mail Pls reply this mail

------=_Part_28409_5338570.1132160224164
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I am just forwarding information send to me (my mistake, sent the
email just to Vishal, not the list, and so he replied to me, if the
list gets a copy too, sorry) MySQL Team could change the behavior of
the list so the default reply-to be the address of the list....

---------- Forwarded message ----------
From: vishal
Date: Nov 16, 2005 2:44 PM
Subject: Re: No reply of my early mail Pls reply this mail
To: Daniel da Veiga


here by again i am sending the files.

all details are in the source code
what you have to do is to create a database name test2 and have to set the
password of the server.

the code will automatically create a table name test2 with two double field=
s
and it will reture the error while adding the record through recordset and
after adding a text field it will work and another error is that it doesn't
updates the record which filters with where condition.

please take a stress to see the code and pls solve me the problem as early
as possible.

From Vishal Panchamia




----- Original Message -----
From: "Daniel da Veiga"
To: "vishal"
Sent: Wednesday, November 16, 2005 9:43 PM
Subject: Re: No reply of my early mail Pls reply this mail


On 11/16/05, vishal wrote:
> Respected Sir,
>
> This is my second mail earlier at 27-10-2005 i have mail the problem but
> there was no response so please do needful to solve the query. I need the

You got at least 2 replies of your mail, and as you never returned, I
guess the list considered your problem solved.

> solution because I have already implement VB with MySQL and my confidence
> towards mysql is going down please help me. I have hereby attached the
code
> which works excellent in ms access.

No, you didn't, dunno HOW you're attaching stuff, but I am not getting it.

> Error :
> 1 without the text field table value is not inserted or updated
> 2 through ado recordset update (rs.update) is not updating with where
> condition but it is updating the full table.
>
> From Vishal Panchamia
>

Its hard to guess what's going on, you'll have to provide us more
info, the table structure, code, and even some data so we can
reproduce the error.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------





--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------


------=_Part_28409_5338570.1132160224164
Content-Type: text/plain; charset=us-ascii


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
------=_Part_28409_5338570.1132160224164--