edit: i have tried to use open database in dbpro withdbpOpenDatabase "TESTDB" "Data Source=[PubDir]test.db;Provider=MSDASQL.1;Persist Security Info=False;Data Source=SQLite Datasource"( i dont know if this is the right way)

and use dbpGetTableNames "TESTDB" "," "[list]"

it shows blank...

edit: this one worked.. and i got the tables to show up..dbpOpenDatabase "TESTDB" "Provider=MSDASQL.1;Driver=SQLite3 ODBC Driver;Database=[PubDir]TESTDB.db"

I do not understand well what is the doubt, the help of dbpro facilitates the creation of bases and their tables, as well as "fill" these with existing information (from other bases) dbpCreateAccessDatabase, dbpCreateTable, dbpImportFromCSV ...Could you explain it in Spanish?

I do not understand well what is the doubt, the help of dbpro facilitates the creation of bases and their tables, as well as "fill" these with existing information (from other bases) dbpCreateAccessDatabase, dbpCreateTable, dbpImportFromCSV ...

... you might take a look at a general purpose utility (AccessDBU) that I built many years ago ...

1) Free2) ready to use with a WAMP (Windows/Apache/MySQL/PHP) package available to download/install HERE3) multi user - no problem across a network4) easy quick management tool built in via PHPMyAdmin (create databases/tables/import/export, etc)

While there are a few syntax differences from Access, the web is full of answers for MySQL which is used on the majority of websites.

I have created an inventory application with DBPro and MySQL that has made significant differences in my workflow.

Express version is free and Management Studio its just dump-proof... its supper simple to get up developing databases with it...

I only built one application using DPPRO and SQL Server, its still up running no problems on a few tills (DVD Rentals management)... I make use of dbpExecSQL for the entire code, you just cant rely on the other commands, sometimes they just go spastic with different database engines, its a lot better to build your queries to make sure you're gonna get the desired result. Since then I moved into C# so thats my one experience with dppro and an actual database engine.

dbpOpenTable should work with mySQL. You might try using dbpGetTableNames and see if it returns a list of table names in the database. If it does, then make sure you're using the same exact table names with dbpOpenTable.

yanzco wrote:im really having a bad time with this..can someone help me / teach me.. the basics of creating a mysql or sqlite database and the opening tables, adding, editing, querying commands?...

for example..if i have a big database.. and i want to get a specific record data on it.. what would be the command using dbpExecSQL

or like, if i want to show a table in a rect.. just like showgrid..how can i do that with dbpExecSQL using mysql or sqlite...

To create your initial database, some of the other tools that often come with the db server can be helpful. For example, if you install a WAMP server (Windows / Apache webserver / MySQL / PHP) - do a google for wamp for download - you will have included and already installed: PHPMyAdmin. This is a web tool to create databases and tables, etc. It is easier to start with a database and tables and then add content IMO. There are similar tools available for sqlite I know.

To find a specific record, you have to Open the DB , open the table, then do a SQL "SELECT" command (w3schools is a very helpful place for syntax on sql commands). Typically it is like this:

SELECT * FROM tablename WHERE 'columnname=desiredvalue'

This will choose all the column values of all records that have the desired value in that column. It is also possible to have the select choose only certain columns for display. Again, read the tutorial at w3schools.