Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table definition for CREATE CURSOR
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01052394
Message ID:
01052444
Views:
7
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform