Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread At least one column must be defined for "CustomersDataset" dataset
Fri, Aug 23 2013 6:37 PMPermanent Link

Mike

consultant

Hello, sorry im having a little trouble getting off the ground here.

a few questions.

I created a new http endpoint in my web server called CustomersEWB.  I
check the method param and either return columns or rows based on the
method.

1. When i call Database.Load(customerDataSet), i get the error in the
title of this post.  I can see the HTTP get being successfully called
for rows.  I have defined the matching columns in both the data set and
grid at design time.  Can someone tell me why im getting this error.

2. Its not clear to me how I load the columns at run time.  I see the
LoadColumns method, but it takes a columnData string as a param.  its
not clear to me where im getting that string from.

Thanks for the help.
Fri, Aug 23 2013 7:37 PMPermanent Link

Mike

consultant

On 8/23/13 6:37 PM, Mike Margerum wrote:
> Hello, sorry im having a little trouble getting off the ground here.
>
> a few questions.
>
> I created a new http endpoint in my web server called CustomersEWB.  I
> check the method param and either return columns or rows based on the
> method.
>
> 1. When i call Database.Load(customerDataSet), i get the error in the
> title of this post.  I can see the HTTP get being successfully called
> for rows.  I have defined the matching columns in both the data set and
> grid at design time.  Can someone tell me why im getting this error.
>

I loaded the data set defs from a file and it just started working.
this problem solved.  Other issue is im running my own web server
locally and its not clear to me how i can run the app from the ide
directly in my web server.  is my only option to deploy?

> 2. Its not clear to me how I load the columns at run time.  I see the
> LoadColumns method, but it takes a columnData string as a param.  its
> not clear to me where im getting that string from.
>


I 'm still confused by how/when the "columns" param ever gets on my http
server.
Mon, Aug 26 2013 11:24 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mike,

<< 1. When i call Database.Load(customerDataSet), i get the error in the
title of this post.  I can see the HTTP get being successfully called for
rows.  I have defined the matching columns in both the data set and grid at
design time.  Can someone tell me why im getting this error. >>

I would have to see your project to be sure, but in some way the
customerDataSet instance does not have any columns defined for it.  Either
the columns aren't there at design-time or they are being cleared at
run-time.

<< 2. Its not clear to me how I load the columns at run time.  I see the
LoadColumns method, but it takes a columnData string as a param.  its not
clear to me where im getting that string from. >>

The LoadColumns and LoadRows method deal entirely in JSON in the format
detailed here:

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=JSON_Reference

This means that you can load the JSON for the columns from anywhere that you
can get a string - local storage, a cookie, via a TServerRequest response, a
string literal, etc.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com


Mon, Aug 26 2013 11:32 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mike,

<< I loaded the data set defs from a file and it just started working. this
problem solved.  Other issue is im running my own web server locally and its
not clear to me how i can run the app from the ide directly in my web
server.  is my only option to deploy? >>

1) Go to Environment/Options/Web Servers.  Type in the following:

Name: Mike's Local Web Server
Description: My local web server
URL: http://localhost
Port: 80 (or whatever you need here for your web server)

Then click on Register.  This will add the web server as a selectable web
server in the IDE.  Click on OK to exit the Environment Options dialog.

2) On the main toolbar for the IDE, select this newly-added web server as
your default web server via the combo box on the right.

3) With your project loaded, go to Project/Options/Deployment.  Set up your
deployment as copy/FTP as appropriate, but then be sure to check the Deploy
on Run check box.

After you do the above, whenever you Run your application in the IDE, EWB
will automatically deploy it and run it against your local web server.  That
way you're always using the latest code and are testing directly against the
web server that matches your production deployment.

<< I 'm still confused by how/when the "columns" param ever gets on my http
server. >>

In most cases, it doesn't.  Normally you define the columns at design-time
in your application, and then they are saved with the application and
created automatically when the TDataSet component is created at run-time.
Only in rare cases will you want to have your http server serve up column
definitions for datasets, although it's certainly possible to do and doesn't
require a lot of effort.  I can imagine a case where a dataset is dynamic on
the back-end (government data, etc.) and so its structure needs to be
discoverable/loadable at runtime via the EWB application running in the
browser.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Aug 26 2013 3:33 PMPermanent Link

Mike

consultant

Thanks Tim.  Impressive stuff.  Once you get mobile support and code
completion in there, it will be pure heaven.  I just renewed and am very
happy with the progress.

Please don't sell to Embarcadero.  I don't need another $500 "add on"
pack. Wink
Tue, Aug 27 2013 5:27 AMPermanent Link

Matthew Jones

> Please don't sell to Embarcadero.  I don't need another $500 "add
> on" pack. Wink

Nightmare! I wish I could work out how to get Tim more resources, but EMB would be
the worst option ever.

/Matthew Jones/
Wed, Aug 28 2013 4:16 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mike,

<< Thanks Tim.  Impressive stuff.  Once you get mobile support and code
completion in there, it will be pure heaven.  I just renewed and am very
happy with the progress. >>

I'm in a "delay mode" recently due to having to take a break to work on some
ElevateDB stuff (done now, thankfully).  But, I'm picking up with EWB 2.0
next, so I should have some good stuff ready by the end of the year.  Of
course, some stop-gap stuff like "touch" events, etc. will be coming in EWB
1.x still.

<< Please don't sell to Embarcadero.  I don't need another $500 "add on"
pack. Wink>>

Smile

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Aug 28 2013 6:06 PMPermanent Link

Steve Gill

Avatar

<< Nightmare! I wish I could work out how to get Tim more resources, but EMB would be
the worst option ever.  >>

Unfortunately my EWB resource investment fund (aka lottery) hasn't produced any results yet but I'm still trying. Smile

- Steve
Thu, Aug 29 2013 2:48 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Steve

>Unfortunately my EWB resource investment fund (aka lottery) hasn't produced any results yet but I'm still trying. Smile

I'm still having to use Plan B to fund my existence Frown

Roy
Image