Browse Header Problem

[Ams]

Hello,<br>&nbsp;I am working in Fox2.6 for DOS on Win 98. I run my application via a PIF in window mode. When a browse window appears, the headings of the columns have a 'a' added to them. e.g. 'Date' becomes 'Datea'.<br>&nbsp;Any suggestions.

 

[medic]

Check for duplicate fields in your select statement. Whenever&nbsp;&nbsp;you use a field name more than once, the select command&nbsp;&nbsp;shall append '_a' to the first field, '_b' to the second field, etc. Like for example:<br><br>select master.itemcode, trans.itemcode, ;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;trans.date, trans.amount ;<br>&nbsp;&nbsp;from master, trans ;<br>&nbsp;&nbsp;order by itemcode<br><br>the resulting query would generate the following field names: itemcode_a, itemcode_b, date, amount<br>

 

[Guest_imported]

In your browse field name is duplicating. When you browse e.g from two tables and if one or more field/s are duplicating then it browse fild1_a(from one table) and field_b(from 2nd table).<br><br>Therefore check your browse sytax.<br><br><br>farrukh

 

[Ams]

You are right. But this is not the case. Try this. In the command window ( Foxpro-DOS,full screen mode) open a database and give the browse command. Now, press Alt+Space, select properties and change to Window mode. Immediately you'll see a attached to the end of the browse heading.