On Sun, Mar 23, 2008 at 6:10 PM, Harry <[EMAIL PROTECTED]> wrote:
> I would like to use ODBC but cannot figure out how connect to the database
> or how to extract records. This is the code I'm attempting;
>
> put revOpenDatabase("ODBC","",testdb,"","") into myDB
> revQueryDatabase(myDB,"SELECT * FROM Item","tItemList")
> put tItemList into field "Item List"
Hi Harry,
I have bever used ODBC so I can't comment on your database open script
or the permission problems.
However, the 2nd line above is incorrect. Try this:
put revQueryDatabase(myDB,"SELECT * FROM Item") into tItemList
As revQueryDatabase is a function, you must tell it where to put the
result. Otherwise, Rev thinks it is a handler, which gives you the
"can't find handler" error.
Cheers,
Sarah
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
