Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering all records
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Filtering all records
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01414865
Message ID:
01414865
Views:
86
Hi everybody,

I have a form that has information displayed at the top based on Notes table and then also information in the grid using the cursor cNotes.

I have an ability to filter the content of cNotes (using SET KEY approach).

This is what I have at the bottom of the method that filters the information
IF USED('cNotes')
	SELECT cNotes
	LOCATE FOR cNotes.nNoteID = m.lnNoteID && current note id before the filter was applied
	IF !FOUND("cNotes")
*		GO TOP IN cNotes
		LOCATE in cNotes 
	ENDIF && !FOUND("cNotes")
	THISFORM.iGoToNote(cNotes.nNoteID)	
ENDIF
My problem is - if all records were filtered out, what and how should I show at the top portion? I would assume I would need to show blank information, but how exactly?

Thanks in advance for the ideas.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform