DBA, Databases, & Data Most Active Threads

|
|
Thread 25 of 25 | | Thread Starter | | |  PS_5200 | Discover Fika 33: The Ultimate Cafe in Killeshandr{Too Long!} | 11 replies. Last post: |  Gene.M | It is fine, nonetheless evaluate the information and facts around this correct. yaar win
|
|
 443 Hits | |
Thread 24 of 25 | | Thread Starter | | |  PMartins | Database Pros and ConsWe have hit problems using Access 97 as a front end to our contacts database. The limitations are in the functionality within the constructed interface, not an issue such as too many records (Although speed is also an issue here). We are therefore looking to other types of front-ends to replace Access. , Could anyone provide any relative Pros and Cons to using... , , Access 2000 , FoxPro , Oracle Forms , VB6 , HTML + ASP , C++ , J++ , Delphi , , .. to construct the front-end interface. Any pointers would be gratefully received! , , Thanks, , Paul | 7 replies. Last post: |  Scott | {Too Long!} |
|
 4617 Hits | |
Thread 23 of 25 | | Thread Starter | | |  JCarlos | Problem trying to insert 10,000 records under Red {Too Long!} |
 5102 Hits | |
Thread 22 of 25 | | Thread Starter | | |  os2 | how to manadage that...i use interbase 6 and delphi, , i try to do a location car program, , i have a table named Location with field, nolocation, km...., , i have another table named vehicule with fied, novehicule, km..., , and i have another table location_vehicule who join Location and vehicule with field, , nolocation and novehicule, , i want to know how to manage a new location..., , when i go to this form should I ask a new nolocation to interbase (generator) and after add car to this location or, , Inser car to the location, and before post the location ask a nolocation to interbase insert this number in nolocation field of location table and after in nolocation field of location_vehicule, , or any other tips to do that?, , database diagram, , [IMG]http://pages.infinit.net/borland/diagramme2.gif[/IMG], , form picture, [IMG]http://pages.infinit.net/borland/testing.png[/IMG] | 5 replies. Last post: |  Scott | {Too Long!} |
|
 3500 Hits | |
Thread 21 of 25 | | Thread Starter | | |  andreK | Interbase MetadataIn the Isql tool the user is able to get metadata on an object that resides in the databse. How is this done. Is this stored in a file somewhere? | 5 replies. Last post: |  Scott | {Too Long!} |
|
 4639 Hits | |
Thread 20 of 25 | | Thread Starter | | |  Bruno | gdb-File is very big after four months?I have the big problem, that my database has grown a lotsince installation time. Normally the db is about 500kB. We write some dates in one table. And when you start the Computer again, this table is empty. So the size of the db have to be always nearly the same. Now the gdb-file is about 2MB!! How can it be??, Exists a tool to clean the database of such effects (garbage in it, or something like that)?, , Thank U all, , Bruno | 5 replies. Last post: |  Scott | {Too Long!} |
|
 3050 Hits | |
Thread 19 of 25 | | Thread Starter | | |  TR | SQL-server 2000 performanceDoes anyone have any experience with using MS SQL-server 2000 (or 7) for bulky databases (1 million+ customer register). It will recieve fairly complex statistical queries (eg. for finding customer behaviours and segmenting them)., How does it stand up to the challenge compared to eg. Oracle ?, Anything thats especially (maybe even notoriously) important to keep in mind with SQL-server ?, , Regards, , Torben Rohde, ------------ [URL=http://www.des.dk]www.des.dk[/URL] |
 3486 Hits | |
Thread 18 of 25 | | Thread Starter | | |  andreazc | sql query to MS Access from JavaHi, I am trying to send SQL queries to MS Access 97 using Java but I only seem to get any response if I have a simple query of the form SELECT * FROM CUSTOMERS., , If I want to send something just slightly more complicated then it doesn't work, for example SELECT SURNAME FROM CUSTOMERS., , The code that I am using is:, Statement stmt = dbCon.createStatement ();, ResultSet rs = stmt.executeQuery (sqlStatement); //error occurs here, ResultSetMetaData rsmd = rs.getMetaData();, , Is there a particular format that Access needs when sending a query or is this a problem with it?, , Thanks, Andrea | 5 replies. Last post: |  andreazc | Thank you for the suggestion, the problem is now resolved., , For your information (and anyone else who reads this) the actual problem was caused by a corrupt ODBC driver as discovered when I reinstalled Office and the problem disappeared!!!, , Cheers |
|
 3813 Hits | |
Thread 17 of 25 | | Thread Starter | | |  Ritche M | Unknown Function: substring?i don't know why SUBSTRING is an unknown function when i make a select statement in SQL Explorer., , ex: select SUBSTRING("borland" from 4 to 4) from TABLE1, , error is either: unknown function or, invalid token "from", , Please help... |
 10237 Hits | |
Thread 16 of 25 | | Thread Starter | | |  PS_2233 | Nice Blog. Thanks for Shari {Too Long!} |
 2117 Hits | |
Thread 15 of 25 | | Thread Starter | | |  Marine1 | Homework helpHello,, , Need some homework help on databases such as, creating an ERD, data sets and so on. This stuff is bit over my head just need to survive at this point. I just don't the brain at this time for Oracle SQL. Thanks., , Until that time... |
 5906 Hits | |
Thread 14 of 25 | | Thread Starter | | |  andyhud | Calling SQL Server 7 Stored Procedures from C++I am having trouble calling a SQL Server 7.0 Stored Procedure from C++ that returns a recordset and an output parameter., , Here's the criteria - I wish to bind parameters at run time and I need to return an output parameter. Presumably, I need to use rs.Open not execute in order to get the recordset - the problem is that I don't get the output parameters if I am opening the recordset., The stored procedure may change so I don't really want to implement a static wrapper for it., I have tried to implement this with ADO, MFC DAO and MFC ODBC support classes., , A sample piece of code that does exactly what I need would be ideal... | 3 replies. Last post: |  southland | It will work, It will work. I try it before. |
|
 5095 Hits | |
Thread 13 of 25 | | Thread Starter | | |  Johnc | paradox 9 tables to mysqlDoes anyone know how to convert paradox 9 tables into mysql? If so is the conversion simple and does paradox have a built in function or script that can be run to do this? Which tables are more stable for alot of users and records being accessed per day Paradox or SQL ,  |
 6838 Hits | |
Thread 12 of 25 | | Thread Starter | | |  gchoy | Paradox data conversion{Too Long!} | 3 replies. Last post: |  SPB | {Too Long!} |
|
 3740 Hits | |
Thread 11 of 25 | | Thread Starter | | |  Wes Peterson | ElevateDB - A Compelling Choice{Too Long!} | 2 replies. Last post: |  adamlum | Wes has always had nothing but praise for DBISAM but it has only been available for Borland products such as Delphi and C++ Builder, IDE's I don't use, so I haven't had the opportunity to try it out first hand. I am definitely looking forward to trying out ElevateDB with Visual Studio 2005.
|
|
 10087 Hits | |
Thread 10 of 25 | | Thread Starter | | |  PS_5458 | The Wash Cycle: Engineering Steel Buildings for I{Too Long!} | 2 replies. Last post: |  Janie.C | {Too Long!} |
|
 301 Hits | |
Thread 9 of 25 | | Thread Starter | | |  Leslie | Transaction LogsHelp!!!!!, , I am at a new job and have just been asked to move the transaction logs on our SQL server. This may be a stupid question, however how do I do this. Please help me a.s.a.p., , Thanks in advance.  | 2 replies. Last post: |  lesrhall | This is only going to back the log files up (am I correct)?  I need to acctually move the files. I am trying to improve performance by seperating the log files from the databases. Thanks in advance!  |
|
 3219 Hits | |
Thread 8 of 25 | | Thread Starter | | |  laurent | Run Time error 40002. ORA-01013I have a run-time error 40002 when running an application (VB5). This is the following message I have when a selection query (with 9 joins):S1T00:[Oracle][ODBC]ORA-01013: user requested cancel of current operation., The query takes, wheter with ODBC test or Sql+, 5 minutes to be executed. This is too long for a user who is waiting for a result. was wondering if there are otpions to set, or optimization rules or paramters to set., Thanks for any answer., Laurent | 2 replies. Last post: |  sgeorges | Thanks Pedro! I have found a solution. I have just added after the SELECT /+ * ALL_ROWS */ and the query works fine |
|
 9096 Hits | |
Thread 7 of 25 | | Thread Starter | | |  KMerker | SQL QuerySuppose I have a table that looks like, , ID CAR1 CAR2 CAR3 ..., --------------------------------------, 001 HONDA PONTIAC FORD, 002 NISSAN TOYOTA HONDA, 003 MITSU MAZDA NISSAN, , etc..., , I want to build a query that retreives the total number of occurances of each type of car. For example,, , CAR COUNT, --------------, HONDA 2 , PONTIAC 1, NISSAN 2, MITZU 1, FORD 1, TOYOTA 1, MAZDA 1, , I know how to do it if there is only one column of CAR, however, I'm not sure when you have mulitple columns. | 2 replies. Last post: |  jdschram | Yahoo normalization!!! |
|
 2909 Hits | |
Thread 6 of 25 | | Thread Starter | | |  nzayas | problems with interbase-gbak-restoreI have a problema with a GDB., I execute a query into this gdb and the perfomance of this query is good, bat I make a, backup and restore to my gdb and I try to execute the same query and now the time to execute this query is very long., The plan that ibserver uses to execute the query in both database is different. Why?, Is there any problem with gbak restore GDB's? | 2 replies. Last post: |  nzayas | Firstly, thank you for you repply., The setting deactive indexes was off when I made the restore and de size page was the same than the original GDB. I tried with a bigger size page but the result was worst. |
|
 4224 Hits | |
Thread 5 of 25 | | Thread Starter | | |  assure | FIELD NUMERIC WITH PARADOXI recently tried to create a new table using Corel Paradox 9. I chose INTERBASE for the table type. I don't get to type in the form the field type NUMERIC. How to do ?, , Thanks ![[Help]](graemlins/help.gif) | 2 replies. Last post: |  assure | Hello for all! , , I am not getting to have success using Paradox 9.0 developers edition with Interbase 6.0. I am not getting to type the characters τ and π, and nor to record in the table. It would be possible an example of as best uses Interbase with Paradox. , , Thank you very much. |
|
 5305 Hits | |
Thread 4 of 25 | | Thread Starter | | |  essystem | Is InterBase The Best Choice ?I develop system for stores still in CLipper 5.3 I will change to Delphi. Is the InterBase the best choice for use in customers that will not pay for traditional products as SQLServer and others ? Is IB faster enough to run in PIII 800Mhz 128 MB RAM as server for 2 to 10 machines in a LAN ? And does it keep fast even when grow about to 200,000 to 300,000 register in two or three tables ? My system handle 20 to 2000 register in terms of sells and 50 to 5000 registers in terms of selled products a day. If IB is not the best choice what should i use ?, Thank You ! |
 4487 Hits | |
Thread 3 of 25 | | Thread Starter | | |  Royke74 | Check in triggerHi there,, , Can anyone tell me how to check for a string length in a trigger (BEFORE INSERT). Something like this. It should be simple but i cannot find anything about this in (online)help., , CREATE TRIGGER check_user_length FOR INLOGGEN, BEFORE INSERT AS, BEGIN, IF LENGTH(name) > 15) THEN EXCEPTION wrong_user_length;, END, , Thanks! | 2 replies. Last post: |  Royke74 | Thanks Simon i'll try it! |
|
 4163 Hits | |
Thread 2 of 25 | | Thread Starter | | |  Brex | interbase Vs AccessI need convert a database access, in a database interbase bvut I can't make it ? what is the solution exist one free program in internet? |
 4797 Hits | |
Thread 1 of 25 | | Thread Starter | | |  PANTLORD | Cannot insert into triggered interbase field.Hi there,, , I'm having trouble inserting a value into one of my interbase tables. The table in question has 5 fields, the primary key Operator_ID has a trigger set on it to autoincrement. It is a NOT NULL field as it is the primary key, so I don't enter a value via my Delphi front end. I have also set the required property for this field in Delphi to false., , I consistently am getting the message 'Field XXX requires a value however'., , Should interbase not handle this itself the trigger type is BEFORE INSERT. Within delphi I am using a DataModule with a an IBdatabase/IBTransaction/IBTable and a standard datasource as components and am attempting o do the insert via a navigation component and dbgrid. , , Any suggestions this thing is driving me crazy slowly but surely., , Thanks in advance, PL | 1 Reply: |  Simon Wood | I use this technique all over the place in my apps and don't see the problem that you have. I am using ObjectPAL and pass-through SQL., , Have you tried inserting a record using an INSERT statement in Windows iSQL ? If this fails then you have an InterBase problem otherwise it is something in your Delphi App, , Have you tried doing a simple hard-coded insert using a TQuery component under a button in your Delphi App ? |
|
 4072 Hits | |
|
|