Search options (Page 1 of 2)

Hello once again,

I have moved my database from SQLite to MYSQL and now the TDataSet is not populating any fields (textboxes / comboboxes). I am not getting any errors, only that the fields are blank.
How can I solve this to work with Mysql as well? Is there another approach?

Thank you.
Alin

Hello all,

I encounter a problem now with the SQLQuery. I have textboxes, comboboxes and checkboxes to asign values to.
For textboxes, it's clear, I have string values, for comboboxes i used integer but I can't figure it out how to asign the values to the checkboxes. I tried also with Integer , string or boolena but is not working.
Can somebody help me to asign the value to the checlbox as well?

Thank you.

BR,
Alin

Hello tcoton,

You're right, but this SELECT statement is for the search form and it populates a tablegrid.
NOw, from this table grid, I would like to create a Select statement and send the information to the edit form based on ID.
When the ID is passed to the edit form, there I have to create a bunch o Select statement for each textbox to hold the values.

I was thinking that maybe is a possibility to create a single SELECT statement which holds all the information and then to assign to the textboxes. I have read something about Recordset, but I am not sure how to do it.

Thank you.

BR,
Alin

Hi vovka3003,

I will try this and let you know.
I thought that this will be easier to get translated

thank you.
Alin

I'm using SQLite.

Hello Derek,

I've managed to solve that issue, but now I bump into another thing.
I want to print labels.
I've created the layout and now the number of labels which need s to be printed depends on the order quantity.
For example: Order 4000 pieces, 500 pieces per box means 8 labels needs to be printed. I need also to put an increment on each label like 1/8, 2/8 ...8/8. (this I've done)

How can I achieve this the easiest way?

For the moment, I let the report in designer mode and enter the required labels in Page Counter and then print . I would like to block access to anyone to modify the layout of the labels.

Any help is appreciated.

Thank you.
Alin

Thank you Derek.
It's working.

Hello Derek,

Thanks for your answer.
i changed the type of the field from real to currency and the issue is still there.
I've checked was has been saved in the database, and there the value is stored correctly so...perhaps the issue comes from the select statement  I have.
My form contain 2 table grid views, one is with the articles and when i click on one article, the second  table grid is populated with the right Bill of material.

My Select statement looks like this:

frmArticole.grdBOM.dbSQL := 'SELECT tblBom.id,BOMName,ArticleNo, ArticleName,Quantity,UmNo,  ' +
           ' Case Active when 1 then "Da" when 0 then "Nu" End, ' +
           ' Case Fixed when 1 then "Da" when 0 then "Nu" End ' +
           ' from tblBOM ' +
           'inner join tblArticol on tblBom.id_tblArticol1=tblArticol.id ' +
           'inner join tblBomType on tblBom.id_tblBomType=tblBomType.id ' +
           'inner join tblUm on tblBom.id_tblUM=tblUm.id ' +
           'where id_tblArticol= '+ frmArticole.txtCODID.text + ;
     frmArticole.grdBOM.dbListFieldsNames:='ID,Tip BOM, Nr. Articol, Nume Articol, Cantitate,UM, Activ? ,Fix?';
      frmArticole.grdBOM.dbSQLExecute;

How can I change the Quantity in the select statement to show me the right value?
Thank you.

Br,
Alin

Thank you ehwagner,

it's working.

Best regards,Alin.