General information
Title:
SQL - List Box - RowSource problem
I am trying to connect a VFP list box with a SQL database. When I run the program, it tries to open a dbf file. Additional info:
thisform.List1.RowSourceType=3
thisform.list1.ColumnCount=2
thisform.list1.RowSource="SELECT ENV_NO, ENV_TOTL FROM Ras2_envelope where env_no < 10 into cursor temp"
thisform.requery()
I can add the following code that will give me the info in the browse window.
SQLEXEC(Ras2Conn, "SELECT ENV_NO, ENV_TOTL ;
FROM Ras2_envelope", "test")
SELECT test
BROWSE nowait
Any help will be appreciated.
Jerry
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