Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Edit box in grid only shows first 40 chars
Message
From
16/02/2006 03:04:04
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01096588
Message ID:
01096668
Views:
19
>OK, I've removed the container and just placed a grid on the pageframe page and converted textbox to editbox, sparse = .f. and added the code to initialize it. Oh, and now I only have 1 column.
>
>Now everytime I instantiate the form, I get the error:
>
>Error with edit1 - value:Data type mismatch.
>edit1 is the edit box in the grid.
>However, if I ignore the error the page displays fine.
>
>If I remove the grid and put a simple edit box on the page, and add the following code when I retrieve a record:
>
>
>SELECT cnotes
>WITH this.romaintpageframe1.page5.mheditbox1
>	
>SELECT CNotes.note as ro_note ;
> FROM cNotes ;
>  WITH (buffering = .t.) ;
> INTO CURSOR cGridNotes
> 	
> .controlsource = 'cGridNotes.ro_note'
>ENDWITH
>
>
>It works fine.
>
>One thing I did notice. When the form is initialized with just the editbox, when I step through the code, I noticed the controlsource = "" as it should be (since I don't assign the controlsource until later -- see above). However, when I put the editbox in the grid, then the controlsource keeps on defaulting to 'clookup.lup_id' which is an Integer field in a lookup table. This lookuptable is instantiated before init of the form. But nowhere do I assign that as the controlsource. Is that why I get an error, because it's an integer? How do I keep this from happening?
>
>I'm stumped.

put a ' ' single space into the grid RecordSource property
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform