I am trying to access data from a table like
"select col1,col2,col3 from table1 where name in ('A1','A2','A3',..,..,..
..,'An')"
If the number of elements in the where clause are more, i get a error

tengo dos tablas
mssi1 con
orden, digitoverificador, ID_Sucursal, codregistro, ID_grupo,
numero_afiliado, ID_miembro, fecha_emision, IDprofesion, ID_prescriptor,

Is it possible for a SQL query or Stored Procedure to open a database at an
external location via OLEDB or ODBC? What I want is for SQL to grab some
data from Microsoft's Visual Fox Pro 8.1 and store it into a SQL table. I
want this to happen about every minute or so.

Hello friends,
During a process I get 'Fatal Error exception code c....'.
Why does this come and how to solve it ?
In my process I have used sql - select and sql - insert.  Is it that this is

Can anybody help me with this:
if a field has a null value or {  .  .    }and the table is updated via a
remote view to a SQL server it always comes back with a date of 1.1.1900.
can this behavior be changed without an afterrequery process?

I have an application where most tables are too large to wrap into the
executable. It would make the executable too large. That's ok. So I
only put my smaller tables in the executable and wrapped it into the
exe so at least (I thought) people can't read my cross-reference files

   I have a program which need to connect SQL server(in office). The
program state in the server (in banch), and share to client to map the drive
to run it.
   My questionis...For example I have a 20 client's pc need to use the

I've got a dbf table that I created with FoxPro, and I was wondering if
indexes created on this table would be used when accessing the table through
ODBC SQL calls.  Thank you very much.
-Eric

During program execution when  a query is about to be executed, I get an
error which is 'File is in use'.  This is not always.  What is the reason for
this ?   How to solve it ?
The version of VFP is 6.0

Can anyone tell me what is different about the purpose of a Stored Procedure
versus a Procedure?
I currently have some Stored Procedures, and they work great. One of them,
for example, opens a separate VFP 8.1 database, selects a bunch of data

Hello friends,
Look at the query:
SELE * from slbacbr ;
where ( SLBEFFFM >= m.onavdt and ;

Hello Friends,
The following syntax when triked in Visual Foxpro 6.0 is giving syntax error.
What is the correct one ?  
Does this method of sql-insert works in VFP 6.0 ?

I have a VB6 application in which I access a FP6 DB with ADO.
As one of the tables gets bigger ( 20,000 Records) My response is degrading.
A typical Recordset open is as follows
SQLstr = "select * from orders where  jobdate < {" & pDate & "} and complete

Hi Friends
I just ran accidentally create table command on a existing table which has
data at one of our client sites
as you know it recreated existing table and data was erased.

I have a table in VFP 8.1, and have created a View that simply selects *
from the table. This works great.
I also have a third-party application that uses the following connect string
to talk to my VFP database: