Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi,
>
>Is there a away to change the WHERE expression without
>creating the entire view ? (I could not find any)
>
>I have a Notes form, that need to serve 2 other forms like supplier
>and one for distributor. If I use the same view for both forms then I
>need to change the filter expression on the fly ?
>
>I could NOT see away to do it with DBSETPROP() as of now.
>
>I would need to change the actual field it instead of :
>
> WHERE Notes.idis_sysid = ?ParentPKValue
>
>To:
>
> WHERE Notes.iPub_sysid = ?ParentPKValue
>
>Thanks
>
>Doron
Doron,
I understand that you may not be able to change the notes table layout, but if you can I would suggest the following structure:
Notes.Id
Notes.Parent_Table
Notes.Parent_id
Notes.Note
With this kind of layout the where clause of your view would be
where notes.parent_table=?cParentTable and notes.parent_id=?parentid
Mark
Précédent
Suivant
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