Date:  09/29/2008 10:46:38 AM Msg ID:  003806
From:  jc clerc Thread:  003803
Subject:  Re: Auth.AuthTable with a cursor from Mysq !
Thanks I will do that since this is exactly what I do thru a database with mysql remote views. I didn't know that we could simply name a view, I thought you had to name a specific DBF table located on the disk.
Kind regards
Sent by FoxWeb Support on 09/29/2008 10:08:48 AM:
The simplest solution is to create a Remote View in VFP, pointing to the user table in your MySQL database. You can then set Auth.AuthTable to the name of the Remote View.
FoxWeb Support Team email
Sent by jc clerc on 09/28/2008 11:02:22 AM:
I am migrating all my tables onto mysql. All is ok with the ODBC with sqlconnect, sqlexec .... (using the right user for the service!) but in order to use the Auth.AuthTable login I have to open a "DBF format table" is there a way to achieve the same by using the cursor name (user) I've got from my sqlexec(connectname,"select name,password from myuserlist","user") request ?
This will allow to not use a DBF FILE anymore.
Kind regards