I have a strange feature in my program when loading one particular dataset.

I have several datasets that when I load them send a request to the
server in the form:

/?method=rows&dataset=Users

which works fine.

But one dataset send the following message:

/datasets?method=rows&dataset=Stock

Why would this one dataset append the /datasets to the URL?

--
Chris Holland
[Team Elevate]

Chris,

<< But one dataset send the following message:

/datasets?method=rows&dataset=Stock

Why would this one dataset append the /datasets to the URL? >>

Did you check the DataSetName for the dataset to make sure that it doesn't
include anything "extra" ?

Tim Young
Elevate Software
www.elevatesoft.com

Yes, just the standard table name.

I even deleted the table from the project and the IDE and recreated it,
still the same.

Chris Holland
[Team Elevate]

On 30/01/2014 12:35, Tim Young [Elevate Software] wrote:
> Chris,
>
> << But one dataset send the following message:
>
> /datasets?method=rows&dataset=Stock
>
> Why would this one dataset append the /datasets to the URL? >>
>
> Did you check the DataSetName for the dataset to make sure that it
> doesn't include anything "extra" ?
>
> Tim Young
> Elevate Software
> www.elevatesoft.com

Chris:

Do you set the Database.BaseURL  ????  If you are you could be doing this to yourself.

in my EWB apps I set it to:

Database.BaseURL := gbURL + '/dataset';

Where the gbURL is a global variable I use for ServerRequests too.

Make sure that you don't end the BaseURL with a slash '/'.

Your are just doing something like this, where ExpCode is a TDataset, and it is failing?

 ExpCode.Close;
 ExpCode.Open;
 ExpCode.Params.Clear;
 DataBase.Load(ExpCode);

Walter

I do set the BaseURL like this:

Database.BaseURL := 'http://localhost:12009';

The strange thing is that I have several tables in my project and they
all work as expected except the Stock table which appends the /datasets
to the call!

I just cannot work out why this one table is different.

Chris Holland
[Team Elevate]

On 30/01/2014 13:09, Walter Matte wrote:
> Chris:
>
> Do you set the Database.BaseURL  ????  If you are you could be doing this to yourself.
>
> in my EWB apps I set it to:
>
> Database.BaseURL := gbURL + '/dataset';
>
> Where the gbURL is a global variable I use for ServerRequests too.
>
> Make sure that you don't end the BaseURL with a slash '/'.
>
> Your are just doing something like this, where ExpCode is a TDataset, and it is failing?
>
>    ExpCode.Close;
>    ExpCode.Open;
>    ExpCode.Params.Clear;
>    DataBase.Load(ExpCode);
>
> Walter
>

Okay, I have found the problem.

I am calling the Database.Load(StockTable) before I set the BaseURL.
With all the other tables the BaseURl gets set first.

Doh!

Chris Holland
[Team Elevate]

On 31/01/2014 08:41, Chris Holland wrote:
> I do set the BaseURL like this:
>
> Database.BaseURL := 'http://localhost:12009';
>
> The strange thing is that I have several tables in my project and they
> all work as expected except the Stock table which appends the /datasets
> to the call!
>
> I just cannot work out why this one table is different.
>
> Chris Holland
> [Team Elevate]
>
> On 30/01/2014 13:09, Walter Matte wrote:
>> Chris:
>>
>> Do you set the Database.BaseURL  ????  If you are you could be doing
>> this to yourself.
>>
>> in my EWB apps I set it to:
>>
>> Database.BaseURL := gbURL + '/dataset';
>>
>> Where the gbURL is a global variable I use for ServerRequests too.
>>
>> Make sure that you don't end the BaseURL with a slash '/'.
>>
>> Your are just doing something like this, where ExpCode is a TDataset,
>> and it is failing?
>>
>>    ExpCode.Close;
>>    ExpCode.Open;
>>    ExpCode.Params.Clear;
>>    DataBase.Load(ExpCode);
>>
>> Walter
>>