Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>In a grid which is bound on a view, I need to check a few records to be printed. The view is having a field just for the purpose of holding a checkbox for the selected records to be printed. So far so good, I can select a few record. Now, I need to print only those selected. If I do a SELECT, it won't grab those records because the SELECT does not work on buffering. I can't also save the grid as this is not an updatable field. Any idea?
can't you just do...
report form MyReport for checkbox
If the view is not the full view you need to print, you can build an array with the records that are checked...
x = 0
scan for checkbox
x = x+ 1
dime aToPrint[x]
aToPrint[x] = v_theview.idfield
endscan
Then... open your report environment and I think you can do something like...
report form MyReport for ascan(file.id,aToPrint)
The basic info is that you can use xBase commands against the view and it will use the buffered curval() of the fields... but, as you said, if you do a select again, it looks at the table.
BOb
Précédent
Suivant
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