Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Check field in a view need to be in SELECT
Message
De
09/04/1999 20:58:33
 
 
À
09/04/1999 20:38:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00207121
Message ID:
00207123
Vues:
12
>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
Fil
Voir

Click here to load this message in the networking platform