General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Specifying fields in remote view
I have back-end tables that may not be in the same field order because of release issues. IOW a field may be added in a prior release and later added to the current release. Is there a way to specified specific fields in what would otherwise be a select * from tablename?
Table in Release 1
Field_abc
Field_def
Field_ghi
Table in Release 2
Field_abc
Field_ghi
Field_def
The remote will give me a base tables has changed if I sync to release 1 and try to connect to release 2 and vice versa. If there is a quick remote view trick to give me an updateable remote view I'll take it. Otherwise I will probable just to to SPT.
Thanks.
Next
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