Believe I have found the needed sql documentation.

tks,

jwc
-----Original Message-----
From: Jack Cane [mailto:jwcane@...]
Sent: Sunday, December 22, 2002 10:10 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] SQL Error


Just ran the update successfully using my WebApp.

jwc
-----Original Message-----
From: Jack Cane [mailto:jwcane@...]
Sent: Sunday, December 22, 2002 9:06 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] SQL Error


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]


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]


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]