This topic is locked

Sql Query

6/4/2003 6:49:41 PM
ASPRunnerPro General questions
M
mpierce author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=85&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> I cannot get the sql query for filemaker pro to work. Get a Cannot Retrieve Columns Information. Please modify sql and try again. Any ideals? This is my sql statement.

select Repair Ticket Number,

Problem Title,

Date Opened,

Time Opened,

Problem Type,

Assigned To,

Priority,

Date Assigned,

Time Assigned,

Date Due,

Date Closed,

Requester Name,

Requester Location,

Requester Phone,

Hours,

Charge,

Ticket Status,

Problem Detail,

Solution,

Notes,

Opened By,

Closed By,

Edited By,

Days Past Due Date

From Repair Tickets

admin 6/4/2003

Hi,
try to wrap field names that have spaces in it with double quotes.

select Repair Ticket Number,

"Problem Title",

"Date Opened",

"Time Opened",

"Problem Type"

...


Sergey Kornilov

500037 6/5/2003

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=252&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' /> Thank you I will give it a try