Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unhandled win32 error on down arrow in grid
Message
 
To
20/07/2006 12:59:36
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01138142
Message ID:
01138144
Views:
19
This message has been marked as the solution to the initial question of the thread.
Hi Tracy

These rows are dangers if fields contain .NULL. value.
Add NVL() for removing .NULL. values.
.Column2.CONTROLSOURCE = "(ALLTrim(Last) + IIF(!EMPTY(LAST) AND !EMPTY(FIRST),', ','')  + ALLTRIM(First) + IIF(!EMPTY(MIDDLE),' ' + ALLTRIM(Middle),'') + IIF(!EMPTY(Title), ' / ' + ALLTRIM(TITLE),''))"
.Column8.CONTROLSOURCE = "(ALLTRIM(addr_1)+' '+ALLTRIM(apt_room))"
END
MartinJ

>Grid sits on a page in a pageframe. This form has numerous pages and almost every page has a grid on it. The grid is loaded when the page is activated. This works on all pages except for one. On one page, the layout of the grid is not the same as the layout of the cursor that is created. To handle this, the grid properties are set in the page.activate() after the cursor is created. For some reason, if there is more than one record in the cursor, only the first record is displayed and when you click on the grid to select it and press down arrow (even though only one record is visible) a C5 error occurs. The line in the vfp9err.log is the read events line in the main.prg There is code in the afterrowcolchange of the grid but the code is identical to the other grids. It appears to have something to do with the fact that the 2nd record does not display in the grid, but if I slap a generic grid on the form, then the 2nd record displays until I run the code in the page activate which
> sets the grid's properties. Any ideas anyone?
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform