Search options (Page 1 of 34)

You might have to replace the sqlite.dll to get it updated to the most recent version. https://www.sqlite.org/2024/sqlite-dll- … 460000.zip

Does it work if you use non secure connection in MVD? (Port 25) https://support.google.com/a/answer/176600?hl=en

Have you tried to send an email from an email client using the parameter in use with your application? Does it do the same?

The search link for this forum is at the very top right of the page 3rd from the right, 4th from the left

You are using a database like an excel spreadsheet, this is not at all the way a database works, you should have a table for the patients containing first name, last name and other patient related information and they must be unique, they are identified by a unique ID. You should have a table containing the medication names with maybe details about the medication. You could also have a table for insurances. Then you use relationships to link the patient to the medicine and the insurance. Then you have a table that stores all these information together using ids. Have a look at the Myvisualdatabase inventory example.

You might want to look at this post to understand the loop you are trying to use: https://myvisualdatabase.com/forum/view … hp?id=8920

Yes calculated fields are working when connected to MySQL, you just have to adapt the SQL Query to match MySQL syntax if an error occurs. The calculated fields are actually not stored in the database, they are written in plain text in the tables.ini file.

For date calculation, a quick search on internet like here : https://dev.mysql.com/doc/mysql-tutoria … tions.html

You can also use this form for the Sql Query with sqlite:

 SQLQuery('select substr('JanFebMarAprMayJunJulAugSepOctNovDec', 1 + 3*strftime('%m', date), -3) AS Lab FROM bar_data ORDER BY date DESC', Results)

;

That would be awesome!!

Which version of MVD are you using, I did not modify the project, I just want first to see how it works and it does not even start, it trows away the access violation error.

Actually, it compiles but it is the generated .exe that throws the error.

Please keep ids as integer type in the database as that is what it indeed is especially for auto increment. Sometimes, in some querys you might need to transform an integer to string and vice versa which can be accomplished by using strtoint(your field here) or inttostr(your field here). That is especially true with sqlite when comparing data in the same query that must match a certain type.

What would help is to have the real error message as « the code does not work » is vague. To help you further, when a sql error is produced in MVD you can display the query to see where the error is.