Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Add all columns / dataset
Fri, Nov 27 2015 8:15 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Hi Tim,

Is it possible to add a function/shortcut to add all columns in a
dataset (like add all fields in delphi)?

Regards,
Hüseyin
Mon, Nov 30 2015 10:56 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

<< Is it possible to add a function/shortcut to add all columns in a dataset (like add all fields in delphi)? >>

You can drag and drop a dataset from the DataSet Manager in the IDE on to a form, and all of the dataset columns will automatically be defined for you.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Nov 30 2015 11:25 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Tim,

How if dataset structure are changed, eg. fields added or removed or you
make changes to query/sql? If I am not wrong dataset in ide does not
reflect changes automatically?

Regards,
Hüseyin

On 30-11-2015 16:56, Tim Young [Elevate Software] wrote:
> << Is it possible to add a function/shortcut to add all columns in a dataset (like add all fields in delphi)? >>
>
> You can drag and drop a dataset from the DataSet Manager in the IDE on to a form, and all of the dataset columns will automatically be defined for you.
>
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Mon, Nov 30 2015 2:58 PMPermanent Link

Walter Matte

Tactical Business Corporation

>>  How if dataset structure are changed, eg. fields added or removed or you
>>  make changes to query/sql? If I am not wrong dataset in ide does not
>>  reflect changes automatically?


No you are correct, it does not do it automatically.

So you either do the matching yourself manually.  Or delete the dataset and drag it over again.

Walter
Mon, Nov 30 2015 5:41 PMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Walter,

Thanks for the input. Deleting the dataset makes events also disappear
(not in code but in the properties of dataset), so I need to click on
events (usually onload event), it's not big thing but could be nice to
remove all and add all fields with one operation Smile

Regards,
Hüseyin


On 30-11-2015 20:58, Walter Matte wrote:
>>>   How if dataset structure are changed, eg. fields added or removed or you
>>>   make changes to query/sql? If I am not wrong dataset in ide does not
>>>   reflect changes automatically?
>
> No you are correct, it does not do it automatically.
>
> So you either do the matching yourself manually.  Or delete the dataset and drag it over again.
>
> Walter
>
Thu, Dec 17 2015 5:30 PMPermanent Link

Trinione

Yes, this is one of the items Tim has promised to work on. Since he does resolve most things I accepted this as a necessary 'evil' for the time being. Smile

It's a bit of a pain, but in the grander scheme I think of the alternatives and just set those properties again (with a wee bit of a smile in that context).
Image