Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filtering all records
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Filtering all records
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01414865
Message ID:
01414865
Vues:
85
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform