select statement in .prg file

[huzefaid]

we have a project to convert DOS Foxpro to windows application
we are struggling to find select statement in .prg file
there is only table name, index and lots of DO,SEEK, READ AND DO .. WHILE LOOP

we are able to get table name but how to get relationship between 2 or more tables in complex reports

for data entry we have already created screen.
we are struck in report part. please help

how can i get or extract select statement from .PRG file so that we can reconstruct it in Sybase Powerbuilder Datawindow

 

[JRB-Bldr]

we have a project to convert DOS Foxpro to windows application

The best conversion path from FPD to a Windows application would be to migrate to Visual Foxpro 9. It would enable you to use a large portion of the existing code 'as is' and will result in a powerful, 21st century appearing GUI-centric Windows application which can 'grow' in many directions.

In your FPD PRG file the original developer may very likely did not use a SELECT statement since Foxpro does not require a SQL SELECT to acquire its data from its data tables. A SQL SELECT can be used, but quite often, especially in older applications, it was not.

Once a particular data table is in USE and its 'workspace' has been SELECTED, the application only needs to go to the appropriate record via a GO <record number>, a LOCATE FOR <some criteria>, or a SEEK <some criteria> and then the desired record and its field values are immediately available to use for Read/Write operations. Also separate data tables may be truly RELATED and used as 'aggregates' via Index relations.

In order to gain a better understanding of Foxpro, you might want to look over the free on-line Visual Foxpro tutorial videos at:

http://www.garfieldhudson.com/FreeVideos.aspx

Those videos are about Visual Foxpro, but a good part of the information is the same for the non-Visual versions of Foxpro.

Of particular interest might be those videos related to:
Navigating Records in a Table
Deleting/Recalling Records
Indexing Records
and others related to data access

Good Luck,
JRB-Bldr

 

[JRB-Bldr]

Since your question is about application migration - you might also want to look over the migration discussion that is occurring at: thread182-1656246

Good Luck,
JRB-Bldr