grid display using program - grid does not show

Jon Toomsen · February 01, 2024, 07:49:51 PM

<!DOCTYPE html>
<html>
<head>
</head>
<body>
[ttl]Grid[/ttl] 
[grid MyGrid program="myprog.pxp;makegrid" size=auto/20 ]
[col Source=ItemCode$ ttl="ItemCode" width=30 ]
[col Source=ItemName$ ttl="Name" width=50]
[col Source=ItemType$ ttl="Type" width=2]
[/grid]
</body>
</html>

! myprog.pxp
MAKEGRID:
OPEN (HFN,IOL=GRIDIOL)"*memory*"
LET MYGRID=LFO
SELECT * FROM INTERNETITEM
WRITE (MYGRID)
NEXT RECORD
EXIT
GRIDIOL:IOLIST ITEMCODE$,ITEMNAME$,ITEMTYPE$
!

Devon Austen · February 02, 2024, 09:10:03 AM

Hi Jon,

When debugging a Webster issue the first step is to hover over the red highlighted section on the page. The tool tip will give you error information which will help you figure out your issue.

I believe your issue is that your page does not have a [form] and the grid needs to be in a [form].

You also need to add

ENTER MYGRID

right under the MAKEGRID: line

This is how the grid program can pass back the handle to the grid memory file.

So try this:

<!DOCTYPE html>
<html>
<head>
</head>
<body>
[ttl]Grid[/ttl] 
[form]
[grid MyGrid program="myprog.pxp;makegrid" size=auto/20 ]
[col Source=ItemCode$ ttl="ItemCode" width=30 ]
[col Source=ItemName$ ttl="Name" width=50]
[col Source=ItemType$ ttl="Type" width=2]
[/grid]
[/form]
</body>
</html>

! myprog.pxp
MAKEGRID:
ENTER MYGRID
OPEN (HFN,IOL=GRIDIOL)"*memory*"
LET MYGRID=LFO
SELECT * FROM INTERNETITEM
WRITE (MYGRID)
NEXT RECORD
EXIT
GRIDIOL:IOLIST ITEMCODE$,ITEMNAME$,ITEMTYPE$

Normally you would have a program= in the [form] to specify the program to run when form is submitted and that would handle any events on the page.

For information on the use of the form see here:
https://manual.pvxplus.com?Webster/Webster%20Application%20Design.htm

For the need for the ENTER you can see the program= short code documentation here: https://manual.pvxplus.com?Webster/Short%20Code%20Options.htm

It looks like we need to update the example on the Using Grids in Webster+ documentation page to include the ENTER statement as that is missing.

Jon Toomsen · February 02, 2024, 02:10:05 PM

[form] was needed now a shell of the grid is shown.

Now I have internetitem not found in dictionary.
have tried both ways - program= and the execute statement

I have an application library under the prog folder.
The query for internetitem works.

.

Devon Austen · February 02, 2024, 02:54:40 PM

Is the channel number for a open file in the variable INTERNETITEM of is the name of the file INTERNETITEM. If that is the name of the file you are just missing quotes in the select statement

i.e.

SELECT * FROM "INTERNETITEM"

Jon Toomsen · February 02, 2024, 03:19:15 PM

added quotes - it is not a channel no ( was a typo earlier )

Jon Toomsen · February 10, 2024, 10:29:02 AM

Get the shell of the grid - column titles but the grid is not populated.
Nothing in red is displayed

Devon Austen · February 12, 2024, 08:05:38 AM

Does the file INTERNETITEM have records in it?

Does the fields defined for INTERNETITEM match the IOL used in your program?

Mike King · February 12, 2024, 10:59:36 AM

I tried the following with no problem:

HTML file demo.html (placed in the pages directory):

Code Select

<!DOCTYPE html>
<html>
<head>
</head>
<body>
[ttl]Grid[/ttl]<br>
[form]
[grid MyGrid program="myprog;makegrid" size=auto/20 ]
[col Source=ItemCode$ ttl="ItemCode" width=30 ]
[col Source=ItemName$ ttl="Name" width=50]
[col Source=ItemType$ ttl="Type" width=5]
[/grid]
[/form]
</body>
</html>

Program file "myprog" (in the prog directory)

Code Select

 ! myprog (placed in the prog directory)
MAKEGRID:
  enter MYGRID
  open (hfn,iol=GRIDIOL)"*memory*"
  MYGRID=lfo
  while 1
  read data iol=gridiol,end=*break
  write (MYGRID)
  wend 
 ! 
  exit 
 ! 
  data "item1","First Item","A"
  data "item2","Second Item","B"
  data "item3","Third Item","A"
  data "item4","Last Item","C"
!
 GRIDIOL:  iolist ITEMCODE$,ITEMNAME$,ITEMTYPE$

Rather than read from a file I used in-code DATA values to make sure there was data present.

Jon Toomsen · February 12, 2024, 02:09:41 PM

this is what I get using html and prog - see attached

Jon Toomsen · February 12, 2024, 04:12:41 PM

html and program
[ttl]Grid[/ttl]
[form]
[grid MyGrid program="myprog;makegrid" size=auto/20 ]
[col Source=ItemCode$ ttl="ItemCode" width=30 ]
[col Source=ItemName$ ttl="Name" width=50]
[col Source=ItemType$ ttl="Type" width=5]
[/grid]
[/form]

! myprog (placed in the prog directory)
MAKEGRID:
enter MYGRID
open (hfn,iol=GRIDIOL)"*memory*"
let MYGRID=lfo
while 1
read data iol=GRIDIOL,end=*break
write (MYGRID)
wend
!
exit
!
data "item1","First Item","A"
data "item2","Second Item","B"
data "item3","Third Item","A"
data "item4","Last Item","C"
!
GRIDIOL:
iolist ITEMCODE$,ITEMNAME$,ITEMTYPE$
!