Search results for query: *

Hi, I have an IBM server with Xeon 3GHz, 2GB RAM, 2x36GB 10k rpm HDD. I installed 10g on it. The memory parameters are SGA max size = 768 MB, and automatic management is enabled, PGA = 256 MB. The machine is in a 100M ethernet LAN. I noticed that the connection to the database is pretty slow...

Hi, I have a problem with transactions. There is an SQL 2000 server machine and there is 2 clients. If one client do the following: BEGIN TRANSACTION INSERT INTO any_table (field1) values ('any value') the another client cannot query the table until the transaction is committed (or...

Hi, I have a Delphi7 app which uses dbexpress and an MS SQL2000 database. I want to handle a table's data, so I have an SQLQuery-provider-Clientdataset. I do a 'Select * from table1', and ok there is the data in the clientdataset. But if I want to insert to the table the id field (which is the...

Hi, How to make such vb6 exe, which is not visible on the windows taskbar? Abbath

Hi, I have an application, which contains several forms and the most of the forms contains a groupbox and some dblookupcomboboxes in it (in connection with clientdatasets) which is the same on every forms. So when the mentioned groupbox is modified it must be rewritten on all forms. I would...

Hi, I use dbexpress and I wonder if it is possible to auto change the cursor to hourglass when there is some database activity (like table/query open, insert, update etc.). The TSQLConnection has a SQLHourglass property, but it is only for: Establishing a connection to the database...

Hi, I have an Oracle 9i table with a FLOAT field. There is a dbxpress clientdataset I query the table into. If I want to give some value for the float field: CDatasetFLOATFIELD.AsFloat := <some double variable> only 4 decimals will be saved with rounding. So when I try: doublevar :=...

Hi, I have a dbXpress application, and there is a Clientdataset which has a date field. I would like to filter the dataset by the date field. So it works for ex: datefield >= '2005.05.24' and datefield <= '2005.05.25.' IF the short date format (in the regional settings) is 'yyyy.MM.dd.'...

Hi, I have a problem in Quickreport. There are a detail band, which prints variable quantity of data. There are another bands before the detail band so the detail band starts from the middle of the page and (normally) the rows continue on the next page if the space on the page is not enough to...

I have an Oracle database and I connect to it via BDE. There is a complex query and I wanted to speed it up. I modified the default rowset size (20) to a higher value and I noticed a little improvement. But over 175 I have an error message &quot;Insufficient memory&quot;. Now the query is not...

HI, I would like to make my oracle database open when the service is started. (Now, when the instance starts, the state of the database is shutdown.) How to do this?

Hi, I have a problem with Rave reports. I make a report on my computer (win xp hun) and when I try it on another computer (also on win xp hun) some chinese characters appears instead of the accent characters. I don't know what is the problem... Please help!

Hi, The question is: how to use import to update existing records? I used the import with the ignore=yes option, and this was good for not to show errors on existing tables and only the new data was imported. But now I want the existing records updated too. How to do this?

Hi, There are two databases in different places. I want to copy some tables and their data from the one database to the another. How can I do it in the simplest way? Thx.

Hi, I have a problem. I wrote a program which contains a WebBrowser component. And I have a page which contains a dynamic IntraWeb dll. When the page is loaded the page shows the pictures and the text created by the dll. I want to save this page automatically. There is a method...

Hi, There is a web page which contains an IntraWeb application. It is used with MS IIS and registered as a DLL. The app shows the actual state of something, some animated pictures. This page is very slow from the client side (via 64k line) and should be speeded up. I need a solution... I think I...

Hi, I would like to query the creation text of an oracle table via code as it is in the SQL Explorer's tables -> (table name) -> text sheet. How can I do it?