Simple task of listing numbers connected to Initials, but lacking knowledge of syntax to do it.

Hello.

Normally I would have used Firebird to solve the simple task,
but this is not allowed to install on the PC and then
I have to use two unfamiliar components, like listboxes, to solve a
record task instead of data aware components.

The task:
A column of initials is copied into a listbox or something that can
take care of
the list of random Initials.
I e 
KIB
FAH
KLS

Then the program will somehow go through the list in the first listbox
and in
another listbox, that has all the initials in one column and
corresponding numbers in another, show only the rows that correspond
with the list of initials given in the first listbox.

If someone could give a syntax example of such a use of two listboxes,
I would be grateful.

Thanks in advance.

:)
Kai Inge
0
Kai
8/15/2015 12:01:53 PM
embarcadero.delphi.non-tech 5933 articles. 1 followers. Follow

7 Replies
791 Views

Similar Articles

[PageSpeed] 38

Am 15.08.2015 um 14:01 schrieb Kai Inge Buseth:
> Hello.
> 
> Normally I would have used Firebird to solve the simple task,
> but this is not allowed to install on the PC and then
> I have to use two unfamiliar components, like listboxes, to solve a
> record task instead of data aware components.
> 
> The task:
> A column of initials is copied into a listbox or something that can
> take care of
> the list of random Initials.
> I e 
> KIB
> FAH
> KLS
> 
> Then the program will somehow go through the list in the first listbox
> and in
> another listbox, that has all the initials in one column and
> corresponding numbers in another, show only the rows that correspond
> with the list of initials given in the first listbox.
> 
> If someone could give a syntax example of such a use of two listboxes,
> I would be grateful.
> 
> Thanks in advance.
> 
> :)
> Kai Inge
> 

Hello,

three different ideas:

1. Use Firebird embedded so it's only a few files which get deployed
   with your application

2. Use FireDAC which has an in memory SQL dataset.

3. I'm not sure how your output shall look, but:
   - loop over your first list and for each entry of it
   - loop over the 2nd list from begining to end and if the 1st column
     with the initials matches your current value from your first list
     add the number of the 2nd column

Greetings

Markus
0
Markus
8/15/2015 12:35:05 PM
Am 15.08.2015 um 14:01 schrieb Kai Inge Buseth:
> Hello.
> 
> Normally I would have used Firebird to solve the simple task,
> but this is not allowed to install on the PC and then
> I have to use two unfamiliar components, like listboxes, to solve a
> record task instead of data aware components.
> 
> The task:
> A column of initials is copied into a listbox or something that can
> take care of
> the list of random Initials.
> I e 
> KIB
> FAH
> KLS
> 
> Then the program will somehow go through the list in the first listbox
> and in
> another listbox, that has all the initials in one column and
> corresponding numbers in another, show only the rows that correspond
> with the list of initials given in the first listbox.
> 
> If someone could give a syntax example of such a use of two listboxes,
> I would be grateful.
> 
> Thanks in advance.
> 
> :)
> Kai Inge
> 

Hello,

three different ideas:

1. Use Firebird embedded so it's only a few files which get deployed
   with your application

2. Use FireDAC which has an in memory SQL dataset.

3. I'm not sure how your output shall look, but:
   - loop over your first list and for each entry of it
   - loop over the 2nd list from begining to end and if the 1st column
     with the initials matches your current value from your first list
     add the number of the 2nd column

Greetings

Markus
0
Markus
8/15/2015 12:36:57 PM
Am 15.08.2015 um 14:01 schrieb Kai Inge Buseth:
> Hello.
> 
> Normally I would have used Firebird to solve the simple task,
> but this is not allowed to install on the PC and then
> I have to use two unfamiliar components, like listboxes, to solve a
> record task instead of data aware components.
> 
> The task:
> A column of initials is copied into a listbox or something that can
> take care of
> the list of random Initials.
> I e 
> KIB
> FAH
> KLS
> 
> Then the program will somehow go through the list in the first listbox
> and in
> another listbox, that has all the initials in one column and
> corresponding numbers in another, show only the rows that correspond
> with the list of initials given in the first listbox.
> 
> If someone could give a syntax example of such a use of two listboxes,
> I would be grateful.
> 
> Thanks in advance.
> 
> :)
> Kai Inge
> 

Hello,

three different ideas:

1. Use Firebird embedded so it's only a few files which get deployed
   with your application

2. Use FireDAC which has an in memory SQL dataset.

3. I'm not sure how your output shall look, but:
   - loop over your first list and for each entry of it
   - loop over the 2nd list from begining to end and if the 1st column
     with the initials matches your current value from your first list
     add the number of the 2nd column

Greetings

Markus
0
Markus
8/15/2015 12:48:53 PM
Markus Humm wrote:

> Am 15.08.2015 um 14:01 schrieb Kai Inge Buseth:
> > Hello.
> > 
> > Normally I would have used Firebird to solve the simple task,
> > but this is not allowed to install on the PC and then
> > I have to use two unfamiliar components, like listboxes, to solve a
> > record task instead of data aware components.
> > 
> > The task:
> > A column of initials is copied into a listbox or something that can
> > take care of
> > the list of random Initials.
> > I e 
> > KIB
> > FAH
> > KLS
> > 
> > Then the program will somehow go through the list in the first
> > listbox and in
> > another listbox, that has all the initials in one column and
> > corresponding numbers in another, show only the rows that correspond
> > with the list of initials given in the first listbox.
> > 
> > If someone could give a syntax example of such a use of two
> > listboxes, I would be grateful.
> > 
> > Thanks in advance.
> > 
> > :)
> > Kai Inge
> > 
> 
> Hello,
> 
> three different ideas:
> 
> 1. Use Firebird embedded so it's only a few files which get deployed
>    with your application
> 
> 2. Use FireDAC which has an in memory SQL dataset.
> 
> 3. I'm not sure how your output shall look, but:
>    - loop over your first list and for each entry of it
>    - loop over the 2nd list from begining to end and if the 1st column
>      with the initials matches your current value from your first list
>      add the number of the 2nd column
> 
> Greetings
> 
> Markus

Hello Markus

and thank you for answering me.

1. I have never used Firebirds embedded flavour, so now is anyway the
time to learn what it's all about.
If it can be installed without the PC's security system preventing it,
its worth a try.

2. I have UniDAC implemented in XE7, if it has a memory SQL dataset
also, I will try this. If not, I will explore the FireDAC collection.

3. The output is just two columns, the initials and the employee
numbers. The initials is copied from an excel column in a
administration duty list and the program
will provide a column with the employee numbers for theese initials.
(The initials in question is 12 per day, changing every day and there
are 56 employees they are taken from.)

No doubt this could be done directly in the excel system by formulas or
macros, but first thing is that we are not allowed to change anything
in the administrations excel system,
second thing is that I want Delphi to handle this little task for the
lady at work. :-)
She copies the initials list from the administration system and into
Delphi, which provide the correct employee numbers column that then is
copied back into the correct excel column
that was supposed to be filled in by hand.

:)
Kai Inge
0
Kai
8/15/2015 3:57:40 PM
Markus Humm wrote:

> Am 15.08.2015 um 14:01 schrieb Kai Inge Buseth:
> > Hello.
> > 
> > Normally I would have used Firebird to solve the simple task,
> > but this is not allowed to install on the PC and then
> > I have to use two unfamiliar components, like listboxes, to solve a
> > record task instead of data aware components.
> > 
> > The task:
> > A column of initials is copied into a listbox or something that can
> > take care of
> > the list of random Initials.
> > I e 
> > KIB
> > FAH
> > KLS
> > 
> > Then the program will somehow go through the list in the first
> > listbox and in
> > another listbox, that has all the initials in one column and
> > corresponding numbers in another, show only the rows that correspond
> > with the list of initials given in the first listbox.
> > 
> > If someone could give a syntax example of such a use of two
> > listboxes, I would be grateful.
> > 
> > Thanks in advance.
> > 
> > :)
> > Kai Inge
> > 
> 
> Hello,
> 
> three different ideas:
> 
> 1. Use Firebird embedded so it's only a few files which get deployed
>    with your application
> 
> 2. Use FireDAC which has an in memory SQL dataset.
> 
> 3. I'm not sure how your output shall look, but:
>    - loop over your first list and for each entry of it
>    - loop over the 2nd list from begining to end and if the 1st column
>      with the initials matches your current value from your first list
>      add the number of the 2nd column
> 
> Greetings
> 
> Markus

Hello Markus

and thank you for answering me.

1. I have never used Firebirds embedded flavour, so now is anyway the
time to learn what it's all about.
If it can be installed without the PC's security system preventing it,
its worth a try.

2. I have UniDAC implemented in XE7, if it has a memory SQL dataset
also, I will try this. If not, I will explore the FireDAC collection.

3. The output is just two columns, the initials and the employee
numbers. The initials is copied from an excel column in a
administration duty list and the program
will provide a column with the employee numbers for theese initials.
(The initials in question is 12 per day, changing every day and there
are 56 employees they are taken from.)

No doubt this could be done directly in the excel system by formulas or
macros, but first thing is that we are not allowed to change anything
in the administrations excel system,
second thing is that I want Delphi to handle this little task for the
lady at work. :-)
She copies the initials list from the administration system and into
Delphi, which provide the correct employee numbers column that then is
copied back into the correct excel column
that was supposed to be filled in by hand.

:)
Kai Inge
0
Kai
8/15/2015 3:58:41 PM
Handle the data indipendent from the view.

Simply create a collection, filter and render the view (listbox.Items.Clear and Add). If possible stop repainting the listbox.BeginUpdate, listbox.EndUpdate ...

Consider creating an Index over the Items that should be listed (2nd listbox) and just use the Index.

I cannot really help you with the process of filtering, since I don't know if the assoziation 1:n or n:m and if the index has to be rebuilt often.


> {quote:title=Kai Inge Buseth wrote:}{quote}
> Hello.
> 
> Normally I would have used Firebird to solve the simple task,
> but this is not allowed to install on the PC and then
> I have to use two unfamiliar components, like listboxes, to solve a
> record task instead of data aware components.
> 
> The task:
> A column of initials is copied into a listbox or something that can
> take care of
> the list of random Initials.
> I e 
> KIB
> FAH
> KLS
> 
> Then the program will somehow go through the list in the first listbox
> and in
> another listbox, that has all the initials in one column and
> corresponding numbers in another, show only the rows that correspond
> with the list of initials given in the first listbox.
> 
> If someone could give a syntax example of such a use of two listboxes,
> I would be grateful.
> 
> Thanks in advance.
> 
> :)
> Kai Inge

--
Delphi Programming is fun. Hilarious.
0
Michael
8/15/2015 7:34:13 PM
Am 15.08.2015 um 17:57 schrieb Kai Inge Buseth:
> Markus Humm wrote:
> 
>> Am 15.08.2015 um 14:01 schrieb Kai Inge Buseth:
>>> Hello.
>>>
>>> Normally I would have used Firebird to solve the simple task,
>>> but this is not allowed to install on the PC and then
>>> I have to use two unfamiliar components, like listboxes, to solve a
>>> record task instead of data aware components.
>>>
>>> The task:
>>> A column of initials is copied into a listbox or something that can
>>> take care of
>>> the list of random Initials.
>>> I e 
>>> KIB
>>> FAH
>>> KLS
>>>
>>> Then the program will somehow go through the list in the first
>>> listbox and in
>>> another listbox, that has all the initials in one column and
>>> corresponding numbers in another, show only the rows that correspond
>>> with the list of initials given in the first listbox.
>>>
>>> If someone could give a syntax example of such a use of two
>>> listboxes, I would be grateful.
>>>
>>> Thanks in advance.
>>>
>>> :)
>>> Kai Inge
>>>
>>
>> Hello,
>>
>> three different ideas:
>>
>> 1. Use Firebird embedded so it's only a few files which get deployed
>>    with your application
>>
>> 2. Use FireDAC which has an in memory SQL dataset.
>>
>> 3. I'm not sure how your output shall look, but:
>>    - loop over your first list and for each entry of it
>>    - loop over the 2nd list from begining to end and if the 1st column
>>      with the initials matches your current value from your first list
>>      add the number of the 2nd column
>>
>> Greetings
>>
>> Markus
> 
> Hello Markus
> 
> and thank you for answering me.
> 
> 1. I have never used Firebirds embedded flavour, so now is anyway the
> time to learn what it's all about.
> If it can be installed without the PC's security system preventing it,
> its worth a try.
> 

I just read the releasenotes of the current embedded version 2.5.4 as
the last time I had used the embedded variant for a project at home was
back in the 1.5.x days.

It doesn't require installation, you just need to deploy the necessary
files along with your app. You can put them in the same directory.
Just be aware that there's no login security as in the normal variant.

Since 2.5.x it even supports the backup API which can be accessed from
Delphi via FireDAQ.


> 2. I have UniDAC implemented in XE7, if it has a memory SQL dataset
> also, I will try this. If not, I will explore the FireDAC collection.
> 
> 3. The output is just two columns, the initials and the employee
> numbers. The initials is copied from an excel column in a
> administration duty list and the program
> will provide a column with the employee numbers for theese initials.
> (The initials in question is 12 per day, changing every day and there
> are 56 employees they are taken from.)
> 
> No doubt this could be done directly in the excel system by formulas or
> macros, but first thing is that we are not allowed to change anything
> in the administrations excel system,
> second thing is that I want Delphi to handle this little task for the
> lady at work. :-)
> She copies the initials list from the administration system and into
> Delphi, which provide the correct employee numbers column that then is
> copied back into the correct excel column
> that was supposed to be filled in by hand.

Your attempts to solve the issue seem overcomßplicated to me, if I
understood your problem correctly.

Why don't you create a TDictionary where the key is an initial and the
data is the employee number?

Then create an array or a string list and fill it with the desired
initials. Loop over it and fetch the corresponding value from the
dictionary and put that combo out in any way you like.

If that's no good solution I didn't yet properly understand your problem.
Btw. if the data is already in Excel you can access Excel via OLE and
directly copy it from there.

Greetings

Markus
0
Markus
8/17/2015 4:45:44 PM
Reply:

Similar Artilces:

superreview requested: [Bug 224053] Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start : [Attachment 134410] Patch
Malcolm Rowe <malcolm-bmo@farside.org.uk> has asked David Bienvenu <bienvenu@nventure.com> for superreview: Bug 224053: Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start http://bugzilla.mozilla.org/show_bug.cgi?id=224053 Attachment 134410: Patch http://bugzilla.mozilla.org/attachment.cgi?id=134410&action=edit ...

superreview granted: [Bug 224053] Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start : [Attachment 134410] Patch
David Bienvenu <bienvenu@nventure.com> has granted Malcolm Rowe <malcolm-bmo@farside.org.uk>'s request for superreview: Bug 224053: Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start http://bugzilla.mozilla.org/show_bug.cgi?id=224053 Attachment 134410: Patch http://bugzilla.mozilla.org/attachment.cgi?id=134410&action=edit ------- Additional Comments from David Bienvenu <bienvenu@nventure.com> sr=bienvenu ...

superreview requested: [Bug 224053] Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start : [Attachment 134465] Patch v2
Malcolm Rowe <malcolm-bmo@farside.org.uk> has asked David Bienvenu <bienvenu@nventure.com> for superreview: Bug 224053: Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start http://bugzilla.mozilla.org/show_bug.cgi?id=224053 Attachment 134465: Patch v2 - allow type on LI http://bugzilla.mozilla.org/attachment.cgi?id=134465&action=edit ...

superreview granted: [Bug 224053] Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start : [Attachment 134465] Patch v2
David Bienvenu <bienvenu@nventure.com> has granted Malcolm Rowe <malcolm-bmo@farside.org.uk>'s request for superreview: Bug 224053: Simple HTML (sanitizer) message view disallows numbered list (OL) with non-default start http://bugzilla.mozilla.org/show_bug.cgi?id=224053 Attachment 134465: Patch v2 - allow type on LI http://bugzilla.mozilla.org/attachment.cgi?id=134465&action=edit ...

Number of connections connected
hi, all I can limit the user connections to my sybase. But how can I know how many connections currently connected to my sybase ? Regards, Keene Hui Kenneth Hui wrote: > I can limit the user connections to my sybase. Do you mean on a per user basis? If so, no. > But how can I know how many connections currently connected > to my sybase ? 'sp_who' or 'select * from sysprocesses' will show the current connections. -am � 2001 ...

creating a simple task list
I am trying to create a basic task list which updates in the database when the checkbox is toggled. I am a little stumped because all the .NET controls which show all records in a dataview do not allow template editing, and the FormView (which only shows one record at a time) does not work when you set a checkbox to be databound... Is there a way to do this easily? Any input is appreciated. Thank you :) You can use a template column in the GridView. Here's an article on checkboxes inside a gridview. http://www.codeproject.com/cs/miscctrl/GridViewCheckBox.aspPlease: Don't f...

Connection String not Initialized in Scheduled Task?
I am writing some code to send an email reminder to a number of people (gleaned from a database) at a scheduled time. When I run the .exe with windows task scheduler the email functionality works fine, but when I add the database piece it errors out with the following: The Connection String property has not been initialized. I am using the same code elsewhere in my application to make the db connection, so I can't see why it complains. Here is the code: using System; using System.Data; using System.IO; using System.Net; using System.Web; using System.Web.Mail...

All my task list entries were gone!, powerbuilder is getting closed when i click on the Task list icon
Hi all I am using PB 10.2.0 Build 7516. I have created a list of Tasks using the Task List for my current workspace. But suddenly when I click on the Task List icon the PB is getting closed, Application error occurs. How to recover my Task List!!, How to solve this issue, Any body have idea, pls share it with me TIA Rammurali Krishnan B ...

how to do a simple MySQL connection with Delphi 2010? [Edit]
hello, what is the fastest way to make a connection to a MySQL database with Delphi 2010? i just have to do a few simple queries, like reading and writing to some tables. are there some code examples anywhere? until now i have used DirectSQL but it doesn't work with Delphi 2010 anymore. are there similar classes in Delphi 2010 already? thx for any help! Edited by: Thomas Schmidt on Oct 29, 2009 6:01 PM Edited by: Thomas Schmidt on Oct 29, 2009 6:02 PM Hi! In general you only need DBExpress. That is TSQLConnection, connect to it TSQLQuery, then connect that to TDatas...

ObjectDataSource, Non-Generic Methods, and a simple List.
Alright. We've got a static class with static methods that return either a User or a List<User> and everything appears to be kosher BUT when we go to add the ODS, it refuses to recognize our methods. DataAccess.cs [DataObject(true)] static class DataAccess { ...snip... [DataObjectMethod(DataObjectMethodType.Select, false)] public static User GetUserById(int id) { return DataSource.GetUserById(id); } UserAdmin.aspx [DataObjectMethod(DataObjectMethodType.Select, true)] public static List<User> ...

Task Lists / Check Lists
Hi, I have a user who previously (GW 6) was able to change a mail into a Task and this would then appear in the Calendar. Since GW7, when we change an item into a Task, any attachement fails to open. Is this a known problem? I am able to replicate this on several PC's. I thought, maybe, this functionality had been changed and you had to move items into your Checklist. The attachments open fine by the way. I noticed when you move an item to Checklist, you get a due on date. Is is possible that Checklist items can appear in your Calender. It would make sense to m...

List of lists (listing of)
Ted In the great List 'o lists., is there something which is along the lines of "Personal organisers" ? I have googled and found others - just wondering about the lists and couldn't see anything in there I have a intense, executive type who's after something along the lines of Lotus' personal organiser. Don't know why she wants to change from it when I know she already has it installed. Anybody else got suggestions for a good one? (and dont't ask what I mean by good - it's not for me - perhaps I mean effective) In grc.techtalk, Baz...

Number of connections (spid numbers)
Since upgrading from 11.9.2 to 12.5.1, I have noticed a significant increase in the spid number assigned to connections. Actually, it broke an application that captures @@spid to a 3-char field. I usually have no more than between 300 and 400 concurrent connections with anywhere from 30 - 50 new connections each hour (per sysmon). The spid numbers are now reaching over the 1000 mark. Has anything changed in how spid numbers are assigned? I assumed that a spid number is assigned either by one thats been previously assigned and available or the next highest number sequentially. If I ch...

Number of User, Number of Connections
Hi, Does open client provide a mechanism to write an application that will alow me to monitor the number of users and connections to a database? Regards, San > Does open client provide a mechanism to write an application that will alow > me to monitor the number of users and connections to a database? I do not think Open Client has a way to do it, but I think the easiest is to select the info from master.dbo.sysprocesses Stephan On Sun, 12 Aug 2001 16:18:03 -0400, Stephan Marais <smarais@mindspring.com> wrote: You could write an openclient application tha...

Web resources about - Simple task of listing numbers connected to Initials, but lacking knowledge of syntax to do it. - embarcadero.delphi.non-tech

Connected sum - Wikipedia, the free encyclopedia
In mathematics , specifically in topology , the operation of connected sum is a geometric modification on manifolds . Its effect is to join two ...

‘The Washington Post’ Cranks Up Facebook-Connected Political News App The Issue Engine
The Washington Post enhanced its coverage of the 2012 presidential election with its release of news application The Issue Engine , which allows ...

The Value of a Facebook-connected Mobile User
... back more often, and are more likely to become paying customers. Many top game developers, for example, have also found that Facebook-connected ...

Facebook mobile game users play longer, spend more than users not connected with the social network
Mobile game players logged in via Facebook generate more revenue for developers, Facebook Games Strategic Partner Manager Sara Brooks said today ...

CMS-Connected (@cmsconnected) on Twitter
Webinar on Saving your Intranet from the Boneyard (and more) with @sethearley @RHarbridge @JiveSoftware Here => ow.

Better connected: Twitter for BlackBerry
A new version of Twitter for BlackBerry introduces new features that make it easier to connect to the people and things you care about. Twitter ...

Global Trade Network-Exporters,Importers,Manufacturers,Wholesalers,Suppliers,Buyers Connected
Find, Connect & Engage with new Buyers, Suppliers, Manufacturers, Wholesalers, Exporters and Importers all-over the world.

Republicans Connected for iPhone, iPod touch, and iPad on the iTunes App Store
Get Republicans Connected on the App Store. See screenshots and ratings, and read customer reviews.

Autoblog Minute: 2015 Connected Car Expo and Volvo's Concept 26 interior
Filed under: Videos , 2015 LA Auto Show , Autoblog Minute , Auto News Recaps The future of connected cars takes center stage in LA. Autoblog ...

Faraday Future connected cars - Business Insider Deutschland
Until recently, the new company appeared to be heavy on hype and light on just about everything else.

resources last updated: 11/20/2015 8:15:01 PM