Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FastXtab Problem
Message
De
13/01/2017 02:12:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
FastXtab Problem
Divers
Thread ID:
01646642
Message ID:
01646642
Vues:
55
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform