General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Difference in SQL SELECT between VFP6 and VFP7
Please, try to run this program under VFP6 and under VFP7.
VFP6 returns 2 rows, and VFP7 only 1 row. Can somebody help to explain me this behavior?
Thank you
Norbert Kustra
SET SAFETY OFF
SET STRICTDATE TO 0
SET DATE GERMAN
SET DELETED ON
CREATE TABLE test1 (;
id n(1),;
date1 d(8))
SELECT 0
CREATE TABLE test2 (;
id n(1),;
date2 d(8))
INSERT INTO test1 (id,date1) VALUES (1,DATE())
INSERT INTO test1 (id,date1) VALUES (2,DATE()-1)
INSERT INTO test2 (id,date2) VALUES (1,DATE())
select * ;
from test1 left join test2 on test1.id=test2.id;
where test2.date2<=DATE() INTO CURSOR work1
SELECT work1
BROWSE
SELECT work1
USE
SELECT test1
USE
SELECT test2
USE
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only