Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FastXtab Problem
Message
From
13/01/2017 02:12:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
FastXtab Problem
Miscellaneous
Thread ID:
01646642
Message ID:
01646642
Views:
54
Dear Experts

I am using these codes
select stock

local oxtab
oxtab = newobject("FastXtab", "fastxtab.prg")

oxtab.coutfile = 'results'		&& output (cursor/dbf) name, change it at your will
*oXtab.lCursorOnly = .T.		&& .T. creates a cursor while .F. a dbf

oxtab.crowfield = 'usno'		&& rows = user_id
oxtab.ccolfield = 'cate'		&& columns = products
oxtab.cdatafield = 'nos'		&& cells = amount
oxtab.nfunctiontype = 2			&& use COUNT()
oxtab.ccondition = "nos > 0"		&& where amount > 0

*oXtab.lDisplayNulls = .T.		&& .T. display NULL
*oXtab.lBrowseAfter =  .T.		&& .T. only if you want a browse to check the result

oxtab.lclosetable = .f.			&& .T. close the source table

oxtab.runxtab()

axb=ALIAS()
SELECT (AXB)
BROW
The codes work fine outside EXE and displays correct result shown in attachment

But

When I run above code in EXE then codes do not work, this command does not show any data
SELECT (AXB)
BROW
Please help
Next
Reply
Map
View

Click here to load this message in the networking platform