Search options (Page 1 of 34)

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

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

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

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!!

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?

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.

Hi,

thanks Sparrow, there is just a little bug: when performing "serial" imports ( multiple imports one csv at a time) without closing the import form, once the check box "Column name as first row" has been ticked and one import completed, if you open another csv file and leave the checkbox ticked, the first row does not display the column names when ticked out! The key is to untick "Column name as first row" before opening another csv file.

It is not a bug, it is the very intended purpose of the option cascade delete!! Deleting data linked with a relationship (foreign key) could lead to orphan entries.

If you want to delete data in a parent table while keeping the data from children tables, do not use delete cascade.

https://www.databasestar.com/on-delete-cascade/
https://www.sqlite.org/foreignkeys.html
https://www.sqlitetutorial.net/sqlite-foreign-key/

Alright, I got it covered... this works to insert data from MVD to SQL Server:

procedure PROCEDURE_NAME_Button1_OnClick (Sender: string; var Cancel: boolean);
 var
  Conn : Variant;
  db_settings,Col1,Col2 : String;
begin

  // ***  create database objects ****
   Conn :=createoleobject('ADODB.Connection') ;


   //*** set database connection parameters ***
  db_settings:='Provider=SQLOLEDB;Server=********;Database=********;UID=********;PWD=*******************;

  //*** Open connection to database ***
  Conn.Open(db_settings);

  //*** Insert data into SQLServer Database ***
  // Format of VALUES() ==> if source field contains only numbers: ‘+<name_of_field.txt>+’   if source fields contains varchar ==> ‘’’+<name_of_field.txt>+’’’   (triple single quotes)
  // One Conn.Execute() per insert.


Conn.Execute('INSERT INTO [TABLE_NAME] (Col1,Col2) VALUES ('+FORM_NAME. FIELD_NAME1.Text+','''+FORM_NAME. FIELD_NAME_2.Text+''')');  //example using fields as datasource
//Conn.Execute('INSERT INTO [TABLE_NAME] (Col1,Col2) VALUES (111,’’VARCHAR_TEXT’’)’); //example using direct data (double single quotes only for varchar text)
     //Always close connection after each transaction
     Conn.Close;
end;

@Sparrow

Yes it does but then, if you set a date column not null, you must set a default value and the default value 'now' that works in SQLite does is not accepted by MysQL/MariaDB, there is an error and the table cannot be created,  hence my answer with the correct format above your comment.

Another hiccup when connecting to a fresh database with no tables in MySQL/MariaDB from a MVD project, it tries to create twice the table "_user", throws a duplicate error and creates a useless table "_mvd_roles". This never happens when connecting to an empty database from a compiled project. I tried it multiples times when testing my Delete - Import routine. You can also, as I mentioned before, connect the application to an already filled up database containing the exact structure required with no problem at all.

The subject of this post was really about the default value of a Date column when not null is forced in MySQL.