I need help with a select statement that will allow me to select the
following data:
1-Empl_no is in the data more than once and
2-date is = to users selected date and

Somebody knows, how can I call (what is the syntax) a Oracle store procedure
from Visual Foxpro with input and output parameters?
Thanks
George Marosi

How to convert and transfer ANSI string data from FoxPro table to MS SQL
Unicode table. Data in FoxPro are in 1251 codepage (Russian Windows). Now
result is like "?????? ??????????? 100??      ".The ODBC driver does not
performs the conversion from ANSI to Unicode.

hola
tengo dos tablas:
ventas:
id_venta

I'm new to foxpro but when I try to run this Query:
SELECT catalog.serialnum, catalog.saleprice
FROM catalog
I get command is missing required clause, what exactly does this mean.

I have sql server running on windows 2003 at my head office. The guys from
branch office want to share the database through dial up connection. Please
advise how to do this with VFP
Any help will be much appreciated

When selecting data for a VB.Net application using OleDB, any column that is
computed (eg Address1+chr(13)+chr(10)+Address2) is returned as having a
width of 65 characters, which is truncating some data.
How do you specify another column width for computed columns?

I got a strange behavior, I need to connect to a table in MySql through ODBC
driver
No problem to create the connection, when i try to create a remote view I
got an error when I try to add any tables of the db and the error is that

hi to all
i work with vfp8 and i don't understand...
i have a table with 730000 record.
now, from a prg i try to do this:

I have some fields in the DOS / FileDSN datasource I'm accessing with names
like 'Cust #' and SQLEXEC is throwing a 'No table open' error as a result.
I've tried enclosing the field name in brackets as in Access but then I get
the fieldname in brackets as the data. Anyone know of a ...

I have got the following data in a report which I have created (just to show
you clearly what my main report and data looks like)
In my next report, I would have to show, how many minutes was spent on Slag,
how many on basket, and how many delay and so on.

All data access in my app is via sqlexec statements in prep for moving to sql
server.  Switched from VFP5 to VFP 8 a few months ago.
Just recently (last couple of weeks) I am getting a rash of data corruption
problems.  The app offers no complaints using the sqlexec statements but ...

I need to be able to get some data from a field in a table. The field size
is 20 Char.
In the field there is either a '0' or a two character number (e.g. '16') OR
something like:

I am trying to pass a numeric parameter (e.g. 123456) into an SQL query. Now
the query will then need to check that the parameter value is between two
fields on a record (Lowrange and Highrange).
The query i have is:

I need a help. How can I make a program for calculating two date?
Example: 03.12.2004-01.11.2004=02.01
SELECT ? FROM ...
Thanks in advance.