Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "mysql"

Can I link MTH to an existing external database

Publication date: August 10, 2018

Hi,
Just wondering can I link the MTH frontend onto an already existing MySQL database?

Many thanks
Regards
AndyB

Caspio, forms, tables, videos

Publication date: August 15, 2018

Hi team,

There are few questions :-

Can I manage my sql tables ??
Can we see our tables in MTH ??
Can I create forms ??
Is it similar to caspio ??
Can you send me your video tutorial ??

I basically wanted a tool from where I can create application without knowing coding.

Thanks
Mohit

User's manual

Publication date: August 15, 2018

Hi,

I’ve been working with Microsoft Access for several years and I’m used to use it’s standards.
It’s very difficult for me to understand MyTaksHelper’s philosophy as to database basics, eg. tables, indexes, references, SQL-queries, views, etc.

I would also like to know whether it is possible to create 1:many forms in MyTaksHelper. For example I have one record in Tasks table and it has several “subrecords” (subtasks) stored in (sub)table called Subtasks.

Another problem is that I do not understand how to build comboboxes (dropdown) which are based on lookup tables. For example:
lookup table: Persons (id_person AUTOINCREMENT, name VARCHAR)
Tasks: (id_task AUTOINCREMENT, id_person TINYINTEGER, …)
There a 1:many relation between Persons and Tasks.

Is there a complete manual (brochure) about how to use MTH?

Thank you very much for your time.

SQL Bulk-updates for records

Publication date: August 20, 2018

Right now if we want to make a large update to existing records it appears the most efficient way is to export the table, clear it, apply the update externally, and then reimport the table.

Can SQL be exposed for power users to update existing records?