Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table definition for CREATE CURSOR
Message
 
 
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
Divers
Thread ID:
01052394
Message ID:
01052444
Vues:
8
>It works if I do not pass in the alias name as a parameter.
>
The second parameter is not a string, but logical. It picks it up from the opened table. Read the code, the variable names and the code itself should be self-explanatory. You're also free to change this code to your liking.

?fieldstostring(.t.,.t.)
TRANS_EMPLOYEES_QUEUES.CTRANS_EMPLOYEES_QUEUES_PK C(16), TRANS_EMPLOYEES_QUEUES.CTRANS_FK C(16), TRANS_EMPLOYEES_QUEUES.CQUEUE_NAMES_FK C(16), TRANS_EMPLOYEES_QUEUES.CCOMMISSION_OWNER_USGRLINK_FK C(16), TRANS_EMPLOYEES_QUEUES.CUSGRLINK_FK C(16), TRANS_EMPLOYEES_QUEUES.CSUPERVISOR_REVIEW_USGRLINK_FK C(16), TRANS_EMPLOYEES_QUEUES.CTRANSFER_IN_USGRLINK_FK C(16), TRANS_EMPLOYEES_QUEUES.CTRANSFER_OUT_USGRLINK_FK C(16), TRANS_EMPLOYEES_QUEUES.CPOINTER_FK C(16), TRANS_EMPLOYEES_QUEUES.IACTIVE_FLAG I, TRANS_EMPLOYEES_QUEUES.IPRIMARY_FLAG I, TRANS_EMPLOYEES_QUEUES.ITEMPORARY_ASSIGNMENT_FLAG I, TRANS_EMPLOYEES_QUEUES.TTEMPORARY_START_DATE T, TRANS_EMPLOYEES_QUEUES.TEXPIRE_DATE T, TRANS_EMPLOYEES_QUEUES.TTRANSFER_IN_DATE T, TRANS_EMPLOYEES_QUEUES.TTRANSFER_OUT_DATE T, TRANS_EMPLOYEES_QUEUES.TSCHEDULED_CLOSE_DATE D, TRANS_EMPLOYEES_QUEUES.ISCHEDULED_CLOSE_REASON_CODE I, TRANS_EMPLOYEES_QUEUES.TENTERED_DATE T, TRANS_EMPLOYEES_QUEUES.CENTERED_USER C(10), TRANS_EMPLOYEES_QUEUES.TLAST_UPDATED_DATE T, TRANS_EMPLOYEES_QUEUES.CLAST_UPDATED_USER C(10)
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform