How show record number if BROWSE 4

[ilovemusic]

I'd like to use the BROWSE command with a table and have it show the number of each record in the display.

I used to be able to do this, but forgot how. Anyone know?

 

[jimstarr]

I don't see a way to do it with a straight BROWSE. How about

SELECT *, RECNO() AS recnum FROM mytable


Jim

 

[Stella740pl]

Try

BROWSE FIELDS A, B, C, D=RECNO() for C>100

 

[mspratt]

Hi ilovemusic,

If you are using VFP8 and you either have the Task Pane load at startup or open and then close the Task Pane, DB status information will be gone from the Status Bar. Not sure which setting is being turned OFF, though.

Regards,

Mike

 

[torturedmind]

BROWSE FIELD xrecno=RECNO(), DField1, DField2, ...

i sure hope this helps. peace!

kilroy
philippines

"Illegitimis non carborundum!"

 

[mspratt]

Hi ilovemusic,

Just out of curiosity, are you using BROWSE in a program, or in the IDE?

Regards,

Mike

 

[culleoka]

ilovemusic,

Down & dirty:

Alter Table Current.dbf Add Column nRecNo n(5)
Replace all cRecNo with RecNo()
Browse

Pat

 

[ilovemusic]

To MSPRATT

I'm using Browse in the IDE but also sometimes in short programs.

 

[mspratt]

The reason I ask is because the Task Pane resets the status bar. It can be turned back on by issuing SET NOTIFY CURSOR ON in the Command window.

Regards,

Mike