I am getting the following error :

DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Time expression but instead
found ? in INSERT SQL statement

This is my query :

   q.SQL.Text := 'INSERT INTO Log ([Time-start]) VALUES (:start)';
   q.Prepare;
   q.ParamByName('start').Astime := strtotime('12:00:00');
   q.ExecSQL;

Any ideas why this is happening ?

"John" <eydunl@post.olivant.fo> wrote in message
news:245370DE-72D0-471A-B884-9E688BFD991F@news.elevatesoft.com...
>I am getting the following error :
>
> DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Time
> expression but instead
> found ? in INSERT SQL statement
>
> This is my query :
>
>    q.SQL.Text := 'INSERT INTO Log ([Time-start]) VALUES (:start)';
>    q.Prepare;
>    q.ParamByName('start').Astime := strtotime('12:00:00');
>    q.ExecSQL;

Is "-" allowed in a  field name: "Time-start"?

John,

<< This is my query :

   q.SQL.Text := 'INSERT INTO Log ([Time-start]) VALUES (:start)';
   q.Prepare;
   q.ParamByName('start').Astime := strtotime('12:00:00');
   q.ExecSQL;

Any ideas why this is happening ? >>

Using AsTime should set the data type of the parameter appropriately.  Try
this and see if it corrects it:

   q.SQL.Text := 'INSERT INTO Log ([Time-start]) VALUES (:start)';
   q.ParamByName('start').DataType:=ftTime;
   q.Prepare;
   q.ParamByName('start').Astime := strtotime('12:00:00');
   q.ExecSQL;

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

John,

<< This is my query :

   q.SQL.Text := 'INSERT INTO Log ([Time-start]) VALUES (:start)';
   q.Prepare;
   q.ParamByName('start').Astime := strtotime('12:00:00');
   q.ExecSQL;

Any ideas why this is happening ? >>

Using AsTime should set the data type of the parameter appropriately.  Try
this and see if it corrects it:

   q.SQL.Text := 'INSERT INTO Log ([Time-start]) VALUES (:start)';
   q.ParamByName('start').DataType:=ftTime;
   q.Prepare;
   q.ParamByName('start').Astime := strtotime('12:00:00');
   q.ExecSQL;

--
Tim Young
Elevate Software
www.elevatesoft.com


Thank you for your suggestions. I tried both suggestions - but neither fixed the problem. I am still getting the same error message.
---
John

John,

<< Thank you for your suggestions. I tried both suggestions - but neither
fixed the problem. I am still getting the same error message. >>

Could you send me an example of this with the table
(timyoung@elevatesoft.com) ?  It would help immensely if I could run it here
in the debugger.


--
Tim Young
Elevate Software
www.elevatesoft.com