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...
Ok, meanwhile I discovered that if I set the AutoGenerateValue of the sqlquery and the Clientdataset to arAutoinc then I can select all fields, and I can left the id field blank and it works, but I must refresh the dataset to get the id field value and to do this I must apply updates before. But...
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,
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...
Ok guys, thanks for the posts. I know this solution. My question was if there is some trick to auto change the cursor during some database activity, so I don't want to write code before and after dataset opens, execsqls etc...
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,
First create the 'Middlename' field in your table.
then You should write a short code. You should have a table (bde) or adotable component...just call it "dataset".
var
tempstr : string;
...
dataset.open;
...
dataset.first;
while not dataset.eof do
begin
// make sure we have not any...
When I write:
CDatasetFLOATFIELD.AsString := floattostr(doublevar);
then the field gets the value correctly. Ok this is not a solution, but what is wrong with the AsFloat (or Value as well)??? Why does it round the number to 4 decimals?
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 :=...
I found the problem! Giving ShortDateFormat is not enough. The DateSeparator must be also given (even if it is the same '.' as the default). Before the filter:
DateSeparator := '.';
ShortDateFormat := 'yyyy.mm.dd.';
and then the filter works correctly. I dont't understand but works...
So...
The Year, Month, Day works well for an exact date, but if I want to give a range for my date field "datum"...
For example: 2004.05.16 - 2005.01.11.
How to do this with Year, Month, Day?
FormatDateTime doesn't help. It does the same as above. Just formats the string but the parse error still remains.
Something is needed to tell the program how to parse a date field in a filter expression...
I noticed that the ShortDateFormat setting affects how to substitute dates as strings but not the format which is used in parsing...do I see it right?
What would be the solution then?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.