Insert records to foxpro dbf from C# code

Question

5.00/5 (1 vote)

See more:

I used following code to insert record to foxpro dbf. But it throws an exception "Command contains unrecognized phrase/keyword." How can I fixed this.

string strLogConnectionString = @"Provider=vfpoledb;Data Source=E:\DBF\fLog.dbf;Collating Sequence=machine;Mode=ReadWrite;";

OleDbConnection strConLog = new OleDbConnection(strLogConnectionString);
strConLog.Open();

OleDbCommand oComm = new OleDbCommand("Insert into flog(File,Status,LogTime) values('"+strFiles+"','"+strDesc+"','"+dDatetime+"')", strConLog);

oComm.ExecuteNonQuery();

Posted 28-Dec-10 0:03am

Sanyon_d

Updated 28-Dec-10 0:11am

Abhinav S

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hiren solanki · Answer 1 · 2010-12-28T00:14:00

Solution 1

I think you already got many answers from HERE[^].

Posted 28-Dec-10 0:14am

Hiren solanki

Comments

Sanyon_d 28-Dec-10 6:19am

I couldn't get any correct answer from any.

Estys · Answer 2 · 2010-12-28T00:32:00

Solution 2

Are all the fields in your table strings? Is dDateTime a string?
Just a question.

Cheers

Posted 28-Dec-10 0:32am

Estys

Comments

Sanyon_d 28-Dec-10 22:12pm

dDateTime is a date time value. Others are strings.

thatraja · Answer 3 · 2010-12-28T06:35:00

Solution 3

Got it man here......:cool:

INFO: DELIMITED WITH BLANK Behavior Differs in Various FoxPro Versions[^]

Posted 28-Dec-10 6:35am

thatraja

Comments

Sanyon_d 28-Dec-10 22:13pm

The problem here is when I'm using variables in the insert statement. If I just use string values('ss') without using the varibles for values, it works nice.

Marc A. Brown · Answer 4 · 2010-12-28T07:52:00

Solution 4

Do any of the values in the variables strFiles, strDesc, or dDateTime contain apostrophes? If they do, you're winding up with that apostrophe terminating your string and the rest of your query winds up as garbage (or worse). In that case you'll need to escape them (by doubling them, if memory serves). Either that or build a parameterized command.

Posted 28-Dec-10 7:52am

Marc A. Brown

Comments

Sanyon_d 28-Dec-10 22:13pm

The problem here is when I'm using variables in the insert statement. If I just use string values('ss') without using the varibles for values, it works nice.

Marc A. Brown 28-Dec-10 22:18pm

Ok, so again, look at the values you're trying to insert. What values are in those variables?

JOAT-MON · Answer 5 · 2010-12-28T09:16:00

Solution 5

Try wrapping your datetime fields in curly braces instead of single quotes. Example: {12/28/2010}

Posted 28-Dec-10 9:16am

JOAT-MON

Comments

Sanyon_d 28-Dec-10 22:13pm

The problem here is when I'm using variables in the insert statement. If I just use string values('ss') without using the varibles for values, it works nice.