@Paul-Colby you are correct. I should not program after 11 :)
The error is still persisting after the change though. That is because of an extra parenthesis at (glb_expiresat BETWEEN (:expiryFrom1 AND :expiryTo1)

@SGaist Indeed, you're right When I set the properties for my table I set that the number of rows was "1" so I have to create an "int" variable and then say that the number of rows is that variable starting from 1 and then increment that number on the loop.

Hi,

You should rather store the original error message in the database and to the translation when showing the database content.

lastQuery should return the actually query that ran against the database, that one would be interesting to see.

Good point of @paul-colby

@mrjj Ok so, it seems that it doesn't detect the table "usuarios" even though it's there...

So in my sqlite editor I executed the command and it worked properly:
http://s18.postimg.org/iqry91pmx/image.png

EDIT: I solved that problem: the program was searching the db in the remote directory not in the real directory, now it doesn't says any error but It doesn't shows the information.

I've tried (SELECT * FROM usuarios) but nothing, it doesn't works.

2ND EDIT: I solved the problem, it was on my printing method, I tried a much simpler methor by doing:

int i=0; while (query.next()) { ui->tableWidget->setItem(i,0,new QTableWidgetItem(query.value(0).toString())); ui->tableWidget->setItem(i,1,new QTableWidgetItem(query.value(1).toString())); ui->tableWidget->setItem(i,2,new QTableWidgetItem(query.value(2).toString())); i++; ui->tableWidget->insertRow(i); }

Thank you for your help.

@alex_malyu Thanks a lot

@SGaist I don't mind refactoring it, it's not very long. I will definitely look into this. Thanks!

BTW, here is a link to a related post:

http://forum.qt.io/topic/29289/solved-qt5-1-android-how-to-bundle-and-use-sqlite-database-in-application

@Kofr
Hello,
Your SQL is incorrect. Create the table and then insert the rows.

QSqlQuery query("CREATE TABLE tasks (taskId INTEGER, PRIMARY KEY(taskId))"); if (!query.exec()) ; //< Handle error - table couldn't be created query.prepare("INSERT INTO tasks (taskId) VALUES (:id)"); // From here on you can have multiple calls to the same piece of code to insert multiple rows query.bindValue(":id", valueForInitialization); if (!query.exec()) ; //< Handle error - can't insert row

Additionally, I advise you to create the table once and for all. Then just fill it up, instead of trying to create it on every row insertion.

Kind regards.

@kshegunov Thanks I will try that.

@JoeB
You can give reputation points (the stars next to the name) by clicking on the up arrow or take such points by using the down arrow (for each post). You can bookmark posts with the favourite button. You mark the thread as solved by going down to the bottom, clicking the Topic tools button and selecting Mark as solved.

I'm using this code on the server. By blocking I simply meant that if one client requested something that took long to process it shouldn't block the other clients. I may upload a working sample of this code to github later.

Use a web service for that, there are several frameworks that makes it pretty easy.

After some time I respond to my self,
the solution was maked in Python with Pandas.

This link is very ussefull:
Iterating through groups on: http://pandas.pydata.org/pandas-docs/stable/groupby.html
Also the book "Python for Data Analysis, West McKinney" pag 255

This video show how to make calculation:
ANOVA 2: Calculating SSW and SSB (total sum of squares within and between) | Khan Academy
https://www.youtube.com/watch?v=j9ZPMlVHJVs

[code]```
def getDFrameFixed2D():
y = np.array([3,2,1,5,3,4,5,6,7])
k = np.array([1,1,1,2,2,2,3,3,3])
clusters = pd.DataFrame([[a,b] for a,b in zip(y,k)],columns=['Var1','K2'])
# print (clusters.head()) print("shape(0):",clusters.shape[0])
return clusters

X2D=getDFrameFixed2D()
MainMean = X2D['Var1'].mean(0)
print("Main mean:",MainMean)

grouped = X2D['Var1'].groupby(X2D['K2'])

print("-----Iterating Over Groups-------------")
Wss=0
Bss=0
for name, group in grouped:
#print(type(name))
#print(type(group))
print("Group key:",name)
groupmean = group.mean(0)
groupss = sum((group-groupmean)**2)
print(" groupmean:",groupmean)
print(" groupss:",groupss)
Wss+= groupss
Bss+= ((groupmean - MainMean)**2)*len(group)

print("----------------------------------")
print("Wss:",Wss)
print("Bss:",Bss)
print("T=B+W:",Bss+Wss)

Tss = np.sum((X-X.mean(0))**2)
print("Tss:",Tss)
print("----------------------------------")
//your code here

[/code] The next job is traduce to c++ or use Python on QT Greetings

I'm not familiar with Oracle, but this looks close enough to Postgresql that I'll show how I would do it in PG/SQL in hopes that it will be useful.

I would create the function in the database

CREATE OR REPLACE FUNCTIOM test_fucntion(_name TEXT)
RETURNS BIGINT AS $BODY$
DECLARE
_rv BIGINT
BEGIN
INSERT INTO test_table(name)
VALUES(_name) RETURNING id into _rv;
RETURN _rv;
END;
$BODY$
LANGUAGE plpgsql;

After adding that function to the database you can simply execute the query
SELECT * from test_function("name");
to get your ID.

As I said, this is Postgres code, but I'm pretty sure the Postgres authors imitated Oracle to some extent.

Mike

Obrigado Rodrigo!

Hi,

Since last version, the MySQL backend supports setting up SSL on the connection with CLIENT_SSL

Hope it helps

No you don't, again, just check what the LGPL license requires and conform to it, then you'll be good.

At the end it was a typo. I was trying to insert a value into a column called Localización by using:

guardar_s.prepare("INSERT INTO Solicitudes_Trabajo (Localizacion)

The problem is in the accent mark.

So if anyone gets this error, watch out the typos.

Thanks @clochydd !