Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Shared Connection Problem
Message
 
 
À
13/07/2005 14:29:13
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01032328
Message ID:
01032402
Vues:
16
Just a SWAG, but set your FetchSize to -1. What is SET("ENGINEBEHAVIOR") returning? Do you still get the error if you change it to a different value? (e.g., 90 instead of 70/80, or 70/80 instead of 90)?

Something else you could try:

llOldMapVarchar = CURSORGETPROP(0, 'MapVarchar')
CURSORSETSETPROP(0, 'MapVarchar', !llOldMapVarchar)

Do this BEFORE opening the views. Same goes for the new MapBinary property for cursors/views.

>>Could you post the SQL code used to create those views?
>>
>Sure.
>
>CREATE SQL VIEW "V_LABEL" ;
> REMOTE CONNECT "CONNECTPLAY" ;
>	AS SELECT tblLabel.lab_KEY,;
>		tblLabel.lab_NAME,;
>		tblLabel.lev_LEVEL,;
>		tblLabel.lab_ATTENTION,;
>		tblLabel.lab_DEPARTMENT,;
>		tblLabel.lab_DELIVER_TO,;
>		tblLabel.lab_STREET,;
>		tblLabel.lab_CITY,;
>		tblLabel.lab_CITY_LINE,;
>		tblLabel.sta_STATE_CODE,;
>		tblLabel.lab_POSTAL_CODE,;
>		tblLabel.cou_COUNTRY_CODE,;
>		tblLabel.lab_COUNTRY_LINE,;
>		tblLabel.lab_CREATION_DATE,;
>		tblLabel.cnc_CURRENCY_CODE,;
>		tblLabel.lab_ALT_NUMBER,;
>		tblLabel.lab_E_MAIL,;
>		tblLabel.typ_CUSTOMER_TYPE,;
>		tblLabel.lab_ENTERED_BY,;
>		tblLabel.lan_LANGUAGE_CODE,;
>		tblLabel.lab_REVISION_DATE,;
>		tblLabel.lab_SAN,;
>		tblLabel.lab_PARENT_LABEL,;
>		tblLabel.lab_REMINDER,;
>		tblLabel.lab_SAN_SUFFIX,;
>		tblLabel.cus_SOLD_TO_CUSTOMER,;
>		tblLabel.lab_PREFERRED_COMM,;
>		tblLabel.lab_FIRST_NAME,;
>		tblLabel.lab_MIDDLE_INITIAL,;
>		tblLabel.lab_LAST_NAME,;
>		tblLabel.lab_NAME_SUFFIX,;
>		tblLabel.npr_NAME_PREFIX,;
>		tblLabel.own_OWNER_CODE,;
>		tblLabel.lab_EMAIL_FORMAT;
>	FROM dbo.tblLabel
>
>DBSetProp('V_LABEL', 'View', 'UpdateType', 1)
>DBSetProp('V_LABEL', 'View', 'WhereType', 1)
>DBSetProp('V_LABEL', 'View', 'FetchMemo', .T.)
>DBSetProp('V_LABEL', 'View', 'SendUpdates', .T.)
>DBSetProp('V_LABEL', 'View', 'UseMemoSize', 255)
>DBSetProp('V_LABEL', 'View', 'MaxRecords', -1)
>DBSetProp('V_LABEL', 'View', 'Tables', 'dbo.tblLabel')
>DBSetProp('V_LABEL', 'View', 'Prepared', .T.)
>DBSetProp('V_LABEL', 'View', 'CompareMemo', .T.)
>DBSetProp('V_LABEL', 'View', 'FetchAsNeeded', .F.)
>DBSetProp('V_LABEL', 'View', 'FetchSize', 100)
>DBSetProp('V_LABEL', 'View', 'ParameterList', "v_key,'I'")
>DBSetProp('V_LABEL', 'View', 'Comment', "")
>DBSetProp('V_LABEL', 'View', 'BatchUpdateCount', 1)
>DBSetProp('V_LABEL', 'View', 'ShareConnection', .T.)
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform