Hi,

I have created a cgi stand alone exe that I can call with
http://localhost/test/cgi/jso.exe?method=rows. It gives back a table in JSON
format. That works fine.

Then I try this in my EWB app:

Database.BaseUrl:='http://localhost/test/cgi/jso.exe?method=rows;
tbHolidays.DatasetName:='albums';
Database.Load(tbHolidays);

I have the jso.exe create a log file so I can check the calls. But nothing
happens when I call the above example code. The logfile is not created, so I
assume that jso.exe is not being called. Why is that? What am I missing?

Ronald

Hi Ronald,

Did you set up events for AfterLoad() and OnLoadError() to see if EWB
thinks it got some data back?

Chris Holland
[Team Elevate]

On 02/10/2012 22:17, Ronald wrote:
> Hi,
>
> I have created a cgi stand alone exe that I can call with
> http://localhost/test/cgi/jso.exe?method=rows. It gives back a table in
> JSON format. That works fine.
>
> Then I try this in my EWB app:
>
> Database.BaseUrl:='http://localhost/test/cgi/jso.exe?method=rows;
> tbHolidays.DatasetName:='albums';
> Database.Load(tbHolidays);
>
> I have the jso.exe create a log file so I can check the calls. But
> nothing happens when I call the above example code. The logfile is not
> created, so I assume that jso.exe is not being called. Why is that? What
> am I missing?
>
> Ronald
>
>

Thanks, did not think of that. Now I see what is going wrong.

"Chris Holland"  schreef in bericht
news:ABB4A21A-251B-436F-959D-6FE8738CC0A4@news.elevatesoft.com...

Hi Ronald,

Did you set up events for AfterLoad() and OnLoadError() to see if EWB
thinks it got some data back?

Chris Holland
[Team Elevate]

On 02/10/2012 22:17, Ronald wrote:
> Hi,
>
> I have created a cgi stand alone exe that I can call with
> http://localhost/test/cgi/jso.exe?method=rows. It gives back a table in
> JSON format. That works fine.
>
> Then I try this in my EWB app:
>
> Database.BaseUrl:='http://localhost/test/cgi/jso.exe?method=rows;
> tbHolidays.DatasetName:='albums';
> Database.Load(tbHolidays);
>
> I have the jso.exe create a log file so I can check the calls. But
> nothing happens when I call the above example code. The logfile is not
> created, so I assume that jso.exe is not being called. Why is that? What
> am I missing?
>
> Ronald
>
>

Ronald,

<< Then I try this in my EWB app: >>

The issue is your URL, what you want is this instead:

Database.BaseUrl:='test/cgi';  // Always try to use relative URLs to make
life easier
tbHolidays.DataSetName:='jso.exe';

It looks weird, but it will work.

Tim Young
Elevate Software
www.elevatesoft.com