Database Question

wm.chatman · Oct 31, 2009

speachless thx KC

klaus · Oct 31, 2009

B4X:

Q: is it possible to receive a click reaction from tbl?

The standard Table control does NOT have a Click event.

But it is possible to add the Click event with the Door library.
I tested it, but it reacts only outsides the Cells.

Clicking on a Cell generates only the SelectionChanged event.
Clicking onto an already selected cell doesn't generate any event.

Best regards.

wm.chatman · Oct 31, 2009

klaus said:
B4X:

Q: is it possible to receive a click reaction from tbl?

The standard Table control does NOT have a Click event.

But it is possible to add the Click event with the Door library.
I tested it, but it reacts only outsides the Cells.

Clicking on a Cell generates only the SelectionChanged event.
Clicking onto an already selected cell doesn't generate any event.

Best regards.

OK Klaus understood
Thanks
Wm

wm.chatman · Oct 31, 2009

wm.chatman said:
ja, ja this i had seen also but I know it had only been fisible = false, was working on using tb2 darn it.
also made changes to a cpl of lbl headers on frm.

Gebiet/Area
Funddatum/Data found
Objekt/Object

(The FIND function filters the table according to the content of the textboxes).
correct, this I understand Sir

Specci48 gave me a nice thougt using lb
Q: is it possible to receive a click reaction from tbl?

Thanks very much Klaus!

Best regards
William

melde mich spaeter

Q: The FIND function filters the table according to the content of the textboxes. Searching for Fraenkische Schweiz shows frm header as Datum.
needs to be Gebiet/Area search had been used not Datum.
search Objekt - frm header Objekt

I love it...

wm.chatman · Oct 31, 2009

wm.chatman said:
Q: The FIND function filters the table according to the content of the textboxes. Searching for Fraenkische Schweiz shows frm header as Datum.
needs to be Gebiet/Area search had been used not Datum.
search Objekt - frm header Objekt

I love it...

did I miss something?

wm.chatman · Oct 31, 2009

Error compiling program Database

was going to Compile. But, Compile>Device(AutoScale)Exe
I get this loving Error Msg

>>Error compliling program<<
was ist jetzt kaputt?

Best regards
WmC

wm.chatman · Oct 31, 2009

wm.chatman said:
was going to Compile. But, Compile>Device(AutoScale)Exe
I get this loving Error Msg

>>Error compliling program<<
was ist jetzt kaputt?

Best regards
WmC

forgot jpg

klaus · Nov 1, 2009

Q: The FIND function filters the table according to the content of the textboxes. Searching for Fraenkische Schweiz shows frm header as Datum.
needs to be Gebiet/Area search had been used not Datum.
search Objekt - frm header Objekt

I was not aware that you set the Form.Text to the search criteria.
Is changed.

>>Error compliling program<<
was ist jetzt kaputt?

You have a line with Table2.BringToFront = True
this is wrong, must be Table2.BringToFront

Replaced the Datum textbox by a Calendar control. Changed also the csv file according to that.

Best regards.

EDIT: removed source code

wm.chatman · Nov 1, 2009

klaus said:
I was not aware that you set the Form.Text to the search criteria.
Is changed.

You have a line with Table2.BringToFront = True
this is wrong, must be Table2.BringToFront

Replaced the Datum textbox by a Calendar control. Changed also the csv file according to that.

Best regards.

das ist echt wunderschoen Klaus
Table2.BringToFront:BangHead::BangHead::BangHead: sowas...
Thank you Sir! melde mich spaeter. versuche button hide/show jetzt.

Best regards
William

wm.chatman · Nov 1, 2009

klaus said:
I was not aware that you set the Form.Text to the search criteria.
Is changed.

You have a line with Table2.BringToFront = True
this is wrong, must be Table2.BringToFront

Replaced the Datum textbox by a Calendar control. Changed also the csv file according to that.

Best regards.

Klaus, please take a look at Table >Datum<

wm.chatman · Nov 1, 2009

Update version

added a better function for the table Show / Hide.
but have problem with showing Date on Table as Date. Seems like its showing as Numeric date?

Best regards
WmC

klaus · Nov 1, 2009

Sorry, when replacing the txtDatum TextBox I overlooked the display problem of the date.
Here is the updated version, I added a hidden colum with the date ticks.

Best regards.

wm.chatman · Nov 1, 2009

klaus said:
Sorry, when replacing the txtDatum TextBox I overlooked the display problem of the date.
Here is the updated version, I added a hidden colum with the date ticks.

Best regards.

Klaus, if I had five days beside you, I would learn something. :sign0137: Supper time now, I will check the Update after sup.

Thank you very much Sir!!

Best regards
WmC

wm.chatman · Nov 1, 2009

Sorry Klaus

I must tell you the bad news.

Please take a look at Table. I added (Add) a new Object.
Area>Nuernberg, Object>taschenmesser. As you notice it gives Numeric for the Date of Object found.
Would you also please be kind enough so the Todays Date is shown, when the App starts and not 29/09/2005?
Saving new Date does not work. Could this have something to do with Sub btn Keep_Click?

Thank you Sir
William

wm.chatman · Nov 2, 2009

Hi Klaus

I have been working on the cdlDatum problem. Getting alot of negative results.

Q: would it be better to just use txt Area, and txtObject as a Search Critaria only? And change cdlDatum back to normal txtBox? This way we can still add a Date Object found input.

Adding and Delete using cdlDatum gives negative Results. Try it, by adding or deleting new data.
With a standart txtBox we can at least show the correct Date found, on the table.

What do you think about this option?

Best regards
WmC

wm.chatman · Nov 3, 2009

Found another Bug

Hi
Found another Bug
While testing the DbApp added some new data Area = Germany, Object = Pistol, Datum found = 2008.
Then I save the Data which is standard. But when checking the new Data that had been added, it does not correspond with the actual Data that had been placed into the txt Box (Area/Gebiet found).

There is a difference with Area; it does not show us the correct Input. It gives us a totally different Area that actually had been added as a new Area.:sign0148:
Seems like the new Area is copied from an existing Area that had been added before (it did not save the new Area).:BangHead:
Still also having problems with the Datum found situation.

I am not the brightest bulb, but I do try. I hate to ask for Help, but dont have a other choice.
No need for a new Update, the last post of the DbApp is the same.
Need some :sign0085: please.

Thanks

Best regards
WmC

klaus · Nov 3, 2009

Please test this version.
- removed Table2, use only Table1.
- added sort also for type
- changed display of table Type as name and not as index (needed to add a colum to the table)

There are still some buttons with not used.
- Clear
- Path
- Type
- Read
- Filter not needed, Find does it

Best regards.

EDIT: removed source code

wm.chatman · Nov 3, 2009

klaus said:
Please test this version.
- removed Table2, use only Table1.
- added sort also for type
- changed display of table Type as name and not as index (needed to add a colum to the table)

There are still some buttons with not used.
- Clear
- Path
- Type
- Read
- Filter not needed, Find does it

Best regards.

Hi Klais
workt all Night, and I got a new UI. Will also Update later. needs more tests.
this Bright Bulb got it to work, Need to find out how to save file as xml.
I am a headache, I know... Klaus DANKE SEHR!!! Will contact you later.

again, thank you VERY MUCH Klaus!
BR
WMC

wm.chatman · Nov 3, 2009

klaus said:
Please test this version.
- removed Table2, use only Table1.
- added sort also for type
- changed display of table Type as name and not as index (needed to add a colum to the table)

There are still some buttons with not used.
- Clear
- Path
- Type
- Read
- Filter not needed, Find does it

Best regards.

Hi Klaus
workt all Night, and I got a new UI. Will also Update later. needs more tests.
this Bright Bulb got it to work, Need to find out how to save file as xml.
I am a headache, I know... Klaus DANKE SEHR!!! Will contact you later.
will check your new version also
again, thank you VERY MUCH Klaus!
BR
WMC

wm.chatman · Nov 3, 2009

wm.chatman said:
Hi Klais
workt all Night, and I got a new UI. Will also Update later. needs more tests.
this Bright Bulb got it to work, Need to find out how to save file as xml.
I am a headache, I know... Klaus DANKE SEHR!!! Will contact you later.
will check your new version also
again, thank you VERY MUCH Klaus!
BR
WMC

darn it, I must still be sleeping

Database Question

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Well-Known Member