i want to know if there is a way or a new component which with i can export my grid data to XLS?
thanks in advanced.
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 hot CTA = Join our Network Research Panel
I have a column(memo). Then dataset field type is nvarchar(2000)
(widestring). when i export the dbgrideh 's content to excel , the xls
file can't be opened.
i change nvarchar(2000) to nvarchar(1000) ,the file can be opened,
but the text can't be export if the text's length is too long .
help me!
Hi all,
I have upgraded ehlib component from 3,2 versiyon to 4,1 versiyon.
I am using highlightfocus property in grids to determine the active row.
In old versiyon, user can show the blue cursor while there isn't any
record in the grid.
But new versiyon, user can not see blue cursor and the row is not
evident. My customers often call me about this and they told me "we can
not see the blue cursor"
How can i revert it back, please help
Thanks
Hello.
First of all I would like to thank you for making such nice set of
components.
Today I have tried to install new evaluate version of ehLib using
BDS2006 but I got such message when i've tried to compile
EhLibDataDrivers100.dpk:
[DCC Error] EhLibDataDrivers100.dpk(43): F2051 Unit IBXDataDriverEh
was compiled with a different version of IBStoredProc.TIBStoredProc
Regards
1ˇ˘why TMemTableEh can not support MouseWheelUp and DoMouseWheelDown?
in the unit DBGridEh,
function TCustomDBGridEh.DoMouseWheelDown(Shift: TShiftState;
MousePos: TPoint): Boolean;
begin
if ViewScroll and FDatalink.Active then //why is ViewScroll ?
begin
Result := False;
if Assigned(OnMouseWheelDown) then
OnMouseWheelDown(Self, Shift, MousePos, Result);
if not Result then
begin
if ssShift in Shift then
if ssCtrl in Shift
then FDatalink.DataSet.MoveBy(VisibleRowCount)
else FDatalink.DataSet.Next
else if ssCtrl in Shift then
begin
if (RowCount - TopRow - VisibleRowCount < VisibleRowCount)
then
FIntMemTable.FetchRecords(VisibleRowCount - (RowCount -
TopRow - VisibleRowCount));
SafeMoveTop(TopRow + VisibleRowCount);
end else
SafeMoveTop(TopRow + 1);
Result := True;
end;
end else
begin
if FDatalink.Active then FDatalink.DataSet.MoveBy(1
{Mouse.WheelScrollLines});
Result := True;
end;
end;
2ˇ˘the property "lookupdisplayfields" of the TDBColumnEh,Such as
property lookupdisplayfields is "ID;Caption;Code;",can you Add a
property which it show lookupdisplayfields by second text "caption",
such like TDBLookupCombobox'property ListFieldIndex.
3ˇ˘TDBGridEh can not support lookupGrid by different filter
Mode
To use the automatic sorting and filtering of DBGridEh one needs to
have special units for registering the features of the specific
dataset one is using.
I was wondering if anyone out there has the file for DBISAM database!
Please help me!!!
I use DBGridEh 4.0 with a TADODataSet. For the grid I have different
Odd/Even row colors. When I insert or append a new record the
alternating row colors become a single color when the dataset is not
Filtered and the Cursor Location is clUseClient. After posting the new
record the alternating colors return. This does not occur when the
dataset is Filtered or the Cursor Location is clUseServer.
Any advice or ideas would be appreciated. Thanks.
Mike
I am trying to use the ApplyUpdates method for a TpFIBDatabase in
C++Builder but I can't seem to succeed. Since
dbMain->ApplyUpdates([qryTable1]) is not a correct syntax in C++, I
tried using the following method:
dbMain->ApplyUpdates(OPENARRAY(TpFIBDataSet*, (qryTable1)));
Still, I get an error using this: "Cannot convert
'OpenArray<TpFIBDataSet *>' to 'const TDataSet * *'".
Any ideas how I can make it work?
Thx.
I am using DBGridEh (ehlig 3.0 full version) and a client dataset in a
Delphi 7 (update 2 installed) App to show a query result from a
firebird table.
I´ve configured the dbgrideh to sort data locally (clicking on title
row), and everything goes fine until I close and reopen the client
dataset. When I do that, I receive an error message
informing "Index 'SortIndexEh' not found".
Is there any way to avoid that ?
Thanks in advance.
Fernando.
Dear Sir,
I can not use the InternalCalc field in TMemTableEh.
When I add an InternalCalc field to my MemTableEh and set my
MemTableEh.Active = True then I recive an error.
thanks for any help.
--- In EhLib@yahoogroups.com, "ilkeryesiloglu" <ilkeryesiloglu@...> wrote:
> I used DbGridEh,TIBXDataDriverEh and FireBird v1.5.
> BUT the following error occures.
>
> so please help me what to do
>
>
> "Dynamic SQL Error
> SQL Error Code=-206
> Column Unknown
> Tables
> At line 2, column 16"
>
Well, show your SQL-query in TIBXDataDriverEh...
hi,
We have an urgent requirement for Delphi professionals for a Mumbai
based MNC.
Enclosed are the details:
Level: Software Engineer / Senior Software Engineer
Experience Level: 2-5 years in IT
Total Position : 15
Education: Any Graduation / Diploma Holder
Please, kindly send your updated resume to careers@...
with the following details:-
Name of candidate:
Location:
Education Qualification:
Total Work Experience:
Total IT Experience:
Skills:
Number of years experience in focussed skills area:
Contact Tel nos. Res/Off/Cell:
Email contact:
Current Employer:
Current gross salary drawn:
Joining Period:
Gross salary expectation:
Do you have valid Passport:(Yes/No)
We'll be grateful if you can pass on this mail to all of your friends
who are looking for a change.
Thanks and Regards,
jagadeesh.
CodeM Software Solutions
Ph no: 91-40 66738000/1/2
32005002/3.
careers@...
"This message (including attachment if any) is confidential and may
be privileged. Before opening attachments please check them for
viruses and defects. CodeM Software Solutions (CodeM) will not be
responsible for any viruses or defects or any forwarded attachments
emanating either from within CodeM or outside. If you have received
this message by mistake please notify the sender by return e-mail and
delete this message from your system. Any unauthorized use or
dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change and
CodeM shall not be liable for any improper, untimely or incomplete
transmission."
i want to have two PrintDBGridEh1.SetSubstitutes() in my grid.but as it is shown ,only one of them is accepted ,what should i do to have both of these items in beforegridtext
Hello arveen1925,
You can wtite next event for Column.OnUpdateData
procedure TForm1.DBGridEh1Columns6UpdateData(Sender: TObject; var Text: string;
var Value: Variant; var UseText, Handled: Boolean);
begin
DBGridEh1.DataSource.DataSet['VPreferred'] := Value;
DBGridEh1.DataSource.DataSet.Post;
end;
You have to use Value or Text property depending on type of Field.
Tuesday, August 29, 2006, 5:24:32 PM, you wrote:
a> Hello
a> when I change a field in record, move up or down to another record
a> for post my changes.
a> for example field is chechbox and when chech this field, Post this
a> info to database i ndbgrideh.
a> Please help me
a> Thanks
--
Best regards,
Dmitry V. Bolshakov
Hello mahdis,
Try to use next code
DBGridEh2.FooterRowCount:=1; //Ok
DBGridEh2.SumList.Active := True;
DBGridEh1.Columns[1].Footer.ValueType:=fvtSum;
Before use Footers collection it is necessary to add at least one element to
it.
Wednesday, August 23, 2006, 5:10:01 PM, you wrote:
m> hello All
m> i used Dbehgrid in order to genaret a dynamic report which it's
m> fileds are generated in run time not in design mode
m> as i have to have the sum of each column ,i used footer
m> these lines are written in my source:
m> DBGridEh2.FooterRowCount:=1;
m> DBGridEh2.SumList.Active := True ;
m> DBGridEh2.Columns[1].Footers[0].ValueType:=fvtSum;
m> BUT the following error occures after compiling:
m> list index out of bounds(0)
m> so please help me what to do
m>
m> thanks in advance
m>
--
Best regards,
Dmitry V. Bolshakov
Hello
when I change a field in record, move up or down to another record
for post my changes.
for example field is chechbox and when chech this field, Post this
info to database i ndbgrideh.
Please help me
Thanks
i used dbgrideh in order to generate a dynamic report.i mean my fiels of report are generated from a sql query and will be shown in the grid.i need the sum of each column as a footer but i shoul make it dynamically in my source code (not in design time but in run time) .i send you my source
Hi
It would be nice to make following procedures public, since they
are quite general and could be used outside of EhLib.
TDBGridEh.ShowEditor
DBGridEhImpExp.Clipboard_GetToStream
DBGridEhImpExp.StreamReadStruct
DBGridEhImpExp.StreamReadAnsiString
There has not been any new release of EhLib for a while and this forum
seems dead, too. Is EhLib still being worked on, or is it an abandoned
project now?