Direct SQL mode of the Database Retrieval component allows freely-formatted SQL SELECT statements of any degree of complexity to be added to the procedures. The SQLCommand system function can be used to run SQL statements that add, update and delete rows in the database tables.

Unfortunately, the official specifications are not freely available (ANSI makes them available for purchase). However, there are books - such as SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer - which give a comprehensive overview of the standard, including coverage of stored procedures.

You can modify the source code of X-Cart to integrate it with any database. However, X-Cart is a very complex software which consists of more than 200 PHP files. We recommend you converting your current database to X-Cart format. This can be done by using the import feature of X-Cart. We can also create a custom conversion tool for your database. This kind of service costs from $50. You can contact us for more details.

The TCL time or clock commands are useful for timing statements. More information is available in the documentation.

No. The new statements are in addition to, not instead of, the traditional fund statements. GASB recognizes the value of fund statements in demonstrating fiscal accountability , while the new government-wide statements demonstrate operational accountability .

ERM covers between 85% and 95% of the critical functions of every Small to Medium Business. However, should the needs arise, additional features can be added for a sliding scale amount, and depending on how likely they would be useful by other potential or existing customers. Furthermore, if your company requires certain aspects of your existing system to be integrated with ERM, our service is available.

Yes, we integrate across most legacy and back-office systems and applications including POS, inventory, labor, purchasing, cash management, financials, human resources, ERP, and purchasing.

Simply plug it in. There is no special software you need to install. When Intradisk is up and running configured to your network, you have multiple options to to access your data:

Yes, CreativeCommerce software can fit into any existing design. One option is to copy the HTML of the surrounding of your existing web pages, and paste that into the "header & footer" files of your new store. This way the store will look the same with you company logo and design. Another option you have is to keep your existing website 100% and simply change the link of your "add to cart" buttons to link to your new shopping cart..

You will need to edit the two gallery pages (index.php and view_album.php) to include any additional content and the style sheet (general.css) in the assets folder. Full instructions are included in the README. Please note that we can integrate SelectaPix for you, but we will charge for this service. We do not offer (free) advice on integration.

If you wish to integrate with an existing relational database (eg. you have several related tables) you will need to define the SQL statements to link to your table structure so information can be extracted and stored in the various tables.

Yes, volusion software can fit into any existing design. One option is to copy the HTML of the surrounding of your existing web pages, and paste that into the "header & footer" files of your new store. This way the store will look the same with your company logo and design. Another option you have is to keep your existing website 100% and simply change the link of your "add to cart" buttons to link to your new shopping cart..

The Vcheck system allows existing forms or ordering systems to be integrated with the system by storing any additional forms fields sent in a call for the check form which are written to the check details file. Additionally, specified form fields can be sent back to a specified URL for final processing. In other words, you can have any other type of "pre-Vcheck" form that calls the Vcheck form as its form action. All the form field pairs are written into the Vcheck Form as hidden input fields.

Cortex can authenticate network users from industry standard RADIUS and LDAP servers. A very common example of LDAP servers is Microsoft Active Directory. Cortex administrator can also put access policies based on LDAP group membership or RADIUS attributes. For example members of the Windows group "administrators" can be given access to servers while non members this group can be denied this access. Absolutely. Cortex can store usernames and passwords in its local database.

Yes! Ximagi's top navigation can be changed to match your existing site and to link into it. And Ximagi's style can be altered to match your existing look and branding.

Yes, you can. In fact, iRealty v.3.0 and above have a new Smarty-based template management system that allows you to integrate the iRealty system into the existing web site.

One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the "EXECUTE IMMEDIATE" statement (native SQL). Examples: begin EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)'; end; begin execute Immediate 'TRUNCATE TABLE emp'; end; DECLARE var VARCHAR2(100); BEGIN var := 'CREATE TABLE temp1(col1 NUMBER(2))'; EXECUTE IMMEDIATE var; END; Users running Oracle versions below Oracle 8i can look at the DBMS_SQL package (see FAQ about Dynamic SQL).

Yes, run the "Queries with Table Hints", "Queries with Query Hints", and "Queries with Join Hints" to find this information. Please, keep in mind that the filtering option: "Show Top (in %): N" will filter the top queries with most executions and then it will check them for Hints usage; this lowers quite a bit the impact on the server when running this report. reports.

It is dependent on the license of PTReportGen you have purchased. For detailed information, see Licenses.