Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Xbase Fox > SQL Errors: Whe...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 11 Topic 821 of 855
Post > Topic >>

SQL Errors: Where is the error?

by Gene Wirchenko <genew@[EMAIL PROTECTED] > Dec 22, 2007 at 08:08 PM

I have just finished -- I hope I have finished -- some changes to
one program of mine that has some hairy SQL.  One of the SQL statments
is 40 lines long.  Granted it could be shorter vertically, but it is
still 852 characters long.

     Occasionally -- read "All too often" -- while wrestling with this
program, there would be an error in my SQL syntax.  VFP is not
terribly helpful with such error messages as 
          Syntax error.
          Command is missing required clause.
These are not terribly useful.  Sometimes, I have hunted for minutes
before realising that, say, a comma was missing.

     What do you do to quickly find errors in long SQL statements?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
     I have preferences.
     You have biases.
     He/She has prejudices.
 




 11 Posts in Topic:
SQL Errors: Where is the error?
Gene Wirchenko <genew@  2007-12-22 20:08:17 
Re: SQL Errors: Where is the error?
"Lew" <lew@[  2007-12-23 22:59:19 
Re: SQL Errors: Where is the error?
Gene Wirchenko <genew@  2007-12-31 10:17:37 
Re: SQL Errors: Where is the error?
"Dan Freeman" &  2007-12-24 08:14:17 
Re: SQL Errors: Where is the error?
Cy Welch <cywelch@[EMA  2007-12-24 13:55:15 
Re: SQL Errors: Where is the error?
"swdev2" <ws  2007-12-24 23:25:08 
Re: SQL Errors: Where is the error?
Gene Wirchenko <genew@  2007-12-31 10:18:28 
Re: SQL Errors: Where is the error?
"swdev2" <ws  2008-01-01 23:05:45 
Re: SQL Errors: Where is the error?
"swdev2" <ws  2008-01-01 23:08:46 
Re: SQL Errors: Where is the error?
"Cathy Pountney"  2007-12-26 08:35:27 
Re: SQL Errors: Where is the error?
Gene Wirchenko <genew@  2007-12-31 10:21:35 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:19:03 CDT 2008.