Thanks, and yes, I am using FB.

The revised query executed without an error, using IB WorkBench. The status
bar at the bottom of IBWB gives the number of rows affected and the
processing time. There is also the following statement, immediately above
the status bar: "PLAN (MEMBERNAMES NATURAL)".

However, when I look at the table data, the user name and password columns
are unchanged from their previous values. Closed and reopened IBWB, no
change; re-ran the query, still no change.

Is there a commit command that must follow the update query?

I could also try to run the update query with my Delphi Web app.

Also, would like to have a pointer to an online reference for the substring
syntax and other FB SQL expressions.

tks,

jwc
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Sunday, December 22, 2002 8:12 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] SQL Error


At 07:39 AM 22-12-02 -0500, you wrote:

>Here is what I just tried. I get an error at the space after firstname.
>update MemberNames
>set username =
> SUBSTRING( firstname 1 FOR 1 ) ||
> SUBSTRING( lastname 1 FOR 7 );

Sorry, it's

SUBSTRING( firstname FROM 1 FOR 1 ) ||
SUBSTRING( lastname FROM 1 FOR 7 )

heLen




Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]