|
Home > Archive > dBASE Bugs > November 2006 > Grid looses data when datalinked to s MSSQL table
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]
| Author |
Grid looses data when datalinked to s MSSQL table
|
|
| Robert Bravery 2006-11-09, 5:31 am |
| HI all,
I have set up a grid, datalinked to a sql query. The sql statement is a
simple select with a order by clause.
WHen changing some of the properties in the grid, like columns, the data
dissapears. As soon as I take the order by clause out, the data is visible
again.
THis s a real pain, and is a major problem with the product seeing that all
database would normally use the order by clause
Thanks
RObert
| |
| kathy kolosky 2006-11-09, 7:21 pm |
| Hi Robert. Looks like this started in b1735. For some reason the grid is
navigating past the end of the rowset.
When the form is running you can see the data by navigating to the first
row. But, obviously when designing you
cannot.
I submitted this as QAID 6114.
Thanks, Kathy
QA
dBI
"Robert Bravery" <me@u.com> wrote in message
news:iR77X4%23AHHA.1140@news-server...
> HI all,
>
> I have set up a grid, datalinked to a sql query. The sql statement is a
> simple select with a order by clause.
> WHen changing some of the properties in the grid, like columns, the data
> dissapears. As soon as I take the order by clause out, the data is visible
> again.
>
> THis s a real pain, and is a major problem with the product seeing that
> all
> database would normally use the order by clause
>
> Thanks
> RObert
>
>
>
| |
| Robert Bravery 2006-11-09, 7:21 pm |
| Hi Kathy,
Well I suppose so. Problem is that I am creating a custom dropdownbox, where
there is no way of manually navigating to the first row of the rowset. So
yes, if you have navigation controls, then I see that it does work.
Thanks
Robert
"kathy kolosky" <kkolosky@databi.com> wrote in message
news:EJ9uw2ABHHA.2044@news-server...
> Hi Robert. Looks like this started in b1735. For some reason the grid is
> navigating past the end of the rowset.
> When the form is running you can see the data by navigating to the first
> row. But, obviously when designing you
> cannot.
> I submitted this as QAID 6114.
>
> Thanks, Kathy
> QA
> dBI
>
>
> "Robert Bravery" <me@u.com> wrote in message
> news:iR77X4%23AHHA.1140@news-server...
visible[color=darkre
d]
>
>
|
|
|
|
|