| Author |
JANUS GRID POWERCOBOL
|
|
| ramzenit 2005-12-11, 3:55 am |
| Has anyone had any experience with this control.
I find a sample in powercobol to popolate the grid from a query on
databse.
I have try to popolate the grid from a query, but is non work.
My code is
MOVE "SELECT * FROM dbo.CG44_CLIFOR" TO "RecordSource" OF
GRIDEX1.
but the grid is empty.
The same query insert in the recordsource of control form work fine.
Any help with this will be much appreciated.
Thanks
Ramzenit
| |
| Michael Mattias 2005-12-11, 6:55 pm |
| "ramzenit" <mbazan@tin.it> wrote in message
news:1134293701.788557.47510@g44g2000cwa.googlegroups.com...
> Has anyone had any experience with this control.
I can't help you with this, but I would like to take this ooportunity to
thank you profusely for posting a COBOL-related question.
MCM
| |
| Frederico Fonseca 2005-12-11, 6:55 pm |
| On 11 Dec 2005 01:35:01 -0800, "ramzenit" <mbazan@tin.it> wrote:
>Has anyone had any experience with this control.
>
>I find a sample in powercobol to popolate the grid from a query on
>databse.
>
>I have try to popolate the grid from a query, but is non work.
>
>My code is
>
> MOVE "SELECT * FROM dbo.CG44_CLIFOR" TO "RecordSource" OF
>GRIDEX1.
>
>but the grid is empty.
>
>The same query insert in the recordsource of control form work fine.
>
>
>Any help with this will be much appreciated.
This is a common error people do.
the way things work when you enter data on Design Mode is not the same
as when you enter on runtime mode.
If you look at the help files supplied by Janus, and more specifically
at the examples supplied for the recordsource property you would
notice that you need to do more than just to set the recordsource
property to your SQL statement.
Try adding
INVOKE gridex1 "Refresh"
INVOKE gridex1 "Rebind"
to yor code after the population of the recordsource property.
Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com
| |
| Alistair 2005-12-11, 6:55 pm |
|
ramzenit wrote:
> Has anyone had any experience with this control.
>
> I find a sample in powercobol to popolate the grid from a query on
> databse.
>
> I have try to popolate the grid from a query, but is non work.
>
> My code is
>
> MOVE "SELECT * FROM dbo.CG44_CLIFOR" TO "RecordSource" OF
> GRIDEX1.
>
> but the grid is empty.
>
> The same query insert in the recordsource of control form work fine.
>
>
> Any help with this will be much appreciated.
>
>
> Thanks
>
> Ramzenit
Curiousity killed the cat, but satisfaction brought it back, so:
Why is this topic headed with the name Janus. I ask only because I have
recently become interested in Powercobol after reading "Cobol
Unleashed", a book of which Judson wrote three chapters. Thanks Judson.
| |
| ramzenit 2005-12-11, 6:55 pm |
| Thanks for your help Federico.
I have adding the property Refresh and Rebind at my code and all works
fine.
Ramzenit
| |
| Frederico Fonseca 2005-12-11, 6:55 pm |
| On 11 Dec 2005 08:47:57 -0800, "Alistair"
<alistair@ld50macca.demon.co.uk> wrote:
>
>ramzenit wrote:
>
>
>Curiousity killed the cat, but satisfaction brought it back, so:
>
>Why is this topic headed with the name Janus. I ask only because I have
>recently become interested in Powercobol after reading "Cobol
>Unleashed", a book of which Judson wrote three chapters. Thanks Judson.
from the company name that makes the specific control being used.
http://www.janusys.com/controls/
Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com
| |
| James J. Gavan 2005-12-11, 9:55 pm |
| Michael Mattias wrote:
> "ramzenit" <mbazan@tin.it> wrote in message
> news:1134293701.788557.47510@g44g2000cwa.googlegroups.com...
>
>
>
> I can't help you with this, but I would like to take this ooportunity to
> thank you profusely for posting a COBOL-related question.
>
> MCM
And I assume you would have jumped over the moon if it had been BASIC
related ?
Jimmy
| |
| Alistair 2005-12-13, 6:55 pm |
|
Frederico Fonseca wrote:
> On 11 Dec 2005 08:47:57 -0800, "Alistair"
> <alistair@ld50macca.demon.co.uk> wrote:
>
> from the company name that makes the specific control being used.
>
> http://www.janusys.com/controls/
>
>
>
> Frederico Fonseca
> ema il: frederico_fonseca at syssoft-int.com
Thanks, Frederico.
|
|
|
|