More DBPro commands

[BRobinsonS]

1. This command dbpGetIndexNames gets the Index Names but doesn't show the fields making up the Index. I would like to know (for the absent-minded) if the fields have already been used for an index.

2. I would like the command to change field definitions or even field type
Example: Change ShortString: MyString(30) to MyString(50) without having to Delete the field (lossing info) and re-create the field.

[Neosoft Support]

You can use DBPro's dbpExecSQL action to do just about anything to your database.

SQL tutorial:

http://www.w3schools.com/sql/default.asp

[josesito]

Here is an example of how to change the field type:

dbpExecSQL "database" "ALTER TABLE tablename CHANGE fieldname fieldname VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL" ""

[BRobinsonS]

Thank you for that information.
SQL seems to be the way to go with databases.

I have been intently learning NeoBook and NeoBookDBPro with the goal to using them for my main development platform as opposed to Delphi 2009, FastReports and NexusDB which have become too expensive for me to keep up to date.

I enjoy programming but I'm in the hobbist category compared to others while working on my own projects (some for me, some for others) but respect the 'power of Neobook and NeobookDBPro' and other Add-ons.