Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Edit box in grid only shows first 40 chars
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01096588
Message ID:
01096665
Vues:
11
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform