Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter does not send update in MySql
Message
 
To
07/04/2003 14:08:54
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00774652
Message ID:
00774932
Views:
20
my table structure in MySql:

CREATE TABLE `classe` (
`código` varchar(20) NOT NULL default '',
`nome` varchar(25) NOT NULL default '',
`data` timestamp(14) NOT NULL,
`id` varchar(10) NOT NULL default '',
`grupo` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`código`),
KEY `id` (`id`)
) TYPE=MyISAM;

My code in Visual Fox Pro:
public objCA as CursorAdapter 
set multilocks on 
objCA=createobject("cursoradapter")
objCA.Alias="classe"
objCA.DataSourceType="ODBC" 
objCA.DataSource=sqlstringconnect([dsn=betafar;uid=betafar;pwd=beta332;trusted_connection=no;])
objCA.SelectCmd="select classe.código,classe.grupo from classe"
objCA.CursorSchema="código I, grupo I"
objCA.KeyFieldList="código"
objCA.Tables="classe"
objCA.UpdatableFieldList="grupo"
objCA.UpdateNameList="código classe.código,grupo classe.grupo"
objCA.SendUpdates= .T. 
objCA.WhereType= 1 
objCA.CursorFill()
select classe
browse
When I try to modify the field GRUPO:

"Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources"

After this, only close the table with tablerevert.

my command "sqlstringconnect" he is the same that i successfully with view remote use (sendupdate too).
Cordialmente,

Fabiano Costa
Previous
Reply
Map
View

Click here to load this message in the networking platform