Servoy Forum

I have looked through the forum and I have found how to conduct an SQL query to do a lookup seems to cause people to be confused - but also people who answer the queries simply say this is very basic stuff look at the documentation. Unfortunately, for me, the documentation has not lead me to the right answer..

I have contemplated doing a Find and Search... but to do this I need to "set autosave on" and that makes me nervous cause I am validating a record being entered and don't want it to be commited to the database. Also, the project_name that I am validating is now a value is bound to the table so find and search may include this new value..

I tried rawSQL but there are heavy warnings on usin this so I suspected this is not the way to go.

Finally, I tried using datasets...

Like below
var vQuery = 'SELECT project_id FROM projects WHERE project_name = ?'
var vArgs = [project_name]
controller.loadRecords(vQuery,vArgs)
application.output(controller.getMaxRecordIndex())

But you cannot do this because as you are validating a new record to the table projects and Servoy tells you that there are updates required to the foundset and it doesn't work...

Please could you tell me if I am barking up the wrong tree - I suspect I am? I didn't come to the forum on this occasion without looking at the docs, tutorials and not having experimented. SO I think I am missing something.

PS I have also been looking at the possibilty of stopping a field having duplicates on the database but I cant seem to find out how to do that.

Thanks in advance. I hope you undertsand what I am trying to say.

Kind Regards
Jonathon

Code: Select all

var ds = databaseManager.getDataSetByQuery(yourServerName, vQuery, vargs, -1);

Then use the ds DataSet for whatever you need, just don't load records in the controller:

Code: Select all

for(var i = 1; i <= ds.getMaxRowIndex(); i++) {
    ds.rowIndex = i;
    // now ds is pointing to a row, you can get the value you want:
    var id = ds.project_id;
    // and do something with it.
}

Really appreciate your feedback. Again

Yep, I understand what you are saying and that is very very logical.

Thanks
Jonathon