Source language: Translate to:

More DBPro commands

Post your suggestions for future versions of NeoBook

Moderator: Neosoft Support

More DBPro commands

Postby BRobinsonS » Tue Aug 28, 2012 4:55 pm

    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.
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada

Postby Neosoft Support » Wed Aug 29, 2012 10:31 am

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

SQL tutorial:

http://www.w3schools.com/sql/default.asp
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5605
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby josesito » Wed Aug 29, 2012 12:16 pm

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" ""
josesito
 
Posts: 53
Joined: Sat Sep 26, 2009 6:44 pm

Postby BRobinsonS » Wed Aug 29, 2012 5:15 pm

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.
Brian Robinson
'When all else fails, try again!'
www.ComputerSoftwareSystems.com
User avatar
BRobinsonS
 
Posts: 340
Joined: Sun Sep 25, 2005 9:00 pm
Location: Ontario, Canada


Return to NeoBook Suggestions

Who is online

Users browsing this forum: No registered users and 0 guests