Time Clock

[barrymavin]

Use the item() method

item(nRow, nCol)

[TheButcheryInc]

Hi Yvonne
It works correctly in the console. I will fix the Basetable. Should the KEYFIELD be an index name on the orinating Foxpro table ?
It is interesting that the same table structure in one location works and the other does not. I will try to bypass the issue by creating an intermediate sql table in the correct order and AddItems from that.
Thank you very much for your time and help.
Glen

[TheButcheryInc]

I found my mistake. All set on the Ordering of the items.

[TheButcheryInc]

I have the canvas section with the badge and name fields. I have the treegrid in place. I don't know how to apply the data to the treegrid. I am using a select statement to get the data i want once the badge number is found in the employee file.

[barrymavin]

Use the addItems method()

https://www.lianja.com/doc/index.php/Tree

[TheButcheryInc]

Hello

Is there a way to check for Lastkey() ?

[yvonne.milne]

Can you give more details? Do you mean a key pressed in the tree grid?

Regards,


Yvonne

[TheButcheryInc]

Good Morning
I am having an issue trying to run this code in the Page1_Load or Page1_Init procedures.

// Get the Company Names to select from
Use Butchery!VT_Company in 0 Shared
select compid,name from Butchery!VT_Company where type<2 into cursor CompName
Index on Compid tag Compid
Index on Name tag Name
=seek(m_location,"CompName","Compid")
Use in VT_Company
When i run the code the program shuts down without an error before the form even appears. same thing happens in the console.
I want to use the CompName cursor in a dropdown on the canvas to select the location ID where the puch will be applied.
Any thoughts on this would be appreciated.
Thanks
Glen

[TheButcheryInc]

Hi Yvonne

It appears that you cannot sort on Substr of a field. I am going to use the Datetime field alone and it works.
Thanks again.

[TheButcheryInc]

Good morning
I would like to cleanup the .prg file since i did alot of experimenting. is there a way to remove unused procedures code ?
When i comment them i get this response:

**** Lianja error ****
do PAGE1_SECTION1_READY

^
Cannot open 'page1_section1_ready.prg' - errno 2 - No such file or directory
**** Lianja error ****
do PAGE1_SECTION1_ACTIVATE

^
Cannot open 'page1_section1_activate.prg' - errno 2 - No such file or directory
**** Lianja error ****
do PAGE1_SECTION1_FIELD5_LOSTFOCUS
^
Cannot open 'page1_section1_field5_lostfocus.prg' - errno 2 - No such file or directory
Thank you.
Glen