Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Carlos Lima
  Where is Carlos Lima?
 Mindelo
 Cape Verde
 Carlos Lima
 Tags
Subject: RE: Error with select with autoinc field
Thread ID: 373248 Message ID: 373298 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 1:10:17 AM         
   


> I have a error SQL: Column 'registo' is not found
>
> select marcacoes.data_registo,marcacoes.registo from marcacoes where data_registo=date() into cursor dados_dia
>
> field registo is integer autoinc 4
>
> How to solve this.
>
> Thanks in advance


You are getting fields just from a single table so what will happen if you remove the table name in your SQL SELECT? Not that placing the table name is the cause of the error.

select data_registo, registo from marcacoes where data_registo=date() into cursor dados_dia



http://sandstorm36.blogspot.com
http://weblogs.foxite.com/sandstorm36

ENTIRE THREAD

Error with select with autoinc field Posted by Carlos Lima @ 3/20/2013 9:07:44 AM
RE: Error with select with autoinc field Posted by Koen Piller @ 3/20/2013 10:11:00 AM
RE: Error with select with autoinc field Posted by Carlos Lima @ 3/20/2013 11:11:41 AM
RE: Error with select with autoinc field Posted by Anders Altberg @ 3/20/2013 11:36:37 AM
RE: Error with select with autoinc field Posted by Cetin Basoz @ 3/20/2013 12:06:48 PM
RE: Error with select with autoinc field Posted by Jun Tangunan @ 3/21/2013 1:10:17 AM