Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

[Gustavo1478]

Hello there, Im getting two very strange errors in a pretty basic attendance tracking application. "Enter must Begin First" and "Data value Cannot Fit into a numeric field of size". Ive tried searching for these errors but I couldnt find anything for Enter Must begin First.

The second error I found online that my field is not large enough for the data im trying to input, but the field that gives me this error is a time field and all Im doing is entering the default value of Now(), i dont see a reason why it shouldnt fit.

Ive attached a zip of the database, Im completely puzzled here. If you open the Time_Sheet Form all you have to do is enter into the first field (a numeric value) which is a variable field, then tab out of it, the next field (TodaysDate) it tabs into has an onArrive event that fires certain script.

If you enter an ID number of 1 for example then tab, I get "Data value Cannot Fit into a numeric field of size", then if you try and cancel your changes, you get Enter Must Begin First. After you get Enter Must begin first you cant do anythign after that, you get stuck in an infinite loop, the only way to close database is to start the task manager and end the program. If ive left anything out or if you have more questions please let me know.

Thank You, Ivan.

SignInOut.zip

[Al Buchholz]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

You start by putting a value in the employee variable.

Then you go to date and run a query and other things.

At first glance, I'm thinking you need to do this in a single script rather than multiple scripts.

You can't control the flow of scripts in action scripting, they run at their own timing.

You are also setting values of the objects on the form prior to starting the record entry.

[Gustavo1478]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

Im an amateur when it comes to writing xbasic or scripting, I run the query first to evaluate if there is a previous incomplete record, its determined incomplete by using the "Variable_Identifier" field. each individual script fires depending on the value in this field. If the Variable_Identifier field = 4, it begins a new record entry using the Variable vCurrentEmployee on the form.

Action Scripting is the best way i know of to accomplish this.

Separating the scripts was the only way I knew how to make scripts 2-5 fire conditionally.

[Gustavo1478]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

Even if you go to the table directly and try and enter the start field you get "Data value Cannot Fit into a numeric field of size", why is this?

[DaveM]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

I have not checked yet, but doesn't date and time like now() go into a character field?
pm and am will not work as numeric.

If a table is in enter mode, it does not need to be changed to enter data, but if it is not, it needs to be change to enter mode or nothing can be input;
similar to:
vmode = t.mode_get()
select
case vmode = 0
t.enter_begin()
case vmode = 2
t.enter_end()
t.enter_begin()
end select

(this may not be the exact code)
In other words, test for the mode and change as needed before entering the data.

[Al Buchholz]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

Im an amateur when it comes to writing xbasic or scripting, I run the query first to evaluate if there is a previous incomplete record, its determined incomplete by using the "Variable_Identifier" field. each individual script fires depending on the value in this field. If the Variable_Identifier field = 4, it begins a new record entry using the Variable vCurrentEmployee on the form.

Action Scripting is the best way i know of to accomplish this.

Separating the scripts was the only way I knew how to make scripts 2-5 fire conditionally.

From your action script, right click one of the steps and view xbasic. 2 tabs - Current action or All Actions.

Use All Actions and copy to clipboard - replace script_play_local with actual code.


To help triage the problems I used the divide and conquer method.

I moved your script to a button.

Took the script off the object event.

The calculated fields of lunch total (et al) is causing the can't fit because you are not requiring both a lunch start and lunch end field. So if lunch end is missing, the value calculated is too large to fit.

I think you are going to need to move away from action scripting for this process. Action scripting is an aid to coding, but you're in the deep end of the pool with this concept.

The time clocks I've seen are xdialogs where you can control values and events easier.

You need to work in smaller steps to keep an idea of what is happening.

Good luck with your project.

[Gustavo1478]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

The calculated fields of lunch total (et al) is causing the can't fit because you are not requiring both a lunch start and lunch end field. So if lunch end is missing, the value calculated is too large to fit.

Good luck with your project.

Taking this into consideration, I removed the calculated field from the tables field rules and added it to the "set field values" Action Script to fire after the necessary fields have been filled in. I also removed the scripts as you said to have the entire script run as one, conditionally of course.

Now this application is working just how I wanted, thanks Alan I would have been stuck here for quite some time.

[Al Buchholz]

Re: Enter Must Begin First? AND Data value Cannot Fit into a numeric field of size

Taking this into consideration, I removed the calculated field from the tables field rules and added it to the "set field values" Action Script to fire after the necessary fields have been filled in. I also removed the scripts as you said to have the entire script run as one, conditionally of course.

Now this application is working just how I wanted, thanks Alan I would have been stuck here for quite some time.

Good to hear.

Sometimes having field rules, code, et al gets confusing for what is being controlled when....

Better to do it in one place.