Project Home
Project Home		 Trackers
Trackers		 Documents
Documents		 Wiki
Wiki		 Discussion Forums
Discussions		 Project Information
Project Info
IDE/Discussion/General/tutorial using QDB./List of Posts
Forum Topic - tutorial using QDB.: (6 Items)
   
Update
Afif Grahaditya(deleted)
11/27/2015 3:25 AM
post115134
tutorial using QDB.   
hello everyone

I'm want to create a database
I already make .sql and .cfg file extention,
I already connected to the database

now I have a problem, When I type INSERT INTO customers (firstname,lastname) VALUES (Afif,Fifa);
It give me error "near INSERT syntax error."

do you know why? I still confuse about it..

thanks
Elena Laskavaia
11/27/2015 1:11 PM
post115136
Re: tutorial using QDB.   
I think you posting to the wrong forum this is forum for Momentics IDE

However values in INSERT should be in single quotes

 INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');
Afif Grahaditya(deleted)
11/30/2015 9:12 PM
post115145
Re: tutorial using QDB.   
thanks for reply

I already using your advice but it's "ïnput/output error" like attached picture.
Attachment: Image qdb5.jpg 204.4 KB
James Thomson
11/30/2015 10:29 PM
post115146
Re: tutorial using QDB.   
One comment - I'd suggest using your own in-memory database.  We were using QDB in 6.5 and it was fine with high 
throughout - on moving to 6.6 the performance tanked and after some troubleshooting we moved away from it.

Thanks,
-James

> On Nov 30, 2015, at 8:13 PM, Afif Grahaditya <community-noreply@qnx.com> wrote:
> 
> thanks for reply
> 
> I already using your advice but it's "ïnput/output error" like attached picture.
> 
> 
> 
> 
> 
> _______________________________________________
> 
> General
> http://community.qnx.com/sf/go/post115145
> To cancel your subscription to this discussion, please e-mail general-ide-unsubscribe@community.qnx.com
> <qdb5.jpg>
Afif Grahaditya(deleted)
11/30/2015 10:39 PM
post115147
Re: tutorial using QDB.   
I'm working using QNX 6.5 too.. i don't know why it always said "near syntax error"..like in the picture.
Attachment: Image qdb6.jpg 213.52 KB
Afif Grahaditya(deleted)
11/30/2015 10:40 PM
post115148
Re: tutorial using QDB.   
> I'm working using QNX 6.5 too.. i don't know why it always said "near syntax 
> error"..like in the picture.

I think if I can make it with the sample program maybe I can make my own QDB after that.

Return


  A subsidiary of BlackBerry             All content ©2004-2013, QNX Software Systems