Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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]
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