Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC
Message
 
To
15/06/2000 12:18:20
Rene Van Den Berg
Infertility Database Systems Ltd
Islington, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: ODBC
Miscellaneous
Thread ID:
00379897
Message ID:
00381669
Views:
21
Hi Rene,

You still can use SQLEXEC().
But, i never tried to do it with an Excel sheet.

Normally, i use tables at SQL Server, and do something like you did, but the SELECT statement is like this:

SELECT * FROM CUSTOMERS


You can use remote views. Use it, for data that user will need to manipulate on the form. Others querys, make with SQLEXEC(), because they're quicker and doesn't waste space on the DBC file.

Cheers,

Ricardo
Previous
Reply
Map
View

Click here to load this message in the networking platform