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:
56
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