CompuServe Thread

#Entering data in SBase

3 messages in this thread
#55799From: Gracia M. LittauerApr 26, 1993 10:14 PM
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
#55802From: Jim JoslinApr 26, 1993 11:01 PM
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
#55840From: Gracia M. LittauerApr 27, 1993 12:01 PM
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