Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - BLUES
Message
From
14/10/1998 09:11:13
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00146533
Message ID:
00146588
Views:
26
>Hi,
>
>Has anybody seen something like this?
>
>
>select virtual.*, iif(V_Weight=0,0,v_Value/v_weight) as price;
>   from Virtual,Stock,Sale;
>   where stk_Parcel=V_Stock;
>   and sal_Docnr= stk_docnr;
>   and V_Box= cKey;
>   and V_Status= hStk_Sale;
>   into cursor glSold
>
Put a space infront of each semi-colon... I have had strange problems with SQL statements that that has solved.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform