You can delete the existing .def, it will be recreated using the new dll on your next project compilation.

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

3

(8 replies, posted in General)

mouasomar wrote:

I can't import database

Are you trying to import a CSV file and does it contain double quotes to define the data? like so: "1","random text","random data","654567678987"

if so, try to edit your CSV file to remove the double quotes "   " and import again. I have had this problem that data would be imported if the CSV was created in Microsoft Excel which does add the double quotes " ".

4

(20 replies, posted in General)

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

5

(20 replies, posted in General)

Did you create the gmail application password?

https://mailtrap.io/blog/gmail-smtp/

6

(20 replies, posted in General)

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

7

(20 replies, posted in General)

What is not working actually, do you get ab error message? Please not that using Gmail is a bit tricky especially for the authentication as stated in the post linked previously.

8

(13 replies, posted in General)

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

The first query is actually a simplified form of an inner join https://www.techonthenet.com/sqlite/joins.php.

If you get an error because there is no select total() function, you have to create the alias total_quantity as per the second query in your message.

https://www.sqlite.org/lang_select.html

10

(8 replies, posted in General)

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.

11

(8 replies, posted in General)

identity wrote:

I tried to convert excel file to csv format but I couldn't so I only have Excel files

I think, the very first step would be to get the CSV files: https://www.exceldemy.com/convert-excel … delimited/
Every version of MS Excel, libreoffice or OpenOffice, even Mac OS Numbers can do that.

Or you can go through the links provided by Sparrow but this is more advanced.

To import data:

You can create a button with no action on your form with an OnClick event like so:

procedure Form1_ButtonImportData_OnClick (Sender: TObject; var Cancel: boolean);
begin
Form1.mniImportData.Click;
end;

Or you can use SQLiteStudio to import the data directly into the tables of your choice, but this is working directly in the database.

I found out that using the button to import CSV data coming straight from Excel was difficult due to Excel using double quotes for data and that is trouble, you might have to edit the CSV files in notepad or notepad++ to remove all double quotes.

12

(5 replies, posted in Script)

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

13

(5 replies, posted in Russian)

The ambiguous "id" error comes from your script where the id is not defined (which table.id?)

Новичок wrote:

Подскажите пожалуйста, вычисляемые поля работают в MySQL или в них запрос немного отличается в отличии от SQLlite


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

Boolean values are stored as 1 or 0 in the database, where do your valueasbooleanxxx come from?

16

(4 replies, posted in Script)

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)

;

17

(4 replies, posted in Script)

You mean getting the names of the month on the X axle  instead of the 1 to 12 ?

18

(18 replies, posted in General)

pavlenko.vladimir.v wrote:

Он должен вернуться, просто он немного перегорел. Вполне возможно, что именно сейчас он создает новый конструктор


That would be awesome!!

19

(4 replies, posted in General)

k245 wrote:

This happens if you open other people's projects. Open any form and edit anything. This will signal the recompilation of the forms file that stores the license information. This is a feature of this version - to recompile you need to edit something on the project form.

Thanks, that was it, I did not know about this feature and I was actually just opening a project straight from the forum without modifying anything!!

20

(13 replies, posted in General)

sparrow wrote:

But overall the program is working.

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.

21

(13 replies, posted in General)

Hi,

As I am interested in charting data with MVD, I had a try at the DIAB fixed project but when compiling with MVD 6.5, I get an Access violation at address 00E3CEF0 in module "Diabetes.exe".

Script position 303:8 that is:   

 If Form1.CheckBox1.Checked then
       ChartLine.View3D := True;   

Did you get it working Jean?

22

(4 replies, posted in General)

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

23

(4 replies, posted in General)

Hi all,

I do have a lifetime license and even though the "About" displays that MVD is registered to my name, I cannot compile anymore with an alert telling me that the trial period has expired. Anyone using the 6.61 beta had this problem too? How to get it to work again?

https://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=10333

24

(2 replies, posted in SQL queries)

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.

25

(5 replies, posted in General)

The data values in your example is not really helping to get a hold on what is what. Could you send a project with realistic data?

As far as I can understand it with the elements above is that you need to count how many trees grouped by kinds and concat that for #1 and sum the count of each type for #2.

Am I right?

What you count is what is in the database, not what is in grid from another form.