? Hello,

?I found myself typing to often the code similar to the following:


select count(*) into vcount indicator icount from table 
if vcount>0 then
?edit using form4table
else
?insert <empty record> into table
?edit using form4table
endif


? 
?For this often happening design patter is there any option for
EDIT command or something that will do that automatically
in rbase like if there is no data on the table just insert
empty record and popup the form?


Boris Tkachenko
Wichman Floorcovering Inc.
Kansas City




-----Original Message-----
From: does not include a real name* -20 MD_XMFID_BB_PASS Found a 
X-rim-org-msg-ref-id header* 0.1 HTML_50_60 BODY: Message is 50% to 60% HTML* 
-4.7 BAYES_00 BODY: Bayesian spam probability is 0 to 1%* [score: 0.0000]* 0.0 
HTML_MESSAGE BODY: HTML included in message* 0.2 MIME_BASE64_NO_NAME RAW: 
base64 attachment does not have a file name* 1.9 MIME_BASE64_TEXT RAW: Message 
text disguised using base64 encoding* 1.7 LW_STOCK_SPAM4 Yup; its a spam!; 
[email protected]
To: RBASE-L Mailing List <[email protected]>
Sent: Fri, Jul 10, 2009 2:53 pm
Subject: [RBASE-L] - RE: Large integer values in Rbase v8



I was concerned about that also for my AR. <g>

Sent from my Verizon Wireless BlackBerry


From: Bill Downall 
Date: Fri, 10 Jul 2009 15:40:20 -0400
To: RBASE-L Mailing List<[email protected]>
Subject: [RBASE-L] - RE: Large integer values in Rbase v8



On Fri, Jul 10, 2009 at 3:31 PM, Wills, Steve <[email protected]> wrote:


? The cool thing is that (CTXT(JDATE())) used in this way still sorts exactly 
like INTEGER and DATE values.

?




Ahh, but be warned: this will lead to serious problems when we roll over to 
5-digit years. the year 9999 will sort after?the year 10000. It will be known 
as the Y10K problem.




Bill

Reply via email to