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
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 &
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
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
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
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:
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
_
7 matches
Mail list logo