> 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/
