help me with an algorithm please

[samuelberthelot@googlemail.com]

Hi,
I can't figure out how to build a string based on the requirements
described below:

First here are my SQL tables:

Fields (FieldId, FieldName)
ConstraintMessa ge (Id, FieldId, FieldPosition, Message)

Basically, the user can build a ConstraintMessa ge by dragndropping
FieldNames from a listbox to a textbox. The textbox can also be edited
in order to make the ConstraintMessa ge more complex.

As you can see, only the FieldId of the dragndropped fields are stored
in [ConstraintMessa ge] as well as its position in the message.
'Message' is used to store the text entered directely in the textbox.

When a ConstraintMessa ge is built in order to be displayed on the
screen, it's a matter of inserting the right 'FieldName' at the right
'MessagePositio n' in 'Message'.

The difficult thing is that, when you restore the ConstraintMessa ge, a
Field might have been deleted from Fields or a FieldName might have
change since the day the ConstraintMessa ge was built.

I hope it's clear enough. How to do that in Vb.net ?

Thank you.

[Homer J Simpson]

Re: help me with an algorithm please


<samuelberthelo t@googlemail.co m> wrote in message
news:1137413658 .799321.223440@ g14g2000cwa.goo glegroups.com.. .
[color=blue]
> Hi,
> I can't figure out how to build a string based on the requirements
> described below:[/color]
....[color=blue]
> I hope it's clear enough. How to do that in Vb.net ?[/color]

A couple of examples would help.