"Pete sherer" <firstname.lastname@example.org> wrote in message
> Is it possible to read/write data from *.accdb (i.e., access database)
> If yes, could you point me to the right functions and examples?
If you're looking to write to the raw file directly, first you will need to
know the format of the file. Alternately, if you're on Windows you could
use a program like Microsoft Access that knows how to manipulate those files
and interface to it through its COM interface -- see the External Interfaces
section of the documentation for MATLAB for more information on interfacing
with other programs via COM.
comp.soft-sys.matlab (CSSM) FAQ: http://matlab.wikia.com/wiki/FAQ
To contact Technical Support use the Contact Us link on
Database Alias Hi,
Is there any way to set up an alias for a database within an SQL script?
What I'm trying to acheive is... instead of having -
<DatabaseName>.dbo.table, <DatabaseName2>.dbo.table, etc. - throughout the
script, I just set up an alias at the top of the script and reference them.
Prefix your query with USE...
Select * from tblName
You can also alias table names by putting the alias after the table name in
the from clause...
Select p.firstName, p.lastName from tblPeople p
Analytical Technologies, Inc.
"Ben" <email@example.com> wrote in message
> Is there any way to set up an alias for a database within an SQL script?
> What I'm trying to acheive is... instead of having -
> <DatabaseName>.dbo.table, <DatabaseName2>.dbo.table, etc. - throughout the
> script, I just set up an alias at the top of the script and reference
Thanks a lot.... but....
I have a script that accesses two databases throughout. I *guessed* that
you could only have
Database size How would I get the total size of a mysql database in MB format?
Sharif T. Karim
....you don't know wrath yet...
On Mon, 19 Jul 2004 22:49:53 GMT, "Sharif T. Karim" <firstname.lastname@example.org> wrote:
>How would I get the total size of a mysql database in MB format?
Log on to the database server, find the data directory, and use "du -hs" on
Andy Hassall <email@example.com> / Space: disk usage analysis tool
http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space
"Sharif T. Karim" wrote:
> How would I get the total size of a mysql database in MB format?
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-Database-size-ftopict131072.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=437579
Database copy Hi,
I wanted to copy selected objects using a SKILL script. However new
copied objects does not have the pin properties. Can you tell me how to
copy objects with its properties in SKILL
It is not a matter of properties. You should test wether the shape is associated with a pin and if
yes, create the pin in the destination cellview.
newFig = dbCopyFig(fig cv2 list(0:0 "R0"))
(term dbFindTermByName(cv2 fig~>pin~>term~>name))
(net dbMakeNet(cv2 fig~>pin~>term~>net~>name))
;; create the terminal if ne
database widgets Are there any free Python database widgets which provide a link
between a database and visual controls?
(like those of org.netbeans.lib.sql and
org.netbeans.lib.sql.models Java packages or Delphi's DataAccess
and DataControls packages)
bromden <firstname.lastname@example.org> writes:
> Are there any free Python database widgets which provide a link
> between a database and visual controls?
> (like those of org.netbeans.lib.sql and org.netbeans.lib.sql.models
> Java packages or Delphi's DataAccess and DataControls packages)
Not quite a Python question, but certainly Qt / PyQt has various DB
widgets (Qt 3, not Qt 2). No doubt other toolkits do too.
> bromden <email@example.com> writes:
>>Are there any free Python database widgets which provide a link
>>between a database and visual controls?
>>(like those of org.netbeans.lib.sql and org.netbeans.lib.sql.models
>>Java packages or Delphi's DataAccess and DataControls packages)
John J. Lee wrote:
> Not quite a Python question, but certainly Qt / PyQt has various DB
> widgets (Qt 3, not Qt 2). No doubt
Convert a Unicode Database into a non-unicode database Hi there.
We have an application that can run on a non-unicode or a unicode sql
Currently the application is running in a unicode database, as a
non-unicode database is less than half the size, I would prefer to
have a non-unicode database for demo purposes to be on my laptop, etc
Is it possible to change a unicode sql server 2000 database into a
And if so, how would I go about doing this?
Any help would be greatly appreciated.
Unicode data uses NCHAR / NVARCHAR / NTEXT datatypes rather than CHAR /
VARCHAR / TEXT. This is defined at the column level rather than the database
To change your database you could script all the tables, replace the unicode
datatypes with their non-unicode equivalents and then run the creation
script to create the new database. This might affect the behaviour of stored
procedures and other code but if the app is designed to cope with this then
presumably it shouldn't be a problem. Correctly converting your unicode data
to a non-unicode collation might be more of a challenge though.
SQL Server MVP
firstname.lastname@example.org (Rodger Dodger) wrote in message news
Database version for RMAN,Database version target etc.......... Hi ,
I would like to get the following information:
RMAN version Information, Database Version for RMAN, RMAN catalog,
Database Version target Machine, SQL Net Tracing.
Could some one suggest which SQL I can use in order to get all the
On 27 Feb 2004 22:22:04 -0800, email@example.com (David) wrote:
>I would like to get the following information:
>RMAN version Information, Database Version for RMAN, RMAN catalog,
>Database Version target Machine, SQL Net Tracing.
>Could some one suggest which SQL I can use in order to get all the
select * from rtfm
Sybrand Bakker, Senior Oracle DBA
This sql which u recommended does not recognize by database(8i):
I am not using recovery catalog.
sql>select * from rtfm
"DAVID" <firstname.lastname@example.org> a �crit dans le message de
> This sql which u recommended does not recognize by database(8i):
> I am not using recovery catalog.
> sql>select * from rtfm
Please Help with database upate. New to database Just some questions regarding tables. I am new Access Database and need a
little help. I have the following data listed below
01. I have a table called tbl_Customer with the following information
02. In that table I have three columns that have numeric data in it (City,
03. I need to convert the numeric data in table tbl_customer (City, State,
Marital_Status) to alpha numeric data
04. using the following tables to help convert the numeric data to alpha
05. tbl_City, tbl_State, and tbl_Marital_Status has the following data
listed below... file into my database as tbl_UserSearch and I want to do the
001. I want to use tbl_UserSearch to search the Master_query
002. Find all matches and create a new table called tbl_MatchesFound.
003. tbl_MatchesFound is created and used to export the information to
Excel to be used by others.
004. The other items not found is ported to a new table called
005. tbl_NoMatches is used to inform the requestors that those items not
found need to be worked.
tbl_MatchesFound and tbl_NoMatches do not have to be tables, I guess they
could be queries as long as I can export
Database Integration test Plan Hi,
I need some urgent help please.
My company has purchased a software and they need the System
Integration testing done with a SQl server.
Would anyone have any test cases or plans as how to approach this.
Any help will be greatly appeciated.
Recommendation for Access database type We're going to have multiple users entering data on a form in Access.
Once the data entry is finished the user clicks a button, goes through
verification, and the data is appended with a query to the main table.
The form is unbound.
Certain users who log into the database from other sites are having
performance issues in Access with Speed etc.
Would it be better if I setup a back-end/front-end database structure
here? The front end would sit on the person's hard drive and backend
on the network. Can i do the same append type query to the network
database without risk of corruption etc?
Thanks for the advice
pieler8 <email@example.com> wrote in
> Certain users who log into the database from other sites are
> having performance issues in Access with Speed etc.
> Would it be better if I setup a back-end/front-end database
> structure here? The front end would sit on the person's hard drive
> and backend on the network. Can i do the same append type query to
> the network database without risk of corruption etc?
There is never a situation where you should
Salary History Database Please let me know if anybody has seen a salary history database for
download. The database would track job descriptions and various
salaries for positions. Each job description should include multiple
rates ranging from low to high quotes. It would classify jobs in
several ways like union, non-union, flat, daily, hourly, etc. It
should calculate various salaries based on hourly, daily, or flat rate
in conjunction with the number of hours worked. This salary calculator
would help. Reports should display all high rates for a department or
all rates for a job description.
My initial thoughts revolve around two tables; one table represents
the job description; and the second table presents these rates. I just
need a starting point for ideas. Screenshots or a working model would
be ideal. This database is not a human resource solution. It serves to
track rates across similar positions when the titles have small
deviations. It has more in common with a project management solution.
It's a simple database, yet I could use suggestions on categorizing