It's also worth noting that Tim will likely chime in tomorrow afternoon (UK time) - so don't be too hasty until then

squiffy,

Thank you for your reply and help

i am not a great programmer, just learning and i just want to learn basic

i use Dbisam, so only want to show some data and keep it simple as my first steps
my thoughts were ewbsrv and easy to use and deploy

once i learn the basic then i can go to stage 2

thank you for your help and support

Riaz

On 11/8/2015 1:09 PM, Riaz wrote:
> all i want to do, is show some data from my network using my internet and i am struggling with stage 1

As long as your EWB app is on same server as data it should work just fine.

Tim can test the issue on Monday and i have no doubt fix will be out
right away as well.

The cross origin issue just comes into play IF your app and data are
hosted on different servers (this means IPrt combination).

So I'm seeing the same error running the app from IDE and getting to
data hosted by a separate EWB web server instance. If i move it all
together (EWB app basically hosted on that same EWB web server or both
in IDE) then all works fine - meaning you can develop still.


> i honestly thought this not would be the issue with EWB 2 hence waited ages thinking there will be a great guide and videos as promised

This is a corner case and i have no doubt will be rapidly fixed.

> i have tried, firefox, chrome and to be honest, it should work on any browser, tried it on my samsung s6 , iphone 6s

This is not a browser issue but browser security limitation coupled with
EWB web server setting the header incorrectly. Again ONLY happens if
your app and data are not from same server.

> sorry for having a moan, just so annoying not been able to get past stage 1, and i really do not want to see the project running in IDE

You can develop - this will run just fine in IDE as long as you host
data from IDE as well (and for later deployment it will run fine from
EWB web server as long as app and data are on same EWB web server).

Make sure IDE built-in web server is running:
- in Dataset manager add a new dataset
> Type DBISAM
> name it : i.e. butts
> set appropriate connection properties (basically same as EWB web
server tab you've already configured).


and then in the app you want to use the default path so comment out the
"database.BaseURL  :=  ..." part

And everytyhing should run fine.

Raul

squiffy wrote:

It's also worth noting that Tim will likely chime in tomorrow afternoon (UK time) - so don't be too hasty until then

Thanks again squiffy, if you don't ask you don't learn

if you could help me with some basic code that would be great, as long as its dbisam database i will be ok

Thank you,
Riaz

On 11/8/2015 1:32 PM, Raul wrote:
> You can develop - this will run just fine in IDE as long as you host
> data from IDE as well (and for later deployment it will run fine from
> EWB web server as long as app and data are on same EWB web server).
>

Give me 20 min i can put some steps together and post here on how to get
going with basic DBISAM table access - stay tuned ...

Raul

On 11/8/2015 1:35 PM, Raul wrote:
> On 11/8/2015 1:32 PM, Raul wrote:
>> You can develop - this will run just fine in IDE as long as you host
>> data from IDE as well (and for later deployment it will run fine from
>> EWB web server as long as app and data are on same EWB web server).

Here are basic steps to get started with DBISAM tables and use them in
EWB2 app.

Setup:

I have a DBISAM database at "D:\temp\dbisam\db1" and for this will
access just 1 table called "Customers" (it has existing data)

I will do a new EWB2 project but steps apply to existing as well (jujst
skip new project and such parts)

1. Start EWB2
> make sure dataset mnanager is visible - if not View menu-> Dataset
Manager
> make sure built-in web server is running

2. in dataset manager click the Add Dataset button (one with green arrow)
> Type : DBISAM
> Name : Customers
> Connection Properties -> Database Name : D:\temp\dbisam\db1
> Row Source -> Table : Customers
> Preview should show you table data
> Close dataset manager add window

3. File -> New ->  Project
> Visual Proejct with Form Support
> base it on TForm (default)
> should open new form window

4. Drag the "Customers" dataset (in dataset manager) onto the form
> this should create a dataset with Datasename "Customers" and also
populate the Columns properly from table

5. Drop a TGrid on the form (Standard tab of components)

6. assign grid Dataset to be Customers
> this should populate grid headers with proper column names also

7. save everything (project and unit etc)

8. select form and add a "OnCreate" event handler in under Events

9. just add "Database.Loadrows(Customers);" as code so it should look like

procedure TForm1.Form1Create(Sender: TObject);
begin
   Database.Loadrows(Customers);
end;


10. compile and run a project - app should run in IDE and grid should
get populated with data.


Raul

Hi Raul,

thank you for the step by step guide, i had manage to do this in IDE

i wanted to run the project1.html without the IDE and this is where i am stuck

with IDE its ok, but without IDE its not, maybe fault with the ewbsrvr  causing the error or my network settings

if you try this and enter value 30 as ticket http://www.epos4bars.com/fair/dryclean.html

i did the above with ewb1 and that worked

not sure if anyone has this working with ewbsrv without ide

many thanks Raul for quick replied, i really appreciate all your help

Riaz

That worked for me (well, it fetched a result). Does entering 30 work for you or fail?

squiffy wrote:

That worked for me (well, it fetched a result). Does entering 30 work for you or fail?


i have 30,31,32,24  tickets they all work for me, this is ewb1 running

my problem is ewb2

Riaz

i have 30,31,32,33,34  tickets they all work for me, this is ewb1 running

my problem is ewb2 Frown

Riaz