Problem - how to avoid adding records to a DBGrid?

delphi

    Sponsored Links

    Next

  • 1. Locating a record after insert
    I'm using IB6, D5 Pro and IBX 5.04. I'm adding a record in a orders table which generates the next order number via a generator. When saving the record I'm committing the transaction (commit) so it can be seen by other users on the network. Once I've committed the transaction, I'm then re-opening the dataset (IBDataSet) and using LOCATE the find the record just added. Only thing is locate is so slow. Get a couple of thousand records in the system and it can take up to 30 seconds to locate the new record. Not good. I know you're not supposed to use LOCATE when using Interbase for exactly this reason. I can't use SQL to locate the record as the customer would want to be able to scroll through the all the records and not just the one that has been entered. Only thing I can think is to leave the file position at the start of the file, which they're not going to like. Any suggestions? Carl
  • 2. Move from BDE to IBX
    Hi ! We are planning a move away from the BDE. We are aware that a good deal of programming will probably be needed...... which is ok.... BUT: A more important question : Are there any serious drawbacks when using IBX, when compared to BDE ? Anything you cannot do using IBX...? As far as I remember, IBX in its earliest versions was rather primitive when it comes to handling blob fields, for example.... Would be grateful for any suggestions.... kurt schilling
  • 3. BDE & terminal server question Question
    Jonas < XXXX@XXXXX.COM > wrote: >Hi > >Have an application that uses BDE (will change to Interbase in a couple of >months) but if there are anyone who can answer the question anyway I would be >very thankful. >The question: >Have a customer who are running 2 identical terminal servers and my >application is located on one of them (we call that one #2) the problem is >that the application sometimes hangs if there are users who logs on VIA >terminal server #1 > >Is there anyone who knows what can cause this problem or/and provide a quick >solution to the problem (if possible) > Make sure none of them are using a local connection protocol. With TS you need to always use a remote protocol.
  • 4. XP can't start program using ibx7
    I've written a suite of apps in D7, using IBX that came with D7. Back end is Firebird 1.5rc5 The database is on an XP Pro machine. The current clients are 3 Win98's, 1 XP Pro and one Win2K. All these work fine. I purchased a new XP machine, P4 2.6 with hyperthreading disabled at the bios. I have had no problem getting it on the network but it cannot start my programs. I can access the database with IBConsole and IB_SQL from IB Objects. But my programs blow up when I start. They get to the point of initializing the datamodule, where all the IBX components are, and then it fails. Has anyone run into this and have an idea where the problem might be? Dixon

Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Mon, 07 Jul 2003 02:36:12 GMT


Hi all,


Small problemo... 

I have a DBGrid -> DataSource - IBQuery/IBUpdateSQL and I want users to 
be able to *_change_* a certain number of configuration parameters 
stored in a database.


This is fine and works a treat - *_BUT_* what I don't want them to be 
able to do is add new records to the DBGrid, but when I do DownArrow at 
the bottom, it gives an error message "Cannot insert into database (No 
Insert Query)" - and this is because I deleted the insert SQL generated 
by the IBUpdateSQL because I didn't want any inserts.

Also, when I do Cntrl-Del, it asks me if I want to cancel - I just want 
the app to do nothing if I try and delete also.


How do I allow people to edit the values already in the DBGrid but not 
let them add (or delete) any records.


TIA.

Paul...


-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Re: Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Mon, 07 Jul 2003 04:43:39 GMT


 XXXX@XXXXX.COM  says...

 


Thanks Bill.


Paul...


-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Re: Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Wed, 09 Jul 2003 21:19:16 GMT

 XXXX@XXXXX.COM  says...




Sorry - forgot to mention - using C++ 5 aser sig.

What is eqivalent command in C++?


Paul...



-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Re: Problem - how to avoid adding records to a DBGrid?

Postby Paul Linehan » Thu, 10 Jul 2003 02:43:12 GMT

 XXXX@XXXXX.COM  says...




I did actually look up the help before posting and couldn't c SysUtils - 
what do I need to include in the header?

I tried a basic app - 1 form, 1 button

void __fastcall TForm1::Button1Click(TObject *Sender)
{

  SysUtils::Abort();

}

get compiler message 

[C++ Error] Unit1.cpp(21): E2090 Qualifier 'SysUtils' is not a class or 
namespace name
[C++ Error] Unit1.cpp(21): E2379 Statement missing ;


tried saving and building app - same ting,


Paul...
 

-- 

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

p.s. just lacerated a tendon in left hand, so pls 
excuse typos and tricky abbrevs - TIA.

Similar Threads:

1.How to display a dbgrid only for adding new records

I'm using firebird and interbase express and bcb6
I want to use a dbgrid only for adding new records
I don't want to display old ones when the form is displayed.
Any ideas;;


2.Unwanted Sorting in DbGrid - after record add

I am new here so pardon me if this issue arised before. 
Scenario: using dbgrid to amend the table content. over multi-tier environment. using clientdataset.

Problem: after adding a record in the dbGrid, data is automatically sorted (believe on sorted by the first field in the grid). 

Question: how do I stop the sorting and wish to control myself on the display after record add. 

Appreciate any input. Cheers


3.Record ordering [Was: Problems wilth filtering records and/or GotoNearest]

Using Delphi 2006, MySQL 5 and Corelab DBExpress drivers.

I have been experimenting with my sorting order problem this weekend. The
only way I can get a correct order is to use TSQLQuery together with a
TDataSetProvider, with option RetainServerOrder, and a ClientDataSet.

But as soon as Delphi tries to interfere with the data (one way or the
other), things get messed up.

For example: I need to use GotoNearest. This means I need to set an index on
my ClientDataSet.

As soon as I add an index, as a result Delphi orders on the clientside (is
this assumption correct ?) and this ordering messes up the sortorder.

Right sort order:

B-9999
B-99999
B89999
B99999

Sort order when specifying index:

B89999
B-9999
B99999
B-99999

It looks like the "-" is being ignored. Because that would lead to:

B89999
B9999
B99999
B99999

And that is once again correct.

So what could cause Delphi to ignore (?) the "-" sign ?


4.Problem: master records + repeating detail records using Rave?

I have a tricky problem, but perhaps somebody can point me to a simple
solution.

I have two tables. The first contains a variable number of records,
and the other contains just three. All are created at runtime.

I need to print the first record held in Table A, followed by the 3
records from Table B, then the second record from Table A, and again
the 3 records from Table B, then the third record in Table A, and
again the 3 records in Table B -- until all Table A records have been,
as below:

------------------------------------------
J Brown, Dingle & Partners  20500.00 28 30
------------------------------------------
C Dellow, Frenchay & Sons   21200.50 29 32
A Brown, Allman Brothers    23030.29 41 18
G Arthurs, Powell Company   48010.00 22 13

------------------------------------------
R Bull, Sanglier et fils    21500.20 26 10
------------------------------------------
C Dellow, Frenchay & Sons   21200.50 29 32
A Brown, Allman Brothers    23030.29 41 18
G Arthurs, Powell Company   48010.00 22 13

------------------------------------------
T Woods, Research Group     19250.90 02 09
------------------------------------------
C Dellow, Frenchay & Sons   21200.50 29 32
A Brown, Allman Brothers    23030.29 41 18
G Arthurs, Powell Company   48010.00 22 13

etc.

The above is a trivial programming problem. What makes it tricky is to
accomplish it using Rave Reports. This is part of a larger project for
users who are familiar with the Rave interface.

Thanks in advance.

Bob Yorke

5.dbGrid, with multi-record drag and drop

I am looking for a dbGrid which supports multiple row selection, and
then the ability to drag and drop all selected rows. 

6. Open second form to edit DBGrid record

7. Delphi 2: DBGrid showing records limited to its size

8. display the record number on dbgrid



Return to delphi

 

Who is online

Users browsing this forum: No registered users and 2 guest