Ad:

MS Access and FileMaker Pro Discussion Thread
Marked Solved
Views: 1153

Dec 1st, 2008

SQL moving data error

Expand Post »

Hi all,

I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement or use special quotes?

Thanks

Martin

(Toggle Plain Text)

SQLText = "INSERT INTO issues1 ([title], [time], [Opened], [staff], [status], [category], [comment]) SELECT title, time, Opened, staff, status, category, comment " & "FROM issues where (issues.id=" & Me.ID & ")"

Last edited by peter_budo; Dec 3rd, 2008 at 7:17 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

HijackThis Log help, Terrible Virus/Malware in Viruses, Spyware and other Nasties
Move actual file DOMDocument() in VB.NET
mysql_fetch_array problem in PHP

Swarv

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Dec 1st, 2008

Re: SQL moving data error

Can you show us the statement that doesn't work? My first guess would be that you don't have brackets around each of the fields. I see you have brackets in the Insert INTO section of the SQL Statement, but not in the SELECT section of the statement.

timothybard

Reputation Points: 27

Solved Threads: 29

Posting Whiz

Offline

317 posts
since Mar 2007

Permalink

Dec 1st, 2008

Re: SQL moving data error

The statement above does work. I would have thought that the below would work. All I would do is place the column names in quotes.

(Toggle Plain Text)

SQLText = "INSERT INTO issues1 ("title", "time", "Opened", "opened by", "staff", "status", "category", "comment", "assigned to") SELECT title, time, Opened, opened by, staff, status, category, comment , assigned to" & "FROM issues where (issues.id=" & Me.ID & ")"

Last edited by peter_budo; Dec 3rd, 2008 at 7:18 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Swarv

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Dec 1st, 2008

Re: SQL moving data error

Try this:

(Toggle Plain Text)

SQLText = "INSERT INTO issues1 ([title], [time], [Opened], [opened by], [staff], [status], [category], [comment], [assigned to]) SELECT [title], [time], [Opened], [opened by], [staff], [status], [category], [comment] , [assigned to]" & "FROM issues where (issues.id=" & Me.ID & ")"

timothybard

Reputation Points: 27

Solved Threads: 29

Posting Whiz

Offline

317 posts
since Mar 2007

Permalink

Dec 1st, 2008

Re: SQL moving data error

thanks, I must have forgotton the later [ marks.

cheers

Swarv

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: rest. menu table design

Next Thread in MS Access and FileMaker Pro Forum Timeline: Expression Builder : MS ACCESS FORMS

DaniWeb Message

Cancel Changes

User Name
Password