Display selected row/s and its file name from multiple dbf

[TheLazyPig]

Hi!

Example that I have multiple dbf's and selected row/s from one of them. I want to display the selected row/s and the file name of dbf in a table.


Thanks in advance!

 

[mm0000]

How did you select the records from the multiple dbf's? Select statement?

If so just add dbf(), recno() to the select statement to get the dbf name and record number in the result.

Eg: Select *,dbf() as dbfname ,recno() as rowno from tablename into cursor temp.

 

[TheLazyPig]

I used select statement to get the records. I tried your query but dbf() return is .tmp file and different path from where I was testing the program.

I don't want it to have a specific path so I used CURDIR() and the dbf's were located from a sub-folder.

 

[mm0000]

Since it is showing .tmp as the dbfname, your final select query must be from a cursor and not a table.

Put the select statement with dbf(), recno() in the first queries that created the cursor(s) (.tmp files).

 

[Mike Lewis]

Please show us the code you are using to select the records.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads