>Hi
>
>I've been debugging an old FPD26 prog again (Man, i must have earned some bad karma points in my last life!). The prog produces a table of results, after going all round the arcane houses (not my code but that of my nemesis predecessor). Anyway, the table is readable in VFP7 (see below) but the users, who only have access to native foxpro 2.6, are unable to open the "database", getting a messaage like "Not a foxpro database" (the equiv. of "not a table").
>
>I thought that foxpro (free) tables were the same and readable no matter what version they were created in. So is there something in the code that could be giving the results table a distinctively VFP flavour, unrecognisable from PFD26?
>
>For convenience I run the prog from the VFP7 IDE, so I can make use of the debugger and, of course, enhanced IDE. Now the output of the prog is a table of results, based on data in other tables, and it's created thus within the prog:
>
>
>create table _fb1 (;
> field_name c(10),;
> field_type c(1),;
> field_len n(3.0),;
> field_dec n(3.0))
>
>
>There is no VFP database open at this time so I wouldn't have thought that the lack of the "FREE" clause here would force it to take on a database aspect
>
>Then later:
>create _fb2 from _fb1
>
>which is a temp holding table, which ia APPENDed FROM a type delim file
>
>Then there's a series of appending blank and replacing.
>
>Then later:
>
>
>select journey,route,operator,;
> date,number,ticktime,;
> class,fare,value,ostage,dstage, ;
> duty,bus,driver ;
> where !empty(date) ;
> from _fb2 into table fb1 ;
> order by date,route
>
>
>which is the (sort of) final output, before it's copied to a new table, FB1.dbf, created on the fly, in the selected folder.
>
>
>Any suggestions: 'ppreciate it.
>
>Terry
Would copy to not solve it ?
copy to fb1 fields journey,route,operator, ... all for !empty(date) TYPE FOXPLUS
Gregory
