_GENXTAB Problem 1

[Lengliz]

Hi everybody,

I have the following data (Table1.dbf):

Code Line Qty
C001 1 10
C002 1 20
C003 1 30

Now, I want to consolidate the above into a table (table1_xtab.dbf) that has 1 record per Code... as such:

Line C001 C002 C003
1 10 20 30

Using Query:

SELECT Table1.line, Table1.code, SUM(Table1.qty);
FROM table1;
GROUP BY Table1.line, Table1.code;
ORDER BY Table1.line, Table1.code;
INTO TABLE SYS(2015)
DO (_GENXTAB) WITH 'table1_xtab.dbf'


It works fine in VFP but when i execute the runtime i have this error message : "File not found"

Thank you
LENGLIZ

 

[Mike Lewis]

You need to add the file named VFPXTAB.PRG to your project. This file is in your VFP executable directory.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Lengliz]

Hi Mike,
I added VFPXTAB.PRG in my project (in program) but i steel have the same error message !!!

Thank you
LENGLIZ

 

[Mike Lewis]

Hi Lengliz,

Sorry, I should also have mentioned that you need to change this line:

DO (_GENXTAB) WITH 'table1_xtab.dbf'

to

DO VFPXTAB WITH 'table1_xtab.dbf'

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Lengliz]

Thank you Mike it works fine

 

[cpmasesa]

Mike,

Your answer to Lengliz has helped me make my coding life a lot easier.

I have tries searching online, the VFP help and a couple of VFP books that I have and I found no reference at all to _GENXTAB and VFPXTAB.

Where can I get the syntax to this command, I suppose you can pass additional parameters apart from the output table name.

TIA,

CPM

 

[Mike Lewis]

Hi CPM,

The reason you can't find any documentation for _GENXTAB or VFPXTAB is that these are obsolete items, left over from pre-Visual versions of FoxPro.

However, VFPXTAB.PRG is still available. To find it, you need to unzip your XSource folder, then drill down to Wizard\WZPivotal. There you'll find the source code. The comments at the top of the program will tell you how to call it and what parameters to pass.

Hope this helps.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[TamarGranor]

Mike - I don't think VFPXTab is obsolete. It is specifically a VFP version of GENXTab. It hasn't been updated in a while, but it works.

Tamar

 

[Mike Lewis]

Tamar,

I didn't mean to suggest that it doesn't work anymore. I really meant that it is an old program that hasn't been updated since VFP 3.0.

The reason I said that is that the program is dated 1993 - 1995, and the comments refer to it working with the old RQBE.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk