sara Posted February 4, 2008 Report Share Posted February 4, 2008 hi all i do this example in labview to write the value of input to access but i have error can any one help me to solve this error http://www.fileflyer.com/view/qM8LeAv Quote Link to comment
Justin Goeres Posted February 4, 2008 Report Share Posted February 4, 2008 QUOTE(sara @ Feb 3 2008, 12:37 PM) can any one help me to solve this error What's the error code, and what does the source text say? Quote Link to comment
alukindo Posted February 5, 2008 Report Share Posted February 5, 2008 Your code shows that your column names include spaces, this makes SQL code prone to errors. For table names, you should use underscores symbol ( _ ) instead of spaces and then try again. This assumes that you were able to succesfully connect to your ACCESS Database Anthony Quote Link to comment
Rolf Kalbermatter Posted February 5, 2008 Report Share Posted February 5, 2008 QUOTE(alukindo @ Feb 4 2008, 01:09 AM) Your code shows that your column names include spaces, this makes SQL code prone to errors. For table names, you should use underscores symbol ( _ ) instead of spaces and then try again.This assumes that you were able to succesfully connect to your ACCESS Database Anthony Or you can usually put the column identifiers into square brackets to allow the SQL parser to recognize them as one entity. But not using spaces in column names is actually good practice. Rolf Kalbermatter Quote Link to comment
sara Posted February 5, 2008 Author Report Share Posted February 5, 2008 thanks alot for your reply and help ... i take your device and program run well thanks alot :thumbup: Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.