It would be true with a DLL, too. Right now I'm working on creating an indexed computed column in the table using the stored procedure. I'll let you know how it goes.
Sami ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 3:56 AM Subject: Re: Removing blank from data > > > It seems to work, but it takes forever because > > it's looking thru every row in the table. > > Wouldn't this be true w/ the DLL as well? Randy's view solution > gives RBase the opportunity to pre-optimize the select... but I > guess you won't know til you try. > > Would you mind sharing the results? I have something similar > coming up. > > Thanks, > > Ben > > > On 12 Jun 2002, at 9:03, Sami Aaron wrote: > > > Bill - > > > > I get every record in the table: > > > > With vtest set at text '00051334944' > > > > SELECT Claim#, (CALL KeepNum(Claim#)) + > > FROM Assigned + > > WHERE (call keepnum(Claim#)) = .vtest > > > > Gives me: > > Claim# (CALL(KeepNum(Claim#)) > > ------------- ---------------------------- > > J26059001 26059001 > > 200DSSB02930 20002930 > > 00-051-334944 00051334944 etc > > > > Can you NOT do a CALL statement in a WHERE clause? > > > > I created this select statement as a view, giving a name to the CALL > > statement: > > > > CREATE VIEW testvw AS+ > > SELECT Claim#,(CALL(KeepNum(Claim#)) AS `KeepNumVal` FROM Assigned > > > > Then I could do: > > SELECT * FROM testvw WHERE KeepNumVal = .vtest > > > > It seems to work, but it takes forever because it's looking thru every row > > in the table. I guess I could project a temp table from the view and build > > an index on it ... > > > > I may have to bite the bullet and take that first piece of advice from Troy > > and get that DLL from Larry - except that you've worked so hard on it ... : > > ( > > > > Sami > > > > ----- Original Message ----- > > From: "Bill Downall" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, June 11, 2002 4:57 PM > > Subject: Re: Removing blank from data > > > > > > > Sami, > > > > > > What do you get with > > > > > > SELECT Claim#, (CALL KeepNum(Claim#)) + > > > FROM Assigned + > > > WHERE (call keepnum(Claim#)) = .vtest > > > > > > and other similar variations: > > > > > > WHERE (call keepnum(claim#)) <> claim# > > > > > > Bill > > > > > > On Tue, 11 Jun 2002 16:17:39 -0500, Sami Aaron wrote: > > > > > > >SELECT Claim# FROM Assigned WHERE (call KeepNum(Claim#)) = > > > ..vtest > > > > > > > >should return the same list of values as above. > > > > > > > >The way you posted it (with the two corrections) the SELECT > > > COUNT(*) > > > >statement is returning a count of ALL the rows in the table. > > > > > > > >Am I just not understanding what should be returned? > > > > > > > > > > > > > > > > > > > > > ================================================ > > > TO SEE MESSAGE POSTING GUIDELINES: > > > Send a plain text email to [EMAIL PROTECTED] > > > In the message body, put just two words: INTRO rbase-l > > > ================================================ > > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > > ================================================ > > > TO SEARCH ARCHIVES: > > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
