Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter with variable filter expresion
Message
From
13/10/2005 16:49:49
 
 
To
13/10/2005 16:16:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01058851
Message ID:
01058866
Views:
8
>Hello
>
>I have a form , a Cursor adapter (created with CABuilder.prg), a Grid and several textboxes in order to let the user put values and define a search criteria to build a different "Where clause" (cSelectCmdFilter property) every time.
>
>It happens that the cursor is built the first time with the cSelectCmdFilter property blank, but every time I build a different "Where" , calling the CursorRefresh method is not enough to refresh data on the grid, instead a call to CursorFill is necessary but the grid becomes blank . After this, having the grid according to design time has to be done by code.
>
>Is this the normal behaviour, or is it possible to refresh the cursor without calling CursorFill.
>
>Filter's Parameters are not the same every time, the whole Filter may be different and is built by code.
>
>I hope to be clear on this.
>
>Any help or comments,
>Thanks.
>Juan C.

CursorRefresh has this senseless limit:

Specifies the current value of SelectCmd as established in the BeforeCursorFill event.

Impossible to overcome it, because SelectCmd is readonly.
Previous
Reply
Map
View

Click here to load this message in the networking platform