Hi

I have a need to return both active and deleted records in one query,
allowing me to identify those records which were marked for deletion in the
child table. Sounds simple but it is proving a problem.

Thanks in advance

David

I am impressed with the power the language. Incredible when you
consider this dates back to the 70s.

Edgar F Codd Is considered the Father of SQL but he did not seem to be
happy with with the early versions as it did not fit his original model.
Where these conflicts ever sorted out, do you think he would happy
with the MSSQLServer, Interbase, MySQL.

Do you think we still be using SQL the way we are in 200 years time ?

Hi people, this is Guillermo, from Perú.
I would like you to give some suggestions about my problem

I'm Using DB Postgre + VFP. Initially i thought using a DBC database +
remote views, but mi app will not work that way, because i am using
Postgre Schemas, and that is like little DB inside one only DB.

That is why i thought creating self made remote view, i mean to say
Updateable cursors writing some code, they work fine, and consist on:

1- Load the cursor from DB with SQLEXEC(lc_conex,"SELECT * FROM
MITABLA","MICURSOR")
2- Some code with CURSORSETPROP in order that the cursor be updateable
and send data to my DB.

As you realize, my problem is in step 1. But i read that exists some
alternatives for do not bring all the records.

- A sentence SQLSETPROP with parameter of conection 0 can set by
default the way SQLEXEC communicates with the DB.
- Also i can use CURSORSETPROP with parameter nWorkArea=0 for
establish by default tha way cursors work and load records.

Hello, i am using self made remote views (updateable cursors) i begin
my function this way:

sqlexec(lc_conexion,"SELECT * FROM mytable","micursor")

the question is: Does it bring ALL the records to my pc?

thanks
Guillermo Arias - Lima - Perú

Algun manual recomendable para bajar ?

Difiere mucho el uso de sql server y vfp , entre las versiones 6.0 y 9 de
vfp ?

Gracias y saludos
Ricardo

Does anyone know of a utility that will examine every filed in every record
and report which records and fields that have data in them that does not
conform to the field specifications?

This is to prevent other non FoxPro applications from having problems
reading the dbf files using the latest OLEDB drivers.

Hi,

I need to Insert some data to MS SQL 2005 from VisualFoxPro. Is it
possible?

br,
bala nemate

A table has a field containing the date and time. Example 2006-2-20
08:11:44.123...field name is DateInitiated. I can extract the month, day and
year by using Day(DateInitiated), Month(DateInitiated), Year(DateInitiated).
How would the time be extracted for hours, minutes and seconds?

Thanks!

Dear Friends

I have two files e.g. order and receipt and both have a common field IND_ID

Now when i order suppose order no1,2,3,4,5 etc.

And I received order no.2,4

I want result content of order no.1,3,5 i.e which order IND_ID is not
available in receipt file.

How to make a sql query.

Thanks