Jim,
You have your main table in a grid not a list view right?
If so grids an listviews have different eeps you can use and grids don't have a
double click eep. If you are looking to print a report when someone
enters/clicks on one of those grid columns then try this...
SET VAR vCurGridColumn TEXT
GETPROPERTY RecievedItemsGrid CurrentColumnName 'vCurGridColumn'
IF vCurGridColumn = 'NeedsSerailNumsEntered' then
--ask if they want to print a report
--if they say yes, print it
endif
clear var vCurGridColumn
If you are going the route I did, and start using list view almost every where;
I adopted a usability practice of one click to select, double click to open
detail form, right click to print
for example in my inventory management system I have 3 list views
1 - inventory items to order
single click refreshes order info for just this item (also hides some
buttons and resets the other list view variables to 0)
double click open inventory item form
2 - item vendor ordering info for selected item (the system allows for multiple
vendors and ordering quantities per item)
single click refreshes vendor po list for just the order info vendor and
displays button to start new PO for vendor
double click opens order info form
3 - open vendor pos for selected ordering info
single click displays the 'add this item to po button'
double click opens po form
right click prints po ticket
Have a Fabulous Day!
Rachael M.
Freelance Developer
www.DragonflyDevelopmentMN.com
----- Original Message -----
From: Jim Belisle
To: RBASE-L Mailing List
Sent: Wednesday, November 19, 2008 1:19 PM
Subject: [RBASE-L] - Re: DBGRID
Rachael,
Now that I have the listview showing my information, is there a 'best' way to
print a report with a double click on a particular column? I would not need to
click on the list view columns but on the main table columns. You have raised
my interest in this setup.
Jim
------------------------------------------------------------------------------
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rachael Malberg
Sent: Wednesday, November 19, 2008 11:32 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: DBGRID
have you looked at using a ListView for the PRODPART table? I do all sorts
of neat stuff using ListViews, it's my favorite 7.6/v8 feature! and if I don't
need to edit data directly in the main form and you want to control data
displayed or create features that allow your user to create their own filters
without knowing a bit of programming, plus allow them to sort the data how they
need it; these are great! and if a ListView record requires some updating, or
display a very detailed information of record, I add a double click eep to open
a edit form to modify or view the data. I also found a form using ListViews
instead of slave tables loads faster.
Have a Fabulous Day!
Rachael M.
Freelance Developer
www.DragonflyDevelopmentMN.com
----- Original Message -----
From: Jim Belisle
To: RBASE-L Mailing List
Sent: Wednesday, November 19, 2008 11:10 AM
Subject: [RBASE-L] - DBGRID
I have made a DBGRID that is connecting my open orders to my available
inventory. The grid is working but I want to enhance it a little. With the
main table I can limit the information based on whether the order has shipped
and the product line.
What I want to do is limit the connecting table information (PRODPART) to
just the parts that will be shipped (not all the parts that make up the
product). There is a column in this table that has either a 'y' or a 'n' for
shipping. Since the driving table does not have this column in it, how would I
limit the rows?
I have read the PDF files and looked at the sample databases but find
nothing about DBgrids to meet this condition. If there is a file with detailed
information about grids, I will be happy to investigate that.
Jim
