Search options (Page 15 of 16)

I think there's no parameterized sql statements. you can do escape_special_characters instead.
I hope they incorporate TSQLQuery later on.

For the other 2 questions. they will both not do anything harmful in your database. when logging in or if you try to fill it on your forms. They will be considered as text or numbers by the system.

This might help

You can only edit the script in there, but you can not compile it there

Just add begin end on the last part of your external pas (form1.pas and common.pas)

procedure HelloWorld (s: string);
begin
  ShowMessage(s);
end;

begin
end.

You're welcome. @thezimguy already said it tho "Just update the default sqlite3.dll that came with MVD to the current version and it will work. I tried to attach the current sqlite3.dll but upload was refused.". I just elaborated it with an image. I just think you overlooked it because it happened to me when i was trying sqlcipher to work. Cheers!

As for @ehwagner's code. You can replace the code in line 17 with

form1.ComboBox2.dbSQLExecute('Select id, (id||" - "||TableName) as val from MyTables');

Anyway, I think you don't need the first combobox approach. You can also use this to minimize the code.

SqlExecute('Delete From MyTables');
SqlExecute('Insert Into MyTables (id,TableName) select  ROW_NUMBER() OVER (ORDER BY name) as id, sm.name from sqlite_master sm where sm.name <> "sqlite_sequence" AND sm.name <> "MyTables" order by sm.name');
form1.ComboBox2.dbSQLExecute('Select id, (id||" - "||TableName) as val from MyTables');

did you try the try except?

try
    db_settings:=...
    Conn.Open...

    {query to get}
    res.Open...
except
    // your message here
end;

Check all the anchor of your Grid from the Object inspector.

There's no option to that for now. I hope MVD DevTeam can add this feature too. I'm looking forward to it too.

Yes it is possible to load data via script but why would you want to load it via script when you can load data on the Settings of the tablegrid1? Another option is to load data using search button with corresponding filters.
Here's a sample snippet of populating grid via script.

Form1.Tablegrid1.dbSQL := 'SELECT `date`,`items`,`value` FROM `sales`';
Form1.TableGrid1.dbSQLExecute;

Just use the Transaction statement START TRANSACTION and COMMIT e.g

try
    SQLExecute('START TRANSACTION');
    ...
    ...
    ...
    SQLExecute('COMMIT');
except
    SQLExecute('ROLLBACK');
end;

It will depend on how your script works or how you want it to work. You may want to add START TRANSACTION statement on the OnClick Procedure of the button, then the COMMIT on the AfterClick Procedure. You can attach some project here, what you want to do with Transaction and someone will give you workarounds. Cheers.

Check for Show Record Buttons. You might duplicated your Show Record Button pointing to your Grid.