This is my first Web Builder (version 1.03 build 1) application that I am trying out as my learning process.

It is a single form that contains the entry of three fields into a DBISAM dataset - plus a grid to view the records.

When I run the project, I get the following error message:

"Dataset load response error: Missing table name
Line: 5331"

When I view the myproj.js (javascript) I see the following:

webdata_tdataset.$p.doloaderror = function(errormsg)
{that contains a few lines, then Line 5331:}
 throw new Error(errormsg)

The above function appears to be called from:
webdata_tdataset.$p.loadrows = function(rowdata, append)

Not knowing how to run javascript in a debug motion, I would prefer to know why such an error message occurs.  


In the form OnCreate procedure I have the statements:

 Showmessage('Database to get opened hopefully');
 Database.Load(PicList);

but not even the first command appears to work before the error message appears.


When I use the DataSet Manager, the Test Connection button on the Connection Properties tab page gets the "Test connection was successful" message, but when I then go to the Preview tab page, I get the message "Dataset open error: Missing table name".

The DataSetName and Name Properties have values in the TDataSet object.

What else do I need to do and how to do it?

Many thanks,
James D.

Where are you getting your data from, are you using the EWB server?

Chris Holland
[Team Elevate]

On 26/01/2014 08:27, James D. Duff wrote:
> This is my first Web Builder (version 1.03 build 1) application that I am trying out as my learning process.
>
> It is a single form that contains the entry of three fields into a DBISAM dataset - plus a grid to view the records.
>
> When I run the project, I get the following error message:
>
> "Dataset load response error: Missing table name
>   Line: 5331"
>
> When I view the myproj.js (javascript) I see the following:
>
> webdata_tdataset.$p.doloaderror = function(errormsg)
> {that contains a few lines, then Line 5331:}
>    throw new Error(errormsg)
>
> The above function appears to be called from:
> webdata_tdataset.$p.loadrows = function(rowdata, append)
>
> Not knowing how to run javascript in a debug motion, I would prefer to know why such an error message occurs.
>
>
> In the form OnCreate procedure I have the statements:
>
>    Showmessage('Database to get opened hopefully');
>    Database.Load(PicList);
>
> but not even the first command appears to work before the error message appears.
>
>
> When I use the DataSet Manager, the Test Connection button on the Connection Properties tab page gets the "Test connection was successful" message, but when I then go to the Preview tab page, I get the message "Dataset open error: Missing table name".
>
> The DataSetName and Name Properties have values in the TDataSet object.
>
> What else do I need to do and how to do it?
>
> Many thanks,
> James D.
>

James,

<< When I use the DataSet Manager, the Test Connection button on the
Connection Properties tab page gets the "Test connection was successful"
message, but when I then go to the Preview tab page, I get the message
"Dataset open error: Missing table name".  >>

Did you define the dataset in the dataset manager as a table or query ?  If
a table, did you select a table name from the list of tables, and if a
query, did you input a syntactically-correct SQL SELECT statement ?

Tim Young
Elevate Software
www.elevatesoft.com

Hi Chris and Tim.

Thank you for your responses and questions.

I have simply set up a single table with three fields, not a query, as a TDataSet without having referred to the setting up of the Web Server in the help files. The main reason for this is that I did not see any such server references/links in the sample projects provided.

1.  Now that I have started to read the web server help items, I have attempted to start the EWB server.

1.a  This has been run via the CMD "ewbsrvr.exe /install" as stated in the Help file, but the following error message was received:
 'ewbsrvr.exe' is not recognized as an internal or external command,
 operable program or batch file.

1.b  Then running the CMD "net start ewbsrvr", this message appears:
 The service name is invalid.

Today I installed EWB Ver 1.0.3 build 3, and have restarted Windows.

2. Whenever I attempt to open an example project, eg 'masterdetail', I get the following error message that did not happen with the earlier ver 1.0.1:
 Unexpected error while loading the project theme:
 Theme Modern not found
 the project theme will revert to the Default theme

Then, when trying to run the project, this message comes up, no doubt because I do not have the server running:
 Dataset load response error. Resource /datasets not found.

3.  When the sample project 'masterdetail' is opened, the View/Dataset Manager shows the single table used within my trial project that is not opened, and not the multiple tables used within 'masterdetail'?

Whilst I am just trying to learn the EWB on a part time basis, I have now realised that I need to explore the help file more deeply to learn about the underlying structure - a bit more complex than Delphi / DBISAM ;-( - but still need to pass on these messages as well.

Many thanks for your support.

James,

<< I have simply set up a single table with three fields, not a query, as a
TDataSet without having referred to the setting up of the Web Server in the
help files. The main reason for this is that I did not see any such server
references/links in the sample projects provided. >>

You don't need the EWB Web Server for any of this, so skip that for now.  It
will just add another layer of complexity that you don't need right now.

<< 2. Whenever I attempt to open an example project, eg 'masterdetail', I
get the following error message that did not happen with the earlier ver
1.0.1:

Unexpected error while loading the project theme:
 Theme Modern not found
 the project theme will revert to the Default theme >>

Did you reinstall the example applications via the Help..Install Example
Applications link ?

<< Then, when trying to run the project, this message comes up, no doubt
because I do not have the server running:
 Dataset load response error. Resource /datasets not found. >>

No, this is because you're using older versions of the example applications.
The example applications have all changed, so you need to make sure to
reinstall the example applications using 1.03.

<< 3.  When the sample project 'masterdetail' is opened, the View/Dataset
Manager shows the single table used within my trial project that is not
opened, and not the multiple tables used within 'masterdetail'? >>

Same issue.

As to your original issue, which has gotten lost a little here.  You still
didn't answer the second part of my original question:

"If a table, did you select a table name from the list of tables, and if a
query, did you input a syntactically-correct SQL SELECT statement ?"

And again, this is in the DataSet Manager.  Forget about the TDataSet
component on your form for now.  In fact, just delete it.  If you define the
dataset correctly in the DataSet Manager, you should be able to just simply
drag the dataset from the DataSet Manager and drop it on your form and
you'll be all set.

Tim Young
Elevate Software
www.elevatesoft.com

<<Did you reinstall the example applications via the Help..Install Example Applications link ? >>

A.  Yes, and the error message has gone.

<<No, this is because you're using older versions of the example applications.  The example applications have all changed, so you need to make sure to reinstall the example applications using 1.03.>>

A. Example applications re-installed, and error message gone.


<<As to your original issue, which has gotten lost a little here.  You still didn't answer the second part of my original question:
"If a table, did you select a table name from the list of tables, and if a query, did you input a syntactically-correct SQL SELECT statement ?"  >>

A. I selected the Table option.
Q. Could not select a table name from the list of tables as there were no entries in the DS Manager/Row Source tab/Table dropdown list.

<<And again, this is in the DataSet Manager.  Forget about the TDataSet component on your form for now.  In fact, just delete it.  If you define the dataset correctly in the DataSet Manager, you should be able to just simply
drag the dataset from the DataSet Manager and drop it on your form and you'll be all set. >>

A. I have done what you suggested, but:
Q. How does one save the dataset as a DBISAM .tbl etc (into the sub-folder identified as the DatabaseName)?  The only thing I could see was the 'Save the columns to a file' icon in the DataSet Columns Editor, but the saved file type was a .json.
  
Many thanks,
James D. Duff

Hi Tim.

PS.  I have created a DBISAM table using the Database System Utility, and finally have the program working.  Is this the way one needs to go?

Kind regards,
JDD.

James,

<< Q. Could not select a table name from the list of tables as there were no
entries in the DS Manager/Row Source tab/Table dropdown list. >>

This is because your DatabaseName property on the Connection Properties page
isn't set to a database directory where any valid DBISAM tables exist.
Change that property to a "good" database directory, and then you'll see a
list of the tables in the database and will be able to select one from the
list.

<< Q. How does one save the dataset as a DBISAM .tbl etc (into the
sub-folder identified as the DatabaseName)?  The only thing I could see was
the 'Save the columns to a file' icon in the DataSet Columns Editor, but the
saved file type was a .json. >>

You're not creating a DBISAM table in the DataSet Manager - you're simply
*pointing* to one that already exists.  You still have to use the Database
System Utility (or your own code) to create the actual DBISAM tables that
you'll be using.  Think of the DataSet Manager in the same way as the ODBC
Administrator - it just manages data sources that reference locations where
databases already (should) exist.

Tim Young
Elevate Software
www.elevatesoft.com

James,

<< PS.  I have created a DBISAM table using the Database System Utility, and
finally have the program working.  Is this the way one needs to go? >>

Yep.

Tim Young
Elevate Software
www.elevatesoft.com