Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Data entry screens with parameterized views on local data. How?
0 views
Skip to first unread message
Richard Marin
Jun 10, 1999, 3:00:00 AM6/10/99
to
I want to know, how to create data entry screens with parameterized
views on local data. This is the goal. The user enters a date. Then the
view locate all records that match that date.
views on local data. This is the goal. The user enters a date. Then the
view locate all records that match that date.
My problem. When ever I try this, the data populates a grid. Also, it
does not populate the texboxes on the form.
Anders Altberg
Jun 11, 1999, 3:00:00 AM6/11/99
to
A SELECT query returns the result as a browse window unless you add INTO
CURSOR xx.
A view is defined with CREATE VIEW xx AS SELECT <select statement>. The
view can be dropped on a form to create a grid but you can also set up
textboxes with the view's column as ControlSource.
As an example:
CREATE VIEW xx AS SELECT * FROM Mytable WHERE xx.date=?ldDate
In the Valid event of the textbox where the use types a date :
* Function Valid
IF NOT EMPTY(this.value)
ldDate=This.Value
REQUERY('xx')
Thisform.Refresh()
ENDIF
CURSOR xx.
A view is defined with CREATE VIEW xx AS SELECT <select statement>. The
view can be dropped on a form to create a grid but you can also set up
textboxes with the view's column as ControlSource.
As an example:
CREATE VIEW xx AS SELECT * FROM Mytable WHERE xx.date=?ldDate
In the Valid event of the textbox where the use types a date :
* Function Valid
IF NOT EMPTY(this.value)
ldDate=This.Value
REQUERY('xx')
Thisform.Refresh()
ENDIF
-Anders
Richard Marin <rich...@earthlink.net> wrote in message
news:37607ACD...@earthlink.net...
0 new messages