Problem - how to avoid adding records to a DBGrid?

delphi

    Sponsored Links

    Next

  • 1. low speed in locating a record
    Hi all, I have an firebird 1.5 database. I use IBX 7.08 in my application. I put a IBQuery and use a join SQL on to table with 17 & 17 fields. All records in result set not more than 30 but when I use IBQuery.locate, tick counts take is 700 and more (on a Celeron 1800 MH with 256MB DDR RAM & windows 200 AS). In actual application of this, record count will be up to 20000 and with this conditions, speed will decrease more. What I must do? Best regards, RSK.
  • 2. SQL Query
    I have a Varchar(4) field in a interbase 6 table and i want to do a select but only for ones where the result is an integer. ie in the field i could have 1, 2, 3, PO, 2, 5, YS, 5, 12 etc and i want to only pull 1, 2, 3, 2, 5, 5, 12 Any help with the SQL syntax would be appreciated. Regards Tim
  • 3. Upgrading Harder Not Easier?
    Does it seem that each upgrade gets harder? I recently upgraded IB from 7.1 to 7.5, upgraded IBX to 7.09 for IB 7.5, and maybe ran the Delphi 7 update 1 (probably a re-run). Instead of simply running a couple of exes this became a project. IB7.5 had problems running but eventually did. I had to find, build and install the deprecated IBClientDataSet - at least so I could go through my application to remove it. Reportbuilder had disappeared from my pallette tabs, as had a tab of third party components. Another tab of some templates/components I created lost it's name but was actually there with the items. Each time I do this I keep more copious notes in hopes I will spend less time next time just trying to get running again. That's if there is a next time. I may never upgrade again! I'm still getting a message box (actually an cascading group) about a bad memory address each time I close Delphi. Something must still not be right. Is it me or has this just gotten complicated? Patrick
  • 4. IBConsole source code
    Is it possible to get the source code of IBConsole since it is written Delphi? I am interested in code for granting privilieges and the Repair button of the validation dialog..thx

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 15 guest