Whats wrong with this?
-
create table incoming_mac_records(Date_Received date, Received_by varchar(100), Delivered_by varchar(100), Invoice_number int, Purchase_Order int, Model varchar(1000), Specification (1000), Quantity int, Serial_number int, Sticker_number int, Asset_tag varchar(50), Warranty_expiry date, Issued_to varchar(100), Site varchar(100), Department varchar(100), Amount int,Date_inserted timestamp,insert_by varchar(100)); -
create table incoming_mac_records(Date_Received date, Received_by varchar(100), Delivered_by varchar(100), Invoice_number int, Purchase_Order int, Model varchar(1000), Specification (1000), Quantity int, Serial_number int, Sticker_number int, Asset_tag varchar(50), Warranty_expiry date, Issued_to varchar(100), Site varchar(100), Department varchar(100), Amount int,Date_inserted timestamp,insert_by varchar(100));- how is this Qt related?
- what is your question?
-
- how is this Qt related?
- what is your question?
-
create table incoming_mac_records(Date_Received date, Received_by varchar(100), Delivered_by varchar(100), Invoice_number int, Purchase_Order int, Model varchar(1000), Specification (1000), Quantity int, Serial_number int, Sticker_number int, Asset_tag varchar(50), Warranty_expiry date, Issued_to varchar(100), Site varchar(100), Department varchar(100), Amount int,Date_inserted timestamp,insert_by varchar(100));@Aquarius171 I guess you forgot the data type:
Specification (1000),Before asking such questions (without even mentioning the error message!) you should take a closer look at your stuff by yourself instead of asking others to do it for you...
-
@hskoglund Thank you !!!! :))
-
@the_ ohh sorry i forgot to indicate i will use it on my qtsqltable view
Maybe you should check for any error messages that will be generated when executing this.
QSqlQuery::lastError()will tell you whats wrong.
or you try to execute this query within your SQL tool (which sql database will you use?) -
@Aquarius171 I guess you forgot the data type:
Specification (1000),Before asking such questions (without even mentioning the error message!) you should take a closer look at your stuff by yourself instead of asking others to do it for you...
@jsulm sorry
-
Maybe you should check for any error messages that will be generated when executing this.
QSqlQuery::lastError()will tell you whats wrong.
or you try to execute this query within your SQL tool (which sql database will you use?)@the_ thank you sir for your time
-
@Aquarius171 I guess you forgot the data type:
Specification (1000),Before asking such questions (without even mentioning the error message!) you should take a closer look at your stuff by yourself instead of asking others to do it for you...
@jsulm okay sorry thank you for your time
