Search options (Page 3 of 4)

Hello, I am adapting your Login form with password change to a database in Mysql, (10.1.34-MariaDB), and cause several problems in the syntax of the query. Example

Before:

SQLExecute ('INSERT INTO users (login, password, read, write, remove, search, administrator) VALUES ("admin", "admin", 1, 1, 1, 1, 1);');

After. (works):

SQLExecute ('INSERT INTO users (login, `password`,` read`, `write`,` remove`, search, administrator) VALUES ("admin", "admin", 1, 1, 1, 1, 1); ');

In this I have problems:

s: = VarToStr (SQLExecute ('SELECT count (id) FROM users WHERE (login =' '' + frmLogin.edUser.Text + '' ') AND (password =' '' + frmLogin.edPassword.Text + '' ' ); '));

What would be the correct one for this problem?

Hello everyone.
I'm doing a query on mysql and it gives me a problem. There are text fields in the table that have special characters like "í" and "ñ". That's why I do not get results when doing the query.

I think of a way of solution, create a field where you can put the text without the special characters from a form, or when you enter the text with special characters save it without them in the new field.

Example: name_expecial: "Toño Año"
                name_normal: "TonoAno"

Hello...
How can I add items to the menu that comes by default in the application?

English:
Hello friends, I tell you about my project, what I am doing is a student management system, at first I supported the example that comes with the installation of MVD, but it has already changed a lot. This project I am doing to donate it to a school that has students from all over the country and does not have a system to manage them. During its construction I have relied heavily on their ideas and contributions, that is why I decided to upload it in order to solve some of the errors and inconveniences that I see in the project. Any help and contribution is very grateful ...

Problems:

1- In the "frmMain" form, the "bPrint1" button is used to print the selected records in the "TableGrid1" grid, but it gives me an error. The problem is in the checkbox (I can not print with multiselection and I can not print the status of the chekbox)
http://myvisualdatabase.com/forum/viewtopic.php?id=4002

2- When I add a new student "frmMain.bAdd" the new registration form "frmStudent" opens. If I go through the logical steps of starting to add data by name, last name, etc ... everything is fine. But if by chance I start with the students' exam grades and I regret and click on closing, I automatically generate a blank record of exam grades and a new student.

3- In the statistics tab (where an image of a Cuba map appears) thanks to EHW and Derek I managed to put a pie chart, now ..., I want to put in each one of the circles (represent the provinces) the quantity of students that correspond to that province (Example: frmMain.label_spain.Caption: = SQL code)
http://myvisualdatabase.com/forum/viewtopic.php?id=4024

For me those are some inconveniences that I see, if you want to contribute something I thank you very much.

Español:
Hola amigos, les cuento sobre mi proyecto, lo que estoy haciendo es un sistema de gestion de estudiantes, al principio me apoyé del ejemplo que viene con la instalación de MVD, pero ya ha cambiado mucho. Este proyecto lo estoy haciendo para donarlo a una escuela que tiene estudiantes de todo el país y no tiene un sistema para gestionar a los mismos. Durante su construcción me he apoyado mucho en sus ideas y aportes por eso he decidido subirlo para poder solucionar algunos errores e inconvenientes que le veo al proyecto. Cualquier ayuda y aporte es muy agradecida...

Problemas:

1- En el formulario "frmMain", el botón "bPrint1" es utilizado para imprimir los registros seleccionados en el grid "TableGrid1", pero me dá un error. El problema está en los checkbox (no logro imprimir con multiselección y tampoco logro imprimir el estado de los chekbox)
http://myvisualdatabase.com/forum/viewtopic.php?id=4002

2- Cuando doy en añadir nuevo estudiante "frmMain.bAdd" se abre el formulario de un nuevo registro "frmStudent". Si voy por los pasos lógicos de empezar a añadir datos por nombre, apellidos etc..., todo marcha bien. Pero si por casualidad empiezo por las notas de los exámenes de los estudiantes y me arrepiento y hago click en cerrar, automáticamente se me genera un registro en blanco de notas de examen y de nuevo estudiante.

3- En el tab de estadística (donde aparece una imagen de un mapa de cuba) gracias a EHW y Derek logré poner un gráfico de pastel, ahora..., deseo poner en cada uno de los circulos (representan las provincias) la cantidad de estudiantes que corresponden a esa provincia (Example: frmMain.label_spain.Caption: = SQL code)
http://myvisualdatabase.com/forum/viewtopic.php?id=4024

Para mi esos son algunos inconvenientes que veo, si desean aportar algo se los agradesco mucho.