Hi every one,
Can any one guide me how to change color of columns of a tablegrid on form show event. I want to change colors of columns for specific fields.
51 2022-03-28 08:46:28
Topic: Column Color (1 replies, posted in General)
53 2022-03-26 09:51:45
Re: Scroll Bar (7 replies, posted in General)
Thank you jb to explain but I could not understand why here is 64? why it is not 65 or 66 or any other?
54 2022-03-26 04:52:55
Re: Scroll Bar (7 replies, posted in General)
Thank you derek. That is what I want but you can explain strtoint64 in this statement?
procedure Form1_Edit1_OnChange (Sender: TObject);
begin
if form1.edit1.Value > 0 then form1.tablegrid1.FixedCols := strtoint64(form1.edit1.text) else form1.tablegrid1.FixedCols := 0;
end;
55 2022-03-25 19:50:42
Topic: Scroll Bar (7 replies, posted in General)
Hi every one,
On tablegrid if we move horizontal scroll bar then columns move also. Is there a way where any selected column does not move while moving horizontal scroll bar.
56 2022-03-23 16:38:49
Re: Error (10 replies, posted in General)
Hi sparrow,
Thank you sparrow to guide.
57 2022-03-23 11:36:12
Re: Error (10 replies, posted in General)
Thank you every one.
It works correctly. Can you explain this error in some detail, sparrow?
58 2022-03-23 06:37:33
Re: Error (10 replies, posted in General)
I tried edit.value to edit.text but still I got that error message. Can you tell about other option vartostr(sqlguery)?
59 2022-03-22 19:56:51
Re: Error (10 replies, posted in General)
Hi derek,
I got this kinf of error " could not convert variant of type(unicodestring) into type(double) by typing following script.
Reception.Edit1.Value:= SQLExecute('Select Sum((Advance)+(Received)) from Fees Where Date(sdate1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"');
Reception.Edit2.Value:= SQLExecute('Select Sum((paid)+(lpaid)) from Expenses Where Date(date1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"');
Reception.Edit3.Value:= SQLExecute('Select Sum((Advance)+(Received)) from Fees Where Date(sdate1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"')-SQLExecute('Select Sum((paid)+(lpaid)) from Expenses Where Date(date1) = "' + FormatDateTime('YYYY-MM-DD',Reception.dtp.DateTime) + '"');
any solution?
60 2022-03-16 09:54:47
Re: Last Id (9 replies, posted in General)
Hi brain,
Look at attached pic and see what I want to do. This is from income_expenses project
61 2022-03-16 09:24:49
Topic: Primary and Foreign keys (1 replies, posted in General)
Hi friends and Experts of MVD,
Today I want to know about subject mentioned above in Topic subject. Can any one tell me how these keys act?
For example there is two table A and B. If A table has foreign key of B then what is action of table A and table .Same way if table B has foreign key of A then what will be act of B on A. Third condition is where both tables have foreign keys of each other then what will be the behaviour of the tables.
Thanks a lot.
62 2022-03-16 09:13:34
Re: Error (10 replies, posted in General)
It appear while calculation between several values.
When values from corresponding field is empty.
63 2022-03-15 18:09:56
Topic: Error (10 replies, posted in General)
Can any one tell about this kind of attached pic? How it come up and what is its sulution?
64 2022-03-14 02:47:33
Re: Last Id (9 replies, posted in General)
Can we use it in conditional statement if....then?
How we use ( select MAX(id) from xyz) in conditional statement? for example
if (select MAX(id) from xyz = (select id_abc from xyz where id_abc = 5) then ......
65 2022-03-12 05:40:03
Re: dbIndexToID(vrowid) does not work with sorted tablegrid (13 replies, posted in SQL queries)
This is useful project. Can you explain how could we get data from tablegrid to text box?
66 2022-03-12 01:38:47
Re: Last Id (9 replies, posted in General)
Thank you brain. In this query LIMIT 1 means one step before and other 1 is an increment.
67 2022-03-11 11:30:59
Re: Last Id (9 replies, posted in General)
Thank you StateOne. Can you tell if I want to take one or more before max(id)? for Example if max(id) is 300 but I want to take 299 or 298 then I must type max(id-1)?.
Secondly I want to know how can I use this id in conditional statement? if.....then
68 2022-03-11 02:32:05
Topic: Last Id (9 replies, posted in General)
Can any one tell how to use last id of a table for reference?
Select * from xyz where id = ( here must be last id of table)
69 2022-03-07 01:49:20
Re: delete from tablegrid (14 replies, posted in General)
Thank you derek you have solved my issue which is about one row in tablegrid. One thing more I would like to ask if there is more then one rows in tablegrid and more then one text box then how this statement would be?
70 2022-03-06 19:23:48
Re: delete from tablegrid (14 replies, posted in General)
Thank you derek. It works but it does not work when I select row and hit delete key or select row and click right mouse button.
71 2022-03-06 13:38:51
Re: delete from tablegrid (14 replies, posted in General)
hi derek
look at attached pic too
72 2022-03-06 13:36:55
Re: delete from tablegrid (14 replies, posted in General)
Hi derek
look at this project. When I enter sale on sale form it will appear on tablegrid and I type costumer's name. In case costumer refuse to buy then I delete record from tablegrid then costumer name should also be cleared.
73 2022-03-06 11:00:47
Re: delete from tablegrid (14 replies, posted in General)
I am sorry. I want to know when we delete a record from tablegride, it must also clear the data on text box of same form.
74 2022-03-05 11:59:10
Re: delete from tablegrid (14 replies, posted in General)
if text box belong to an other table then?
75 2022-03-05 10:00:56
Topic: delete from tablegrid (14 replies, posted in General)
It is possible if we delete data from tablegrid then concerned text in a text box should also delete. How it will be?