>I am having some strange problems with the OleDb provider occasionally. Basically, I just got another error. The message was:
>
>"Variable 'NUMERO' is not found."
>
>And, this was the SQL:
>
>
>SELECT Province.Title_E AS Name,Province.Numero AS PrimaryKey FROM Province ORDER BY 1
>
>
>This is a very simple SQL. The field Numero does exist. I was on the page that was using that SQL. But, when I tried to refresh it, I got this message. Then, I retried and it was ok. I retried several times and it was always ok. This is happening occasionnaly and I just can't find where this is coming from.
>
>Is the OleDb provider reliable or not?
"Name" is a reserved word in VFP. It seems the last couple of times you've had reliability problems you've been using reserved words in some fashion. Can you try another way?
Also, if you're not already doing so you might want to cross-post into the VFP forum - I'm not sure if the MS VFPT monitors VFP-related issues here.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up