General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
dear Erick
my problem is exist unfortunatly.
here is my code:
WITH thisform.list1
.rowsourcetype=3
.RowSource = "SELECT Havaleh.vnum, Havaleh.vdate, Havaleh.vval, Havaleh.transpay,;
Owner.ofamily, Products.pname, Havaleh.ocode, Havaleh.pcode,;
Havaleh.tonkiloo;
FROM havaleh;
LEFT OUTER JOIN owner ON Havaleh.ocode = Owner.ocode ;
LEFT OUTER JOIN products ON Havaleh.pcode = Products.pcode ;
ORDER BY Havaleh.vnum INTO CURSOR CursorTemp"
.refresh
ENDWITH
but when i run my form an error message say that exist error in my SQL statment.
when i delete Havaleh.pcode,Havaleh.tonkiloo problem was solved.
i dont know is it because number of field is more than 8?
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