#Entering data in SBase
3 messages in this thread
Can't find anything in manual about how to enter data without having to
click & save each record and another click to continue. Is there no way to
just enter data, then bring up next record & save at end of session? I
don't know of a database that doesn't do that. Help…just about to enter
1000 records!!
Gracia
Use the "Batch" option on the record menu. See the "Database" manual for more
details on how this works. BTW, select "Batch" at the end of your data entry to
make the database secure.
The other way to do it is to set up a form using the Forms Designer and write a
simple DML program to enter the data. A basic one would be like:
OPEN FORM "DATAENTRY" ON ERROR GOTO SETRETURN ERR% = 0 WHILE ERR% = 0
BLANK FORM
ENTER
STORE ,0 WEND END SETRETURN: IF ERRNO = 11 THEN
REM CONTROL C OR STOP BUTTON CLICKED.
ERR% = 1 END IF RESUME NEXT
——————————————————————————-
——————– THE LITTLE ROUTINE "SETRETURN" CHECKS THE ERROR NUMBER TO
SEE IF THE USER CLICKED THE STOP BUTTON ON THE CONTROL PANEL OR PRESSED ^C.
WHILE ENTERING DATA IN A FORM, YOU CAN CAUSE CONTROL TO BE PASSED BACK FROM THE
"ENTER" COMMAND BY PRESSING THE ESC KEY. IN THE ABOVE, CONTROL RETURNS TO THE
PROGRAM AND THE STORE COMMAND IS EXECUTED, ANOTHER BLANK FORM IS CREATED AND
DATA ENTRY IS STARTED AGAIN. OH YEAH, SOMEWHERE PRIOR TO THE "END" STATEMENT,
BE SURE TO ADD "CLOSE FILE sbfilename".
—————————————————————————-
Hope this helps…
Jim
Many thanks. I'm sure it will help when I get the time to digest it. Right
now I have to do yard work or my main man will beat me <giggle>.
Gracia