Page 1 of 1

More DBPro commands

PostPosted: Tue Aug 28, 2012 4:55 pm
by 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.

PostPosted: Wed Aug 29, 2012 10:31 am
by 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

PostPosted: Wed Aug 29, 2012 12:16 pm
by 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" ""

PostPosted: Wed Aug 29, 2012 5:15 pm
by 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.