Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check field in a view need to be in SELECT
Message
From
09/04/1999 20:58:33
 
 
To
09/04/1999 20:38:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00207121
Message ID:
00207123
Views:
11
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform