Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter does not send update in MySql
Message
 
À
07/04/2003 14:08:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00774652
Message ID:
00774932
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform