Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
SQL Server or Oracle will not recognize GOTO 1 (that is a VFP command).
If you change the value of the paramater and then requery the view, the
new row will be returned from the backend. You can use SKIP or GOTO on
the local cursor that VFP stores the results in.
Here is an example of using a parameterized view on a states table. The
same concept can be applied to a remote view but this may be easier to follow:
CREATE VIEW v_states AS SELECT * FROM states WHERE st_code = ?lcState
lcState = "KS"
USE v_states && view is for KS
lcState = "TX"
REQUERY('v_states') && now view only shows TX
>That sounds GOOD, Thanks.
>
>Is it possible to have a view that opens only the first record and then in my program use skip 1 to go to next? That may not work since I do not have any key data, just a record number and I am not sure is SQL will recognize GOTO 1?????
>
>
>THANKS
>Joel
>Houston, TX
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