 |
jWorkBook: Get Database information directly into your spreadsheet
Now a quick way to get the information that is currently in your system databases directly into your spreadsheet. jWorkbook is an Excel Add-In that enables you to build powerful queries to access the information directly and see the information in your Excel Spreadsheet. You can build reports quickly and interactively using the power of single or multiple SQL So.... the information you need is stored in the Oracle, Access or SQL database and you need to look at it and do some calcs and write a quick report? What are your options? Simple, find a programmer, tear him or her away from the thousand other jobs on the go and try to explain what you want. They will put your request into a queue and hey presto 3 months later you get the information you want...if you are lucky!
Enter jWorkBook: start up Excel, enter a simple SQL command....bang the information is there!
Not quite what you want? No problem, refine the command and run it again. Or add another command and run them both. Format the output in your spreadsheet, add a chart and you have your data in the format you want in a couple of minutes. Really that simple? You bet.
SQL is by far the most popular database language available today. It is used as the main form of communication by every database of note. It is extraordinarily powerful. But best of all, to do the vast majority of tasks, it is extremely simple. Unlike languages like C or Basic, you can do most of your data retrieval commands in a single statement. It is a fact that if you understand the English-like Select statement, you are probably 99% of the way to being self sufficient in retrieving your data from the database. Granted, as you get proficient in SQL, you will naturally extend your skills to more exotic structures but from day one, you are productive. But don't take our word for it, run through the tutorial and give it a try.
database query queries sql oracle access sql server excel tutorial create
|
 |
.NET Database Driven Application Generator, automatically generates multi-tier enterprise-level business applications. Everything is generated, database structure, logic layer, web forms, all SQL queries, and XML, VB and C# code. Simply define application objects in an intuitive visual design space, designate links from a clickable menu selection and choose GUI design and generate a working ready-to-deploy application. By default CompileX .NET generates 3 types of applications: 1. Multi-tier - Distributed Windows applications. Consists of 3 layers. 2. Web - Active Web Applications. Consists of 3 layers. 3. Simple client/server - It may be a simple desktop application working with local database as well as a real multi-user client/server application. Generated layers: 1. Database layer CompileX .Net automatically creates clear normalized relational database structure optimized to work with objects. It generates all required indexes and constraints and optimizes SQL queries to work with complex objects, to perform fast paging (for Web presentations) and more. 2. Logic Layer Generated multi-tier and Web applications work with data through generated Web Services. This allows the developer to concentrate most data processing logic in one separate layer. Generated Web Services already realize all logic needed to work with data and concentrate logic into separate classes. If, for example, you need to extend order-processing requests - simply change the method of generated Web Service. 3. Presentation Layer CompileX .Net automatically creates all Windows forms, all Web pages and all codes required to work with simple and complex objects with all child objects (or linked objects and lists of objects). Forms are sharp designs. Select desired design from library. CompileX.NET uses open code and GUI templates and allows customization of generated application. Adapt the look and feel to your corporate standards and generate your kind of application.
net asp visual studio vb application web services ado net asp vb sql
|
 |
Here are some of the features you can get in Xselerator:
Editor
---
* Clear and easy to use IDE;
* XSL/XSLT element and attribute intuitive (like Intellisense or code insight) drop-downs;
* Automatic tag completion - in XSL/XSLT tag completion follows model and, optionally, fills element with mandatory attributes;
* HTML element and attribute intuitive drop-downs;
* Unicode Support
* Full XSL, XSLT, XML and HTML color syntax highlighting (fully customizable);
* All the usual editor capabilities (cut, copy, paste, find, replace) plus special 'Copy as RTF' and 'Copy as HTML' features allowing syntax highlighting to be preserved when copying and pasting to word-processors, html editors and newsgroups etc.;
XSLT debugger
---
* Full stepping capability;
* Breakpoints on both XSLT and input XML;
* Conditional breakpoints;
* View template call stack;
* Watch values (including full XPath expression watches);
* Optional stepping into built-in rules
* Uses MSXML3 transformations (so that debugging session behavior matches a * real, production environment transformation engine);
Transformation
---
* One click transformation test;
* Full transformation testing (including XSL parameter passing, start mode and output test path);
* Use of alternative command line transformation engines (e.g. Instant Saxon, XT, etc.)
Wizards
---
* For building tables,
* Selects/list boxes and
* XSLT grouping/distinct expressions;
Tools
---
* XPath query analyzer (test XPath queries to see the resulting node sets - click on resulting list item to view position to node in source/tree view);
* Project Files Manager, which keeps all your related XML and XSL files together;
* Source edit, tree and browser view (requires IE5.x) modes;
* Files opened history (re-open previous files from menu - re-opened XSLT files restore previous parameters/start mode);
* Print and print preview (with selectable highlighting options);
xml xsl editor debugger xpath developer tool xslt editor full intellisense
|
 |
Universal Table Browser is a fully functioning Query Tool giving you access to ANY database using ODBC. A well designed graphical user interface means that you can simply point and click your way to complex SQL statements or use the SQL editor to write your own query. The browser has been optimized for MASSIVE databases, capable of dealing with MILLIONS of rows and thousands of columns and is capable of delivering data to you at blistering speed, the likes of which you've never seen before. Universal Table Browser is stable and super fast. During product demos we've seen people fall off their chairs at the speed (honest). It is a technically superior product and performs exceptionally well against all databases, from the smallest Access database to the largest enterprise system. It is a simple to use, super efficient query tool. It gives sufficient functionality for ANY database professional or end user to build and execute SQL queries against their databases. The Universal Table Browser has been extensively proven on the road as an effective query tool. It has been developed out of frustration with the inadequacies of existing tools. It is used on a daily basis against large, varied and "real" databases. Universal Table Browser can run against large databases (over 10,000 tables) and MASSIVE tables (over 100 million rows), especially mainframes and mini systems. Download your fully functional free evaluation today and we guarantee you will not be disappointed !
database query tool table browser sql oracle db2 access db views query odbc
|
 |
VISOCO dbExpress driver for Sybase ASE is a dbExpress driver for Borland Delphi, Kylix, C++ Builder.
VISOCO dbExpress driver for Sybase ASE provides direct access to Sybase ASE and allows you to avoid Borland Database Engine (BDE), ODBC, ADO.
Key features:
- High-performance
- Native access to Sybase ASE
- Compatibility with standard and third-party data-aware controls and components
- Easy installation and distribution
- Minimized driver size and use of system resources
- Cross-platform support via Borland CLX for Windows and Linux
- Free support for registered users
- "Per developer" license without royalty fee
Compatibility:
- Delphi 6
- Delphi 7.1
- Delphi for .Net 8
- C++ Builder 6.0
- Kylix 2
- Kylix 3
- Sybase ASE 11.0
- Sybase ASE 11.5
- Sybase ASE 12.0
- Sybase ASE 12.5
Download VISOCO dbExpress driver for Sybase ASE at: http://www.visoco.com/download/
The Trial version can be used for evaluation purposes only. You can use it for 30 days and not more than 1000 queries for all connections in your application.
Need more information? Please visit our site: http://www.visoco.com
visoco software dbexpress driverforsybase borland unidirectional datasets database isqldriver isqlconnection isqlcommandisqlcursori
|
 |
Universal database tool with report builder. Tested on Paradox, dBase, FoxPro, ASCII, InterBase, Oracle, SQL Server, MS Access 95-97. Installation package consists of the program, a sample database, report templates and help files. Main features are: -Viewing / Editing / Printing data. -Automatically created reports and convenient report builder (templates, expressions, preview...). -Building queries with tools for convenient writing the SQL statesments. -Enhanced dbgrids, which allow to view and manipulate the data in the convenient way. -Creating, deleting, modifying BDE aliases. -Command line parameters to automate the most often performed actions. -Searching / Replacing text. -Importing data to table from another table or a query. -Exporting data from any open table to Paradox, ASCII, dBase, Excel, text, HTML and other BDE supported formats. -Clipboard copying data; -Calculating numeric fields (sum, avg, min, max, count). -Editing MEMO fields. -Editing graphic fields. -Tools for editing string fields (trimming, changing case of symbols). -Sorting (logical and physical) data. -Filtering data. -Viewing structure with ability to print it. -Reindexing tables. -Customized data view (color, font style, temporarily hiding any column). -Transactions.
db dbf database report reporting query sql html xls rtf sorting
|
 |
Your IP address is to your Internet connection what your phone number is to your telephone, except it tends to change all the time. That is fine for most people who only need to connect to other Internet locations. But if you run your own servers, others need to connect to you, and you need to keep your IP address from changing dynamically. One way to assure that is by keeping your DSL modem connected to your DSL provider. Additionally, however, your computer needs to keep "talking." Typically, people solve this problem by pinging some web site regularly. That works. Unfortunately, that also abuses the resources of that web site. KeepMyIP takes a different approach. Instead of pinging some third party, it sends a random DNS query to your ISP at random intervals ranging from 1 second to 10 minutes, with an average of around 5 minutes. This tells your ISP that your computer is currently active on the Internet. It does so very fast without involving any unrelated Internet sites. It also does it without wasting your computer memory and CPU cycles. KeepMyIP is written in assembly language, so it is very small and lightning fast. In between the queries it puts itself to sleep so it does not interfere with whatever your computer is doing. It runs silently in the background without ever popping any windows. If, for some reason, you need to send out queries more often than every five minutes, or so, you can run KeepMyIP more than once. Two copies will poll your ISP twice as often, three copies three times as often, etc. Normally, however, KeepMyIP starts one copy of itself as soon as your Windows boots up and keeps running until you shut down the system. Of course, if you run an Internet server, you should avoid shutting down your system, except for very brief periods of time (minutes). Otherwise, your servers are not running and neither is KeepMyIP, so your IP address may change. But if you keep your system up and running, you can keep your IP for a very long time.
dsl cable modem ip static ip dynamic ip keeps dsl cable provider dynamically changing
|
 |
Browse databases, run SQL queries, or build reports, Convert databases as MS Excel spreadsheet. Quickly build field mapping between source and target dataset. Through mouse dragging, a field mapping will be automatically created.
Supports client-server databases.
Report Maker support all standard databases, SQL Server, Oracle, SYBASE, DB2, Access, DBASE, Foxpro, Paradox, etc.
Easy use
Easy and quick generator of the reports. The powerful designer of the reports will allows you generate the report easily and quickly. Quickly build field mapping between source and target dataset. Through mouse dragging,
a field mapping will be automatically created.
Support Excel and web files
powerful database management tool which can convert databases to Excel spreadsheets/MS, eliminating time-consuming data entry and the errors that accompany it. Report Maker also allows you to export web-page. You can distribute data to web directly.
Good Interface
Report Maker Support different interfaces contain office XP, strong, common. You can save your favorite style.
Tree View manager
Tree view manage report files and data elements.
Report Templates
Integrated Report Generator to create savable report templates.
powerful database management tool
which can convert databases to Excel spreadsheets/MS, eliminating time-consuming data entry and the errors that accompany it.
nternal calculation function. Report Maker embeds function of expression calculator, and provide over 200 functions for transformation.
visual query builder, and visual report builder
Risk Analyzer - Do decision and risk analysis the easy way
Sensitivity Analyzer - Do many what if and sensitivity analysis cases in seconds
Filter Assistant - Easily filter your data
sql excel database reporting querying publishing office browse databases run sql
|
|
|
