I hardly ever use “ENTER USING.” I normally add the record with the corresponding data first via code and then edit the record. Something along these lines…
INSERT INTO storecomputer (compname) VALUES(.vcompname) EDIT USING aacompinform WHERE compname = .vcompname In this case, the column compname would locked and not editable to prevent the user from making changes to values that are retrieved from the system. I found this approach works best when data is entered one record at the time, rather than during intensive data entry. Javier, Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Tom Hart Sent: Monday, March 18, 2024 7:01 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Rbase X5 to 11 It executes correctly, I checked the cval and it showed correct name, it just does not put in field on form Tom Hart On Mon, Mar 18, 2024 at 6:56 PM Javier Valencia <javier.valen...@vtgonline.com <mailto:javier.valen...@vtgonline.com> > wrote: Have you "traced" the cide to se see in which line the is failing? Is it not retrieving the computer name or failing after that? You can run the CVAL command from the r> prompt and see if it executes correctly. Javier Valencia, PE Sent from my T-Mobile 4G LTE Device -------- Original message -------- From: Tom Hart <tooma...@gmail.com <mailto:tooma...@gmail.com> > Date: 3/18/24 6:19 PM (GMT-06:00) To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - Rbase X5 to 11 Just installed 11 on a new computer and when I run a compiled app something does not work. I capture the computer name in a variable on startup and if a row does not exist(form new computer) a form will popup with the computer name in the field on the form. This has worked for the last 10+ years but now it will not put the computer name in the field. This is the code I use SET VAR vcompname = (CVAL('computer')) SET VAR vrows INTEGER = 0 SELECT COUNT(*) INTO vrows INDICATOR ivrows FROM storecomputer + WHERE compname = .vcompname IF vrows = 0 THEN ENTER USING aacompinform ENDIF RETURN Basically if the row does not exist it adds new. It works fine on the old computer with X5 Tom Hart -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABX9BNc6AH2vR0BFv2Nm8kCq7CFQxq8Z3R%3DBgvWxxEpiH_F-8w%40mail.gmail.com <https://groups.google.com/d/msgid/rbase-l/CABX9BNc6AH2vR0BFv2Nm8kCq7CFQxq8Z3R%3DBgvWxxEpiH_F-8w%40mail.gmail.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/E1rmMqS-006P7T-0I%40server126.web-hosting.com <https://groups.google.com/d/msgid/rbase-l/E1rmMqS-006P7T-0I%40server126.web-hosting.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABX9BNfVS%3DmBWHvRVW6gVmHsS-wLzbCe4WBKbZwGm8zkrFrcRw%40mail.gmail.com <https://groups.google.com/d/msgid/rbase-l/CABX9BNfVS%3DmBWHvRVW6gVmHsS-wLzbCe4WBKbZwGm8zkrFrcRw%40mail.gmail.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/030101da799d%24a0aa4270%24e1fec750%24%40vtgonline.com.
