Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field trouble.
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Memo field trouble.
Miscellaneous
Thread ID:
00155509
Message ID:
00155509
Views:
51
Hello Everyone,
I'm having an interesting problem with memo fields and VFP 6.0. I know this is a long explanation but I would appreciate any advice.

I've created a four-page form using the Mere Mortal's framework cBizObjMaintenanceForm:

On the third page of this form's pageframe is a standard BizObj called ContactsBizObj. It is pretty normal and uses the ContactsEnvironment. Everything works great on this page. I see what I expect and I can work with the data. Life is good.

The fourth page is supposed to display a list of comments that have been created about the different contacts. There are only three objects on this page.
1. A subclass of cListObjEdit called lstContactComments.
2. Currently and edit box called edtComment.
3. A label called lblName.

lstContactComments uses the built in cListObj1 because I could not conceive of any business rules for free form comments beyond the standard data manipulation. The environment is set to ContactCommentsEnvironment which uses a cursor called v_ContactComments. (I'm creative if nothing.) ContactsBizObj is set as the cParentBizObj for cListObj1. (ContactsBizObj does have its unique id property set.)

The v_ContactComments is based on a table called, you guessed it, ContactComments and a view named lv_ContactComments. Everything looks good. There are only seven fields in ContactComments and one of them is of course the memo field mComment.

Now if you browse the table directly you can see and manipulate the comments. If you browse the lv_ContactComments view directly you can see and manipulate the comments. The problem is that when I run the application I cannot see the comments. They do not show up in the edit box.

I've made sure that I issue refreshes at the correct point and everything looks good. You can see comment records in the primary list but you don't get comments in the edit box. (The control source is set correctly.) When I suspend the application and look at the tables directly there are a couple of interesting things happening.

The view v_ContactComments shows the mComment field with the word "Memo". (The upercase "Memo" is FoxPro's way of saying there is a memo associated with this memo field.) However, when I double clicked on the field all I get is an empty box. The view is returning empty memo fields, but I can see the memo in the stand alone view. What's up? Does anyone have a clue?

I've had this exact approach working before when we were using VFP 5.0. Is there something different in VFP 6.0 I should do now?

Thanks,
Bill
William Hartgrove
Senior Elephant Waxer
Hartgrove Amusent Park and Youth Hostel
Austin, Texas
Next
Reply
Map
View

Click here to load this message in the networking platform