Linux support

[Ruslan Zasukhin]

On 1/8/05 12:43 AM, "Ken Jordan" <jordan at digi-net.com> wrote:

Hi Ken,

> 1) I am trying to use Valentina to store e-mail messages (broken down
> into parts). One of the fields stored is the Message-ID - a String that
> can be from 1 to 70 characters. I'm using VVarChar to store the string -
> created in the BaseObject subclass using
> 
> Dim MessageID As VVarChar
> ...
> MessageID = new VVarChar("message_id", 70, "ASCII", kV_Indexed + kV_Unique)
> 
> I create a VCursor using
> cursor = db.SQLselect("SELECT message_id, (...) FROM inbox") and display
> the results. When one of the messages is chosen I create another VCursor
> using
> cursor.CurrentPosition = (selected record)
> cursor2 = db.SQLselect("SELECT (...) FROM inbox WHERE message_id = " +
> cursor.VarCharField("message_id").Value)

You have forget wrap string constant by SINGLE QUOTES.

 cursor2 = db.SQLselect("SELECT (...) FROM inbox
    WHERE message_id = '" + cursor.VarCharField("message_id").Value) + "'"

 
> Sometimes I get the record requested, sometimes a null return. It is
> very consistent which will work and which will not. Investigation shows:
> 
> these id strings will not be found -
> "<41C313E7.60203 at dummy.com>"
> "<e0mk8eft.yy3nizzrvfze at a31fa80>"
> "<110C77E416.290691699 at dummy.com>"
> "<B0039468203 at dummy.com>"
> 
> these id strings will be found -
> "<41931397.60203 at dummy.com>"
> "<90328470.yy3nizzrvfze at a31fa80>"
> "<1108776416-290691699 at dummy.com>"
> "<110C77E416-290691699 at dummy.com>"
> "<80039468203 at dummy.com>"
> 
> It appears that if any non-digits appear before the '.' or before the
> '@' if no '.' is present, the string (obtained FROM the db) is not found
> in the db, but if only digits are there then the string is found. It
> doesn't seem to matter if there are all non-digits before a '-'.
> 
> The same thing happens if VString is used instead of VVarChar.
> 
> Is this some strange behavior caused by the way Valentina handles
> strings, or is there something that I'm missing?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------