-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
My Program Is Working Very Slowly
- Thread starter jothis
- Start date
- Similar Threads Similar Threads
Table -> SQL
You can use the 'CreateSQLTable( )' command of the sql connection control, which creates a database table from a Table control - but you should also create an index; it can speed up db access more than 10x..
Although 'ExecuteTable' will load the table control from the results of a database query, you have to execute 'Update' SQL commands to get changes back into the db. (or Insert, for new data). Use Command Parameters, to save worrying about delimiting data containing quote characters, and also to prevent SQL insertion (if the data is entered by the user).
You can use the 'CreateSQLTable( )' command of the sql connection control, which creates a database table from a Table control - but you should also create an index; it can speed up db access more than 10x..
Although 'ExecuteTable' will load the table control from the results of a database query, you have to execute 'Update' SQL commands to get changes back into the db. (or Insert, for new data). Use Command Parameters, to save worrying about delimiting data containing quote characters, and also to prevent SQL insertion (if the data is entered by the user).