Hi, I'm working on a project where we're gonna fetch data from a DB2 database. I've been testing with both the ibm provider and simple odbc and with both approaches the connection open method is very very slow. If I try doing the same thing with Java and the IBM jdbc driver, it is a lot faster. Does anyone have any tips on how to i...
First, I want to show you the code I'm working on (VB6): Dim db as Connection Dim rs as Recordset Dim rs1 as Recordset db.Open "DSN=Oracle 10g; Uid=myUser; Pwd=myPassword;" 'I also tested SQLServer2005 'I connect successfully Set rs = db.OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE")) ' Everything ok here. I can list ...
Working with cascading choices in the new(er) FMP seems to be a little weird. My intention is to create a bunch of drop-down lists / pop ups that rely on the previous choice. If a user clicks on a Customer drop-down, the next drop-down (address field) will ONLY have related data for that customer street address. Once you click the cert...
Consider a SQLite database for an iPhone app with some "documents" as templates. The user is able to add his own templates too. I want to update the program and the database. Is there any chance to do so without overwriting the user's data? I've considered two different databases, but since this is overhead, I want to avoid this opti...
Hi, I have to create a voting system for school with java, the system will be used to vote for movies. It will have all of the users and movies set up before hand by someone. It is a console application and it will be ran on multiple computers. Some of the questions i have about this are: My teacher wants us to use a text file to ma...
We have to implement the import procedure. The quantities of data is about 100 megabytes for one CSV files (the files already resides on server, so no upload necessary). Any advice on whether to implement the bulk "LOAD DATA LOCAL INFILE" or row-by-row "INSERT/REPLACE" on importing data into database. I've checked that "LOAD DATA LOCA...
Possible Duplicates: What's the point of a candidate key? Superkey vs. Candidate key Thanks in advance. ...
Hello, Recently ran into a problem after putting my codeiginter application into a clustered environment. Users are able to get site rewards at point levels, after they click submit to retrieve the reward I have code that grabs the current point level of the reward is at and save that in a table with the user_id and what point level the...
I'm implementing a database where several tables have string data as candidate keys (eg: username) and will be correspondingly indexed. For these fields I want: Case insensitivity when someone queries the table on those keys The initially written case to be preserved somehow so that the application can present the data to the user wit...
hi, how to onnect Microsoft Access Database to visual c# for example: i make a database that have a table named "student" and fields " id , name " so i make a c# form that have 2 text boxs and a button "add" that add the contents of the two text box to the database bye ...
Hi all, I'm looking to build a sql client for a school project on iOS. My first problem here is that I'm not sure what, if any libraries I need beyond what's provided to me in the SDK to make the proper server connections. Also any security concerns you might be able to point out here would also be appreciated. ...
I have access to a remote Oracle database with a schema consisting of may tables but no data. I'd like to recreate this schema on my local database system for testing purpose. How would I go about this? Are there any utilities that can help with this? Also, if the 2 Oracle database versions are different would that be a cause of any con...
Hey all, I've been adding a like feature to an entries database... here's the structure of the DBs: **Users** user_id user_name etc. **Entries** entry_id entry_content etc. **Likes** user_id entry_id (It's a little more complicated than that, there are groups/categories, but that should explain it fine...) Here's the SQL query I'm ...
My web host (bargainvault) has PHP 5 installed, but it does not have a ton of database drivers installed. I specifically need sqlite3, but they only have the sqlite driver installed. And no PDO. So, my question is how can I bring support for my database to my application if there is no driver installed? I have looked at several database...
Hello, Can anyone provide me a link to a documentation or some examples of MyBase used with Delphi (newer versions) and especially basic operations (adding, modifying, deleting, searching ...) Thank you. ...
Hi All, As we know that there are different types of JOINs in any RDBMS, for eg:- Left join, outer join, inner join, left outer join etc. Invariably we use JOINs for lots of our business logics in our projects. However very few people have complete understanding or mastery over these JOINs. Usually people with half known knowledge on JO...
I can't find my test.db in the file manager in DDMS. Does someone know when we create a database, where it's installed ? ...
First of all, I'm looking at the interactions between around 300 elements. Each element will interact with all others and itself. In a minority of these cases, a reaction will occur, and I will mark that reaction. Since this is basically a matrix with around 90,000 possible interactions, I want to manage this data with code so I can e...
Hey everyone I have two tables in the database(videos and viewData) . Im trying to build a script that runs for each record in the "videos" table and does something using the "videoID" field for that specific entry in the "videos" table. The does something part would be dumping some data into the viewData table. Would I need to store ...
I have a table, with these columns: ID | Data How to find out which record has highest ID? ...