|
Home > Archive > Programming with dBASE > October 2005 > ROWSET IN GRID
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Dan Anderson 2005-10-11, 7:27 am |
| db+ I wish object oriented programming was as predictible as x-base. I
have a form with a grid. I have set the database, the rowset and the
indexname; but, I can't get it to display the data. If I open in the form
in edit mode and change the indexname a couple of times it will finally
display the right data set. However if I run the form it the grid is always
empty. I can use x-base commands and "Use" the table with the same index
and get the right dataset every time. I need to open different
instantiations of the rowset with different indexnames on four different
pages. But before I can do that I have to get it to work right one time at
least. I have done this hundreds of times before and it worked. What can I
be doing wrong?
The index is a little complicated. I scoped it for " upper(trim(status))=
'PENDING' "
--
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101
| |
|
| HI,
Is this linked to a backend server.
Have you tried issueng a rowset.first()
Robert
"Dan Anderson" <andersond@ubinc.com> wrote in message
news:DvMf08YzFHA.352@news-server...
> db+ I wish object oriented programming was as predictible as x-base. I
> have a form with a grid. I have set the database, the rowset and the
> indexname; but, I can't get it to display the data. If I open in the form
> in edit mode and change the indexname a couple of times it will finally
> display the right data set. However if I run the form it the grid is
always
> empty. I can use x-base commands and "Use" the table with the same index
> and get the right dataset every time. I need to open different
> instantiations of the rowset with different indexnames on four different
> pages. But before I can do that I have to get it to work right one time
at
> least. I have done this hundreds of times before and it worked. What can
I
> be doing wrong?
>
> The index is a little complicated. I scoped it for "
upper(trim(status))=
> 'PENDING' "
>
> --
> Dan Anderson
> UBI Processing Dept.
> andersond@ubinc.com
> 800-444-4824 ext 101
>
>
| |
| Martin Lambert 2005-10-11, 7:27 am |
| Are you sure that the rowset is active ?
"Dan Anderson" <andersond@ubinc.com> a écrit dans le message de news:
DvMf08YzFHA.352@news-server...
> db+ I wish object oriented programming was as predictible as x-base. I
> have a form with a grid. I have set the database, the rowset and the
> indexname; but, I can't get it to display the data. If I open in the form
> in edit mode and change the indexname a couple of times it will finally
> display the right data set. However if I run the form it the grid is
> always empty. I can use x-base commands and "Use" the table with the same
> index and get the right dataset every time. I need to open different
> instantiations of the rowset with different indexnames on four different
> pages. But before I can do that I have to get it to work right one time
> at least. I have done this hundreds of times before and it worked. What
> can I be doing wrong?
>
> The index is a little complicated. I scoped it for "
> upper(trim(status))=
'PENDING' "
>
> --
> Dan Anderson
> UBI Processing Dept.
> andersond@ubinc.com
> 800-444-4824 ext 101
>
| |
| Ivar B. Jessen 2005-10-11, 7:27 am |
| On Mon, 10 Oct 2005 07:34:16 -0400, "Dan Anderson" <andersond@ubinc.com>
wrote:
>The index is a little complicated. I scoped it for " upper(trim(status))=
>'PENDING' "
I don't know what the problem is, but you should not use TRIM() in an
index. See the OLH on INDEX. Especially the follwing paragraph.
"Warning!
Do not create an index where the length of the index key expression varies
from record to record. Specifically, do not use TRIM(_) or LTRIM(_) to
remove blanks from strings unless you compensate by adding enough spaces to
make sure the index key values are all the same length. The - operator
concatenates strings while rearranging trailing blanks. Varied key lengths
may cause corrupted indexes".
Ivar B. Jessen
| |
| Marilyn Price 2005-10-11, 7:27 am |
| In article <DvMf08YzFHA.352@news-server>, andersond@ubinc.com says...
> db+ I wish object oriented programming was as predictible as x-base. I
> have a form with a grid. I have set the database, the rowset and the
> indexname; but, I can't get it to display the data. If I open in the form
> in edit mode and change the indexname a couple of times it will finally
> display the right data set. However if I run the form it the grid is always
> empty.
How about posting a small turnkey example of how you're defining the
rowset and how you're connecting it to the grid. Perhaps an answer will
become apparent.
--
Marilyn Price
M. P. Data
|
|
|
|
|