Sten-Inge Polland
|
| Posted: 04/14/2007, 9:30 AM |
|
Hi,
I have a grid with a simple sql like
"select turnr, hotellnr, beskrivelse from tur_hotell"
On each row I want to have a listboks. The listbox must dynamically list
values fra another table with "hotellnr" from the grid as parameter from the
different rows in the grid. When I try it only uses the hotellnr from the
first row in the grid for every row in the grid.
Can anyone help me with this.
Sten-Inge
|
|
|
 |
wkempees
|
| Posted: 04/16/2007, 3:14 PM |
|
This is the "right"forum to post your question!
My question to you:
What kind of grid is it, a simple grid displaying records?
Or a EditableGrid?
At the minimum you need to include the row_id to get your listboxes to react
to row data.
But first let us know what kind of grid and what you intend to build.
(Picture maybe?)
Walter
PS the other forum is called Tips and Solutions, that is where you give tips
to others.
"Sten-Inge Polland" <sten-inge@sip-soft.no> schreef in bericht
news:evqvjb$qh7$1@news.codecharge.com...
> Hi,
>
> I have a grid with a simple sql like
> "select turnr, hotellnr, beskrivelse from tur_hotell"
>
> On each row I want to have a listboks. The listbox must dynamically list
> values fra another table with "hotellnr" from the grid as parameter from
> the different rows in the grid. When I try it only uses the hotellnr from
> the first row in the grid for every row in the grid.
>
> Can anyone help me with this.
>
> Sten-Inge
>
|
|
|
|
Sten-Inge Polland
|
| Posted: 04/16/2007, 11:31 PM |
|
Hi,
I have build a simple grid displaying records and then added a column the
user can edit ("romtype")
The grid's SQL as follows:
"select turnr, hotellnr, beskrivelse from tur_hotell"
The values in the listbos field field ("romtype") should be selected with
its own SQL (select romtype from tur_hootell_romtype where hotellnr =
"hotellnr from each row in grid"
Do I have to build an editable grid to get the "row_id" ?
Sten-Inge
"wkempees" <kempe819@planet.nl> skrev i melding
news:f00sgl$612$1@news.codecharge.com...
> This is the "right"forum to post your question!
>
> My question to you:
> What kind of grid is it, a simple grid displaying records?
> Or a EditableGrid?
>
> At the minimum you need to include the row_id to get your listboxes to
> react to row data.
> But first let us know what kind of grid and what you intend to build.
> (Picture maybe?)
>
> Walter
> PS the other forum is called Tips and Solutions, that is where you give
> tips to others.
>
>
>
> "Sten-Inge Polland" <sten-inge@sip-soft.no> schreef in bericht
>news:evqvjb$qh7$1@news.codecharge.com...
>> Hi,
>>
>> I have a grid with a simple sql like
>> "select turnr, hotellnr, beskrivelse from tur_hotell"
>>
>> On each row I want to have a listboks. The listbox must dynamically list
>> values fra another table with "hotellnr" from the grid as parameter from
>> the different rows in the grid. When I try it only uses the hotellnr from
>> the first row in the grid for every row in the grid.
>>
>> Can anyone help me with this.
>>
>> Sten-Inge
>>
>
>
|
|
|
|
wkempees
|
| Posted: 04/17/2007, 1:57 AM |
|
Sten-Inge,
That is what I thought, you have build a grid.
A grid is to display rows, it has no editing capabilities.
Even if your listbox would show the right values, they would not be saved.
So yes youi need at the minimum a RecordForm to do updates to the grid's row
and in that form the listbox you mentioned.
If you go for the editable grid, then you will need your listbox to filter
on the hotellnr of the row it is in.
There is an explanation on rowhandeling in Tips-and-Solutions:
http://forums.codecharge.com/posts.php?post_id=60507
Also (I think) the Examplepack has some samples.
Walter
"Sten-Inge Polland" <sten-inge@sip-soft.no> schreef in bericht
news:f01pkf$ltt$1@news.codecharge.com...
> Hi,
>
> I have build a simple grid displaying records and then added a column the
> user can edit ("romtype")
>
> The grid's SQL as follows:
> "select turnr, hotellnr, beskrivelse from tur_hotell"
>
> The values in the listbos field field ("romtype") should be selected with
> its own SQL (select romtype from tur_hootell_romtype where hotellnr =
> "hotellnr from each row in grid"
>
> Do I have to build an editable grid to get the "row_id" ?
>
> Sten-Inge
>
>
>
> "wkempees" <kempe819@planet.nl> skrev i melding
>news:f00sgl$612$1@news.codecharge.com...
>> This is the "right"forum to post your question!
>>
>> My question to you:
>> What kind of grid is it, a simple grid displaying records?
>> Or a EditableGrid?
>>
>> At the minimum you need to include the row_id to get your listboxes to
>> react to row data.
>> But first let us know what kind of grid and what you intend to build.
>> (Picture maybe?)
>>
>> Walter
>> PS the other forum is called Tips and Solutions, that is where you give
>> tips to others.
>>
>>
>>
>> "Sten-Inge Polland" <sten-inge@sip-soft.no> schreef in bericht
>>news:evqvjb$qh7$1@news.codecharge.com...
>>> Hi,
>>>
>>> I have a grid with a simple sql like
>>> "select turnr, hotellnr, beskrivelse from tur_hotell"
>>>
>>> On each row I want to have a listboks. The listbox must dynamically list
>>> values fra another table with "hotellnr" from the grid as parameter from
>>> the different rows in the grid. When I try it only uses the hotellnr
>>> from the first row in the grid for every row in the grid.
>>>
>>> Can anyone help me with this.
>>>
>>> Sten-Inge
>>>
>>
>>
>
>
|
|
|
|
|
