Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>I have 2 questions on views:
>
>1. Sometimes I get a message,
> Cannot insert an empty row from a view into its base tables
>
>Now, this is probably because of some problem in my code, but is there some command to get out of this...clear all,close all etc does not work, keeps coming up with error and I have to BOMB out of VFP
When you close the view in 6.0 it is supposed to cancel anything in the buffer. I think in 5.0 though it will try to do a tableupdate.
Try...
tablerevert(.t.) which should clear anything in the buffer.
>2. I have a from which uses a parameterized updateable view.
> I am not using the data Environment (instaed I open all files on a startup routine) , but message keeps coming up to enter a value in the parameter field (?lcField)
>Now, I know if I was using DE, I wouls set the NODATAONLOAD , but is there an equivalent if i am not using DE ?
You can do...
USE v_MyView NODATA
This will open the view so that fields can be bound to it. You will not need to create the parameter until you requery() it.
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement