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,
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
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.
At 09:43 AM 4/29/99 -0500, Phillip Grant wrote:
>What front-end are you using? ACCESS? FoxPro?, VB? C/C++?
>From: Matt Mahoney [mailto:mattm@stripped]
>Sent: Thursday, April 29, 1999 8:27 AM
>Subject: Can't edit fields in ODBC database
> 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.
>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.