Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. abbath8

    Slow connection...

    ...and the OS is Win2000
  2. abbath8

    Slow connection...

    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...
  3. abbath8

    transaction/lock problem

    One more question. It is not possible in this case to select the committed records from the table? Why can't I select the committed records?
  4. abbath8

    transaction/lock problem

    Thank You.
  5. abbath8

    transaction/lock problem

    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...
  6. abbath8

    MS SQL auto increment problem

    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...
  7. abbath8

    MS SQL auto increment problem

    ...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 primary key and...
  8. abbath8

    Task shouldn't appear on taskba

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

    Component creation...

    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...
  10. abbath8

    Automatic hourglass?

    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...
  11. abbath8

    Automatic hourglass?

    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...
  12. abbath8

    Separating names in one field

    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...
  13. abbath8

    FMTBCDField problem

    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?
  14. abbath8

    FMTBCDField problem

    It's not an ADODataSet, it's a ClientDataset...
  15. abbath8

    FMTBCDField problem

    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 :=...
  16. abbath8

    date filter &lt;-&gt; locale short date format

    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...
  17. abbath8

    date filter &lt;-&gt; locale short date format

    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?
  18. abbath8

    date filter &lt;-&gt; locale short date format

    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...
  19. abbath8

    date filter &lt;-&gt; locale short date format

    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?
  20. abbath8

    date filter &lt;-&gt; locale short date format

    towerbase thx for the tip, i tried it but the parse error still remains...

Part and Inventory Search

Back
Top