Hello, I'm using Access 2007 and C# to learn Databases. So far it's been rough but I've been able to handle things relatively well. What I need to do though is to query a my database table Accounts for the Amount of money a user has based on their pin. I've placed a button on the Windows Form I am using that will query the database on c...
Are there any other good graphical administration tools for SQLlite on the mac, instead of the Firefox Extension? ...
I have the displeasure of generating table creation scripts for Microsoft Access. I have not yet found any documentation describing what the syntax is for the various types. I have found the documentation for the Create Table statement in Access but there is little mention of the types that can be used. For example: CREATE TABLE Foo ...
I'm looking for a good reference card / cheat sheet that compares T-SQL and PL/SQL data manipulation language commands side-by-side. I've previously searched SO but there isn't any older thread covering this particular subject so I thought it'd be a good idea to start one, given that such reference is almost mandatory if you happen to w...
Hi, I have some .dat and .idx files and one .sup file in a directory , and i would like to know if there is any tool or .net programming tecnique to find out what type of database is? I dont know if this could help, but if i open one .dat file as text file, i get this: 0~0904021846460509040218464605>ÀÀX2Ü And the common part of all t...
First, I'm aware of this question, and the suggestion (using GUID) doesn't apply in my situation. I want simple UIDs so that my users can easily communicate this information over the phone : Hello, I've got a problem with order 1584 as opposed to hello, I've got a problem with order 4daz33-d4gerz384867-8234878-14 I want...
I work with several different databases and find myself trying connecting to these quite often to test a query. I use the database specific tools to connect to the DB and run the query. I find these DB specific tools like SQL Query Analyzer (SQL-Server), Oracle Enterprise Manager, MySQL Query Browser to be quite clunky and slow when it ...
Hi all, I'm doing some work with ACCPAC and don't have the benefit of any documentation. Specifically, I'm looking for: ARCUS ARIBD ARIBH AROBL If you could tell me what the columns are as well, that'd be doubly benificial. ...
Hello IT folkzies, I have a form in an MS Access database which lists all the landowners consulted with for a new electricity line. At the end of each row is a button which opens another form, showing the details of all consultation, offers made etc. I am trying to use vb in MS Access to take the contactID and automatically put it ...
Suppose I've got a simple record definition: -record(data, {primary_key = '_', more_stuff = '_'}). I want a simple function that adds one of these records to a mnesia database. But I want it to fail if there's already an entry with the same primary key. (In the following examples, assume I've already defined db_get_data(Key)-> ...
While clensing PII from test data I have been stuck with a challenging scenario: cascading the changes through the foreign key relationships in the data. Given the focus on privacy and regulations should this practice be discouraged? If the PII itself were not used in any key fashion a neat trick would be to just shuffle the columns. ...
Right now all I did was use the Dataset designer and dragged tables into it from the Database Explorer. It works (for what I need anyway) but it feels like it's a misuse of Datasets. (Actually I'm not really sure how to use Datasets or what the intended usage is, I was planning on using LINQ2SQL to interact with the DB) Is this ok? I...
Hey everyone, I am trying to really wrap my head around the database normalization concept. I understand that it is used to avoid duplicate/redundant data, and it involves creating separate tables for certain things, but I'm not quite sure I understand 1NF, 2NF and 3NF fully. I have read some of the questions on here regarding normaliza...
Hi there, I have two database servers running SQL Server 2005 Enterprise that i want to make one of them as mirror database server. What i need is, create exact copy a database from primary server on mirror server, so when the primary server was down, we could switch database IP on application to use mirror server. I have examined "mi...
ActiveRecord's validates_uniqueness_of is vulnerable to race conditions. To really ensure uniqueness requires additional safeguards. One suggestion from the ActiveRecord RDocs is to create a unique index on the database, for example by including in your migrations: add_index :recipes, :name, :unique => true This will ensure at the d...
How do I create a dynamic enum (and subsequently use the enum choices) in C# based on values in a database lookup table? (using enterprise library data layer) e.g. If I add a new lookup value in the database, I don't want to have to add the extra static enum value declaration in code. Is there such a thing as this? I don't want to creat...
I have a table named 'Patient_detail'. There are 4 columns in this table. They are: patient_id primary key(not null) visit_serial_ID primary key(not null) examination plan Now, how can I insert multiple records in 'examination' and 'plan' column against the single primary key 'patient_id' and 'visit_serial_ID' of the table 'Patient...
hey guys i want to fetch 3 tables in 1 single ado.net call from my ms access database, however i get an error when i am trying to do that when i change my sql query to just fetch 1 table, my code works fine can anyone let me know how to achieve this with ms access? because i have been doing this with sql server since ages without any p...
So after recovering a bunch of SharePoint MDF files from a SAN that went south due to client configuration idiocy we are now at the point where we are trying to reconnect the SQL databases. There were a handful of small databases that we recovered that mounted with no issues however the important database that holds an entire document m...
What are some pros and cons of using linq over stored procedures? ...