Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem requerying a remote view
Message
From
17/06/2004 07:19:02
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00909860
Message ID:
00914573
Views:
19
>create sql view cc_cce remote connection 'm project' as
> select cce.*, description1 from cce, payment where
> cce.cce_payment=payment.payment_no and cce_payment is not null and cast
> (convert(char(10), date_accept,111) as datetime)=?Filter_CC_date ;
>union select cce.*, 'Paiement différé' as description1 from cce where
> cce_payment_transfer is not null and cast(convert(char(10),
> date_accept,111) as datetime)=?Filter_CC_date

What is the length of Payment.description1 field?
A moment of silence is our cosmic reset button.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform