>Hi Chen !
>Do you know if there is a solution to let more or less our application unchanged. We are using almost exclusively views. This Select Into Cursor will it work with a view through ODBC ?
>Is there any FAQ/Doc about those commands to use/not use with ODBC ?
You don't actually 'select into cursor' with a remote view, the remote view IS the cursor. The remote view usually stores the SQL that you want to use to create the view.
You can create views manually using create remote view with select ...
Then you need to use a bunch of cursorsetprop() commands to get the view to be updateable... alot easier to do that stuff in the view designer.
Then, in the view designer you would create view parameters. A view paramamter is basically a variable into which you send data.
So, lets say you have a customer maintenance screen... you might create a remote view in the view designer from your customer table called rv_customers.
Then in the filter section of the remote view you might do something like...
customers.custno == ?vp_custid
Now, in your form, you promt for the customers id, and put the value into vp_custid and requery the view. Now the person can edit the info, or whatever, and you use tableupdate() to save back to the back end.
BOb
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