Re: Select isnull question

2007-03-11 Thread Chester Friesen
Ted Roche wrote: > Try: > >> CREATE SQL VIEW RB ; >> AS SELECT NVL(lot_salenum,"") as salenum ; >> from currbauction currbauction >> Thanks, Ted, that worked! My apologies for a delayed response, I was so relieved to find a solution that I forgot to reply. -- Regards, Chester Friesen Fri

Re: Select isnull question

2007-03-07 Thread Ted Roche
On 3/7/07, Chester Friesen <[EMAIL PROTECTED]> wrote: > There must be a simple answer that I'm not getting. When I run this I > get a "too many arguments" error. Try: > > CREATE SQL VIEW RB ; > AS SELECT NVL(lot_salenum,"") as salenum ; > from currbauction currbauction > -- Ted Roche Ted Roche &

Re: Select isnull question

2007-03-07 Thread Chester Friesen
John Gunvaldson wrote: > That is syntax (mostly) for T-SQL ISNULL() - that is not syntax for VFP > ISNULL() > Thanks, I'll go at it another way. I thought it would be easy. I saw that code on an Andy Kramek page. http://weblogs.foxite.com/andykramek/archive/2005/12/04/1016.aspx -- Regards, Ch

RE: Select isnull question

2007-03-07 Thread John Gunvaldson
That is syntax (mostly) for T-SQL ISNULL() - that is not syntax for VFP ISNULL() VFP only takes one argument for isnull() John C. Gunvaldson www.fox-net.com *== There must be a simple answer that I'm not getting. When I run this I get a "too many arguments" error. CREATE SQL VIEW RB ; AS SELE

Re: Select isnull question

2007-03-07 Thread Chester Friesen
John Weller wrote: > Should the currbauction be repeated? > Gives the same error. -- Regards, Chester Friesen Friesen Computer Company Willows, CA ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/p

RE: Select isnull question

2007-03-07 Thread John Weller
Should the currbauction be repeated? John Weller 01380 723235 07976 393631 > > CREATE SQL VIEW RB ; > AS SELECT ISNULL(lot_salenum,"") as salenum ; > from currbauction currbauction > ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Select isnull question

2007-03-07 Thread Chester Friesen
There must be a simple answer that I'm not getting. When I run this I get a "too many arguments" error. CREATE SQL VIEW RB ; AS SELECT ISNULL(lot_salenum,"") as salenum ; from currbauction currbauction -- Regards, Chester Friesen Friesen Computer Company Willows, CA _