Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursoradapter question
Message
De
24/02/2006 15:37:05
 
 
À
23/02/2006 11:39:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01098549
Message ID:
01099035
Vues:
11
Okay. This is how the DBSETPROP()s are done and these work. How are these settings done in the CursorAdapter class?
cSql = [select Tempx.PKFLD, Tempx."LEVEL$" as "LEVEL" from MYDB.Tempx Tempx]
create sql view "rv_tempx" remote connection "MyConn" as &cSql

*... other codes
dbsetprop("rv_tempx.level","Field","DataType","C(10)")
dbsetprop("rv_tempx.level","Field","UpdateName","MYDB.TEMPX."+chr(34)+"LEVEL$"+chr(34))
dbsetprop("rv_tempx.level","Field","KeyField",.f.)
dbsetprop("rv_tempx.level","Field","Updatable",.t.)
>Hi all,
>
>I am using the CursorAdapter class in VFP8 and I have this scenario. Due to reserved keyword restriction and poor choice of column names, we have the following table schemas:
>
>
>  Assume that PKFLD is the primary key.
>
>  Oracle:
>  MyTable (PKFLD NUMBER(10), Level$ VARCHAR2(10))  && LEVEL is reserved in Oracle
>
>  VFP8:
>  MyTable (PKFLD I, Level C(10)) && '$' is not valid in VFP8
>
>
>There is the CursorSchema property which I can use for the VFP8 cursor schema. Where should the mapping go?
>
>Using the CREATE SQL format this works:
>
>cSql=[SELECT Level$ AS "Level" FROM MyTable]
>CREATE SQL VIEW rv_MyTable REMOTE CONN MyConn AS &cSql
>* --- DBSETPROP() and CURSORSETPROP() follows ...
>
ramil
~~ learning to stand still
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform