From: Phillip Grant
Date: April 29 1999 4:52pm
Subject: RE: Can't edit fields in ODBC database
List-Archive: http://lists.mysql.com/myodbc/186
Message-Id: <000601be9260$a4a8e380$3abbcbcf@gw300>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hey Matt,

The reason I asked what front-end you are using is because it will need to
determine if the result set is read or read-write.  I'm no VB expert, but I
use Visual FoxPro which can create an updateable view of MySQL data through
MyODBC(as long as the tables aren't extremely large, then it bogs down, I
narrow it down with a WHERE clause).

I've also successfully used SQL-Passthrough, which may be a viable option
for you in VB.  Are you using ADO, DAO, RDO, JET (insert your preferred 3
letter acronym here)?  Some of these create read-only result sets.  Not sure
which does what...

Bottom Line: Check to see that what you are creating is an updateable
view/recordset.  If that doesn't pan out, try direct SQL/SQL passthrough.

Hope this helps,
Phillip

-----Original Message-----
From: Matt Mahoney [mailto:mattm@stripped]
Sent: Thursday, April 29, 1999 10:11 AM
To: pgrant@stripped; myodbc@stripped
Subject: RE: Can't edit fields in ODBC database


Phillip,

	I am using Visual Basic. I also have tried another tool called Calistra
which is a database administration program that use ODBC but when I tried
to enter data in there it never saved it.

	-Matt

At 09:43 AM 4/29/99 -0500, Phillip Grant wrote:
>Matt,
>
>What front-end are you using? ACCESS? FoxPro?, VB? C/C++?
>
>	-Phillip
>
>-----Original Message-----
>From: Matt Mahoney [mailto:mattm@stripped]
>Sent: Thursday, April 29, 1999 8:27 AM
>To: myodbc@stripped
>Subject: Can't edit fields in ODBC database
>
>
>Hello,
>
>	When I try to edit or enter new data into fields using ODBC I get errors
>that say "Field is uneditable". I have checked the permissions on the
>server side and it should be fine. I can edit fields with no problem
>without using ODBC (i.e. running "myadmin" from windows). Does anyone know
>how I can fix this problem. Thank you.
>
>	-Matt
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail myodbc-thread181@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail myodbc-unsubscribe@stripped instead.