F
Frank Dulk
came across a doubt or better with something that I am not getting
understand. I have a system rotating in a Supermarket, Fiscal Printer and it
Balances everything beauty. The problem is when in the table Exits of Stock
the registration number in the primary key (autonumeração) it surpasses or
it is among 39000 to 40000, in the hour that the system is closing the
coupon, after concluding the operations of coupon impression, the message
appears: " Overload... " and it doesn't execute the next commands (only to
close and to open two forms). I Already tested to compact, to recuperate and
everything, anything of the right. He usually processes every sale and in
the hour of closing the coupon there that message it comes. The only thing
that makes to stop giving this message is when I create a new one it
controls " Exits of Stock " and I begin the numbering again of the 001 (the
exit data are extinguished of 5 in 5 days). Former. The current registration
is the 39000 however they exist in the table 5000 reg istros, because the
other ones were already extinguished. After having done that ceremony he
works until arriving more or less in the 39000. They are five boxes, up to
now all presented the problem when it arrives in this autonumeração count.
The same message appeared in another system when still this in elaboration
phase, I diffused and I substituted the variables that I create in the
Former structure. " Dim tests Integer " for boxes of direct text in the form
and he/she didn't give more problem. The question is: which the difference
in creating a variable in the structure with " Dim " and a text box in the
form?
OBS.: I didn't Still test in the System of the Market, it would like first
to know that he/she has logic or the mistake is in another part of the
System.
understand. I have a system rotating in a Supermarket, Fiscal Printer and it
Balances everything beauty. The problem is when in the table Exits of Stock
the registration number in the primary key (autonumeração) it surpasses or
it is among 39000 to 40000, in the hour that the system is closing the
coupon, after concluding the operations of coupon impression, the message
appears: " Overload... " and it doesn't execute the next commands (only to
close and to open two forms). I Already tested to compact, to recuperate and
everything, anything of the right. He usually processes every sale and in
the hour of closing the coupon there that message it comes. The only thing
that makes to stop giving this message is when I create a new one it
controls " Exits of Stock " and I begin the numbering again of the 001 (the
exit data are extinguished of 5 in 5 days). Former. The current registration
is the 39000 however they exist in the table 5000 reg istros, because the
other ones were already extinguished. After having done that ceremony he
works until arriving more or less in the 39000. They are five boxes, up to
now all presented the problem when it arrives in this autonumeração count.
The same message appeared in another system when still this in elaboration
phase, I diffused and I substituted the variables that I create in the
Former structure. " Dim tests Integer " for boxes of direct text in the form
and he/she didn't give more problem. The question is: which the difference
in creating a variable in the structure with " Dim " and a text box in the
form?
OBS.: I didn't Still test in the System of the Market, it would like first
to know that he/she has logic or the mistake is in another part of the
System.