Bangkok:
Thank you for your help. I got it working with the original code and a slight modification to the query (and your help from your second point):
Here is what I changed (including the fixed query per your point 2):
-- Original: put revQueryDatabase(gConnectionID, "SELECT * from BFFMail ...
Search found 3 matches
- Fri Aug 03, 2012 3:57 pm
- Forum: Databases
- Topic: SQL unable to get query results, HELP!
- Replies: 3
- Views: 4293
- Fri Aug 03, 2012 5:30 am
- Forum: Databases
- Topic: SQL unable to get query results, HELP!
- Replies: 3
- Views: 4293
SQL unable to get query results, HELP!
I am writing an application for my brothers company. Here is what I am trying to accomplish:
Access an SQL database hosted on a remote server. Lookup a unique code and return several fields of data back to the user. The code is for a mail piece sent to prospective customers and the data returned ...
Access an SQL database hosted on a remote server. Lookup a unique code and return several fields of data back to the user. The code is for a mail piece sent to prospective customers and the data returned ...
- Fri Aug 03, 2012 4:30 am
- Forum: Databases
- Topic: ODBC database does nothing...also doesn't return erros
- Replies: 11
- Views: 10003
Re: ODBC database does nothing...also doesn't return erros
Hi Edgore:
I think I am having the same problem as you were. database does nothing, no errors, connection good.
You posted "Cursor! That was it. If I specifically set it to forward only (rather than allowing it to default, or using anything else) it appears to work!"
How do you do this? Can you ...
I think I am having the same problem as you were. database does nothing, no errors, connection good.
You posted "Cursor! That was it. If I specifically set it to forward only (rather than allowing it to default, or using anything else) it appears to work!"
How do you do this? Can you ...