Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 6 of 6 total |
Build 6: Error #700 |
Sun, Jan 21 2007 7:33 PM | Permanent Link |
Charalabos Michael | Hello Tim,
Lines: SQL.Add('INSERT INTO Data'); SQL.Add(Format('VALUES (%d, %d, %d, ''%s'', %d, :Param1, :Param2, NULL, CURRENT_TIMESTAMP, %d, ''test'')', [1, 0, 1, 'test', 1, 1])); Params[0].Text := 'Param1'; Params[1].Text := 'Param2'; ExecSQL; Error: An error was found in the statement at line 2 and column 69 (Invalid expression ? found, dynamic parameter references not allowed). I'm getting this #700 error only when using parameters. -- Charalabos Michael - [Creation Power] - http://www.creationpower.com - http://www.creationpower.gr |
Mon, Jan 22 2007 8:30 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< I'm getting this #700 error only when using parameters. >> I can't replicate this. This code: with EDBQuery1 do begin SQL.Text:='INSERT INTO Customer (CustNo, Company) VALUES (:Param1, :Param2)'; Params[0].AsInteger:=100; Params[1].AsString:='Test'; ExecSQL; end; doesn't do it, for example. Could you send me the catalog that you're using ? There's no need to send the table itself. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 7 2007 10:23 AM | Permanent Link |
Charalabos Michael | Hello Tim,
> << I'm getting this #700 error only when using parameters. >> > > I can't replicate this. This code: > > with EDBQuery1 do > begin > SQL.Text:='INSERT INTO Customer (CustNo, Company) VALUES (:Param1, > :Param2)'; > Params[0].AsInteger:=100; > Params[1].AsString:='Test'; > ExecSQL; > end; > > doesn't do it, for example. Could you send me the catalog that you're using > ? There's no need to send the table itself. You've fixed in Build 7 but it doesn't intert the data into the table. Eg. Params[0].Text := 'Hello'; after posting the record the field's data is empty instead of 'hello'. -- Charalabos Michael - [Creation Power] - http://www.creationpower.com - http://www.creationpower.gr |
Thu, Feb 8 2007 12:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< You've fixed in Build 7 but it doesn't intert the data into the table. Eg. Params[0].Text := 'Hello'; after posting the record the field's data is empty instead of 'hello'. >> Thanks, it's fixed. It was an assignment issue with CLOB fields. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Feb 10 2007 8:34 PM | Permanent Link |
Charalabos Michael | Hello Tim,
> << You've fixed in Build 7 but it doesn't intert the data into the table. > > Eg. > > Params[0].Text := 'Hello'; > > after posting the record the field's data is empty instead of 'hello'. >> > > Thanks, it's fixed. It was an assignment issue with CLOB fields. I'm still having the same problem in build 8. Are you sure it's fixed ? -- Charalabos Michael - [Creation Power] - http://www.creationpower.com - http://www.creationpower.gr |
Sun, Feb 11 2007 10:01 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< I'm still having the same problem in build 8. Are you sure it's fixed ? >> Most definitely. I just tried it again and it worked fine. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, May 23, 2024 at 03:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |