Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursortoxml
Message
From
18/08/2008 15:23:50
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01339608
Message ID:
01339650
Views:
13
Here is my cursor code:
SELECT id, job, sku, name, pack, nneedqty, line_id ;
FROM curRunningJob ;
WHERE jobcategory = lnCurrentCategory ;
AND id # 0 ;
AND active = 4 ;
INTO CURSOR curRunningJobForServer

Where curRunningJob is a cursor. Will NOFILTER clause help?

Thanks

>If RECCOUNT() > 0 does not mean that there're any records in the cursor. See http://www.berezniker.com/content/pages/visual-foxpro/queries-and-filtered-cursors
>
>>Are there any know issues CURSORTOXML command?
>>
>>I am running this command:
>>CURSORTOXML('curTestCursor', 'lcXmlData', 2, 0, 0, '1')
>>which would create an xml string with an inline schema.
>>
>>Then down the program I have this code:
>>IF RECCOUNT('curTestCursor') # 0 STRTOFILE(lcXmlData, 'c:\data.txt')
>>ENDIF
>>Sometimes (not often at all) I would have data.txt with just a schema, without actual data part:
><snip>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform