General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Mark,
You are correct, I will have to change the design of the Notes
table.
Thanks
Doron
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only