Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: computerguy2
- Content: Threads
- Order by date
-
Retrieving a value using a SQL command via FoxPro
Hi...I need to retrieve a value from a FoxPro database using a SQL statement and put that value into a variable. When I try to Select QOH and run lQOH = conn.Execute sqlstatement, recordsaffected, adCmdText I get a compile error, expected '='. Could someone please help me out. Thanks..John...- computerguy2
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
Statement too long error while using update
When I use the update command in the following code I get a Run Time Error......Statement too long. Could you tell me how to use the update command in this case. It's VB6 and Visual FoxPro 6. Thanks Private Sub Command2_Click() Set conn = New ADODB.Connection Let conn.ConnectionString =...- computerguy2
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
After connecting to a database, no data available.
The following code returns -1 in the text box when I do a recordcound, and other errors when I try to update. I'm trying to connect a FoxPro table. Can someone tell me what I have done wrong, and how to correct the problem Private Sub Command1_Click() Set conn = New ADODB.Connection Let...- computerguy2
- Thread
- Replies: 14
- Forum: Visual Basic (Classic)
