General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
sqlcolumns() is a good thingie .
then take the resulting table, and do a scan..endscan on it with your codeblock inside, generating the code you want for your view,
then putting that code in the memo field represented in the dbc for that one remote view . its a hack, but i've made it work in the past . you'll need to tweak the remote view in low level as well- but thats easy - its just another table [VBG] stored in the dbc.
hth - mondo regards [Bill]
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