General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Hi Aleksey,
Thank you very much for helping me!
I´ve modifyed the code you posted:
CREATE CURSOR taba (id C(4), field1 C(6), field2 C(1))
INSERT INTO taba values("0101","desc 1"," ")
INSERT INTO taba values("0201","desc 2","X")
CREATE CURSOR tabb (id C(6), field1 C(1))
INSERT INTO tabb values("010101","1")
INSERT INTO tabb values("010102","2")
INSERT INTO tabb values("010103","3")
INSERT INTO tabb values("020101","1")
INSERT INTO tabb values("020102","2")
INSERT INTO tabb values("020103","3")
select * from tabb left join taba on left(tabb.id,4)=taba.id where not empty(taba.field2) INTO CURSOR res
this code produces different results in VFP8 and VFP9.
Previous
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