UC update release

This is the general discussion area. Anything and everything not related to Ubercode.

UC update release

Postby onykage on Fri Mar 19, 2010 2:01 pm

when will the next update for UC be released? Also what changes and or updates can we look forward to with the new release? And will you be released an RC version of the ide first?
onykage
Admin
 
Posts: 221
Joined: Sat Jan 03, 2009 8:28 pm
Location: Armpit USA
Programming languages: php, java, python, ubercode, easyuo, peril, cobal, pascal, ruby

Re: UC update release

Postby ubercode on Fri Mar 19, 2010 5:49 pm

Hello

The current release is version 1.2 - this is a full release available to all licenced users and there's an announcement on the news page http://www.ubercode.com/news.html

There's a list of everything in the version 1.2 release here: http://www.ubercode.com/version-history.html

This should be quite stable as it's being under development for a while. The next release (due later this year or early next year) will include the ability to build an installer directly from a compiled program, and it may include SQL Server express as a built in database.

Kind regards, Will
ubercode
Site Owner
 
Posts: 275
Joined: Sun Jan 04, 2009 3:46 pm
Location: UK Channel Islands

Re: UC update release

Postby onykage on Mon Oct 18, 2010 9:24 pm

SWEET!

SQL injection!!!

Its too bad ive had to write an entire lib just to do that very task :twisted:

all fun aside,

does the new SQL feature have security protocols to protect against sql injection threats?

Can you elaborate slightly on some of the features that the new SQL functions will have/not have?
onykage
Admin
 
Posts: 221
Joined: Sat Jan 03, 2009 8:28 pm
Location: Armpit USA
Programming languages: php, java, python, ubercode, easyuo, peril, cobal, pascal, ruby

Re: UC update release

Postby ubercode on Tue Oct 19, 2010 5:30 pm

Most SQL functions will be provided by a new helper library. Basically you create a connection to the database, you can save the connection, then you open it. When open you can retrieve single values, rows or entire result sets, and you can run commands in the database. Finally you close the connection. The helper library is called SQLUTIL and it contains:

Code: Select all
SqlLoginDialog
// Modal dialog that prompts for the database connection details, builds a
// connection string based on user input and optionally saves it in a file.

SqlConnection
// Public type for SQL connections.

SqlOpen
// Open a SQL database connection using settings from a connection string.
// Return the connection object and an optional error message.

SqlClose
// Close the SQL connection (safe even if the connection was never opened).

IsSqlConnectionOpen
// Return True if the connection is open or False otherwise.

SqlUseDB
// Change the current database in an open SQL Connection.

SqlTestConnection
// Test a connection to the database and show a success/failure message.

SqlCommand
// Run a command - This shows a message box if the connection is not open.

SqlLookup
// Run a query and return a single value, equivalent to:
// SELECT TOP 1 <columns> FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlLookupRow
// Run a query and return a single row, equivalent to:
// SELECT TOP 1 <columns> FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlCount
// Count the number of records matching an optional condition, equivalent to:
// SELECT Count(<columns>) FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlSelect
// Run a query and return a table (tabluar result set), equivalent to:
// SELECT <columns> FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlDatabases
// Return a list of databases matching the specified pattern.
// This shows a message box if an error occurred.

SqlTables
// Return a list of tables matching the specified pattern.
// This shows a message box if an error occurred.

SqlColumns
// Return a list of columns in a given table matching the specified pattern.
// This shows a message box if an error occurred.
ubercode
Site Owner
 
Posts: 275
Joined: Sun Jan 04, 2009 3:46 pm
Location: UK Channel Islands


Return to The Gap

Who is online

Users browsing this forum: No registered users and 1 guest

cron