Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2010, 09:33 AM
dapidmini dapidmini is offline
Junior Member
 
Join Date: Dec 2010
Posts: 3
Default syntax error in FROM clause?

I'm trying to insert some data into my table with adoquery in delphi. but the error message "Syntax error in FROM clause" keep happening. neither my database or table name have spaces. so what do I do? here's the code I'm using:
Code:
Adoquery1.sql.clear;
adoquery1.sql.add('INSERT INTO trans ( field1 , field2 ) VALUES ( ');
adoquery1.sql.add(quotedstr(myvar1[1]) + ' , ');
adoquery1.sql.add(quotedstr(myvar2[1]) + ' ) ');
adoquery1.execsql;
========= SOLVED ========= (i think?)
somehow it's not raising an error anymore...

Last edited by dapidmini; 12-17-2010 at 08:50 PM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 06:53 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.