I have foxpro app which uses .dbf as database and generate a .txt file for report printing. is there any way to know what query foxpro app is using for report preparation. I have .prg, .idx, .dbf, .fxp and some other files.
+2
A:
- .prg is the code file
- .idx is the index
- .dbf is the table
- .fxp is the compiled foxpro code.
Your query will be in the prg file - you will need to read through the code - it should be similar to an SQL query (Select...).
Leom Burke
2010-07-01 08:34:10
A:
Additionally...
.scx and .sct are paired files used for forms, and within them could be methods, like on buttons to actually run the queries.
likewise with .vcx and .vct are paired files used for class libraries which could also hold code depending on how the app was constructed.
DRapp
2010-07-01 11:41:27
Good point - I missed the "and some other files" bit! if it is a form app rather than just run the prg then it will of course have the logic in the form its form/class library. separation of concerns - whats that then ;-)
Leom Burke
2010-07-01 11:48:49
its a DOS based application
RAJ K
2010-07-01 13:22:03
wow... I know of one other prior client still running a DOS system, so you won't have any forms or class libraries to deal with.
DRapp
2010-07-01 18:00:31
A:
If it's FoxPro/DOS then you can have 'screens' defined in paired .SCX/.SCT files. These are used to auto-generate program code. These are just .DBF files with a different extension, you can open and browse them etc. The controls on these screens have code 'snippets' behind them.
You also have standard .PRG files which have plain old program code.
Assuming this application is built as part of a project then at build time the screens generate a temporary .PRG file, which is then compiled into the overall .APP or .EXE, and the code in .PRG goes into the .APP or .EXE in a compiled form too.
So your code that generates the report output either lives in a screen 'snippet', which is effectively like method code, or in a plain PRG file.
Alan B
2010-07-05 14:16:59
+1
A:
You might also find the query in a qpr file. This is a file of SQL which has been created by the FoxPro query builder.
Be aware that FoxPro has many ways of generating text files and might not be using a query at all. Try looking these up in VFP Help or on line:
- StrToFile
- SET TEXTMERGE
- TEXT ... ENDTEXT
- FOPEN, FWRITE, FPUT
- COPY TO ... TYPE CSV
geoff franklin
2010-07-07 08:07:54