Search options (Page 1 of 115)

Здравствуйте Vickus,
Возможно, проблема в том, как вы определили поля в схеме вашей базы данных.
Вы определили поле «Паспорт» как «текст» или «целое число» (даже если поле может содержать только числа, если вам не нужно выполнять никаких вычислений, его все равно следует определить как текст)?
Попробуйте определить поля как текст, и все, что начинается с «0», должно отображаться правильно.
Derek.

Hi Sparrow,
I did wonder about calling a bespoke procedure from the 'form1.onclose' event but I'd always thought that the 'form1.onclose' event would always run first before any other called procedure - but it seems that it's the opposite way round.
Knowing this now, I can see it being useful in quite a few scenarios.
So much still to learn
Thanks,
Derek.

Hi,
So you want to be able to search (for example) by name across all the tables ('administration, 'amis', 'sante', 'famille' etc).
It could be done but I think I would use a different approach entirely.
My advice would be to initially look at your data schema -  your tables all have the same structure and differ only by the type of contact.  Your whole project would be a lot more straightforward if you used just one table ('contacts') and a related table ('contact types') - see the screenshot attached.
This would resolve a lot of your issues (including the question of searching for something across multiple tables) and possibly solve issues that you haven't yet come across. 
It would also make your project easier to maintain as you could easily combine your forms for 'Famille', 'Sante', 'Entreprise' etc etc into a singe form ('contacts') where you could use a combobox to choose the 'contact type'.
One final point - be careful using the same form for viewing, inserting and editing your data as it can cause quite a few problems that you simply don't need to worry about if you use discrete forms.
Derek.

Hi,
Please see the attachment.
1. The date is now entered as part of the 'save' button on 'frmapografi'.
2. On 'frmpin', filter rows by selecting a date and clicking button 'filter records for the selected date'
3.  On 'frmpin, you can now delete records by the selected date by clicking button 'delete records for the selected date' (this may be useful if you insert records accidently into 'pin' or create duplicates).
4.  frmpin.tablegrid1 is now an editable grid ('change only)' in case you need to make small adjustments (for whatever reason).
Regards,
Derek.

Hello All,
Yet another variation on the same theme is to use the tablegrid's in-built footer function and then hide the footer.
The footer values (count, sum, minimum, maximum, average, distinct) can then simply be copied into edit fields.
Derek.

I don't quite understand what you are trying to do.
Can you take a screen-shot (perhaps use Excel) to show exactly what columns and rows in the tablegrid you want to display.
Derek.

Привет,
Думаю, это возможно, но отображать размер файла не так-то просто: сначала его добавляют в форму, а потом, ДО сохранения в базу данных, — не совсем удобно.
Разве недостаточно видеть размер файла при его выборе (см. вложение)?
Derek.

I think it can be done but it is not quite so easy to show the file size when it has been added to the form but BEFORE it has actually been saved to the database.
Is it not enough that you can see the file size when you are choosing it (see attachment)?

Salut,
Try adding this line to your code

procedure Accueil_Image3_OnClick (Sender: TObject);
begin
  Famille.Show;
  Famille.TableGrid1.dbupdate;
end;

But be aware that when you try to do everything on just one form, it introduces a few extra problems (duplicate records, searching behaviour etc). 
Regards,
Derek.

Hey Adam,
Not sure if this (see attached) is getting closer to what you want.
Even if it's not quite behaving as you expect, I think it's a more straightforward way to go (ie using labels (which will also eliminate the flickering problem you had using images)).
Running out of time here so not checked (Caveat Emptor - LOL!!) and the code isn't commented (but it's reasonably self explanatory).
Derek.

Hi Sparrow,
Good spot! 
Derek.

Hi Adam,
Short of creating your own page control from scratch (if even possible), I don't know of any way to reduce the width of the tab to less than the default minimum.
A possible option that keeps all of the usual page control functionality might be to simply hide the tabs and replace them with buttons (as per the attachment which can be sized to anything you want) or even images of different coloured tabs and that sort of thing if you wanted to get more creative.
Derek.

Hi,
You need to use a different procedure when you are using the 'enter' ('return') key as opposed to clicking on the 'save' button with the mouse.
The problem when you use 'editable tablegrids' is that if you use the 'enter' key, then it is difficult to check for any input error before the insert to the table has taken place.
I find that the easiest way to stop this is in your script by
1.  setting the 'save' button to not be the default (frmapografi.button1.default := false) to prevent the record being saved when clicking 'enter'.
2.  then test for the error.
3.  then depending on result of the test, switching back frmapografi.button1.default := true.
Have a look at the attachment.
n.b.:  the line of code (key := #0) is just to stop the annoying 'beep'!!
Derek.