”äŠr‰‰ŽZŽq

4D - Documentation   French   English   German   Spanish   “ú–{Œê   4D v11 SQLƒRƒ}ƒ“ƒhƒe[ƒ}ƒŠƒXƒg   4D v11 SQLƒCƒ“ƒfƒbƒNƒX   4D v11 SQL’萔ƒe[ƒ}ƒŠƒXƒg   –ß‚é   ‘O   ŽŸ

version 11.1 (Modified)


‚±‚̐߂̕\‚Í•¶Žš—ñA”’lA“ú•tAŽžŠÔAƒ|ƒCƒ“ƒ^Ž®‚É“K—p‚·‚é”äŠr‰‰ŽZŽq‚ðŽ¦‚µ‚Ä‚¢‚Ü‚·B”äŠr‰‰ŽZŽq‚ðŽg—p‚·‚鎮‚ÍTRUE‚Ü‚½‚ÍFALSE‚̃u[ƒ‹’l‚ð•Ô‚µ‚Ü‚·B

•¶Žš—ñ”äŠr

‰‰ŽZŽqƒVƒ“ƒ^ƒbƒNƒX–ß‚è’l—ጋ‰Ê
= (“™‚µ‚¢)•¶Žš—ñ = •¶Žš—ñƒu[ƒ‹"abc" = "abc"True
"abc" = "abd"False
# (ˆÙ‚È‚é)•¶Žš—ñ # •¶Žš—ñƒu[ƒ‹"abc" # "abd"True
"abc" # "abc"False
> (‘å‚«‚¢)•¶Žš—ñ > •¶Žš—ñƒu[ƒ‹ "abd" > "abc"True
"abc" > "abc"False
< (¬‚³‚¢)•¶Žš—ñ < •¶Žš—ñƒu[ƒ‹"abc" < "abd"True
"abc" < "abc"False
>= (ˆÈã)•¶Žš—ñ >= •¶Žš—ñƒu[ƒ‹ "abd" >= "abc"True
"abc" >= "abd"False
<= (ˆÈ‰º)•¶Žš—ñ <= •¶Žš—ñƒu[ƒ‹ "abc" <= "abd"True
"abd" <= "abc"False
% (ƒL[ƒ[ƒh‚ðŠÜ‚Þ)•¶Žš—ñ % •¶Žš—ñƒu[ƒ‹ "Alpha Bravo" % "Bravo"True
"Alpha Bravo" % "ravo"False

d—v: ‚±‚̐߂̏I‚è‚ɁA•¶Žš—ñ”äŠr‚ÉŠÖ‚·‚éî•ñ‚ª’ñ‹Ÿ‚³‚ê‚Ä‚¢‚Ü‚·B

”’l”äŠr

‰‰ŽZŽqƒVƒ“ƒ^ƒbƒNƒX–ß‚è’l—ጋ‰Ê
= (“™‚µ‚¢)”’l = ”’lƒu[ƒ‹10 = 10True
10 = 11False
# (ˆÙ‚È‚é)”’l # ”’lƒu[ƒ‹10 #11True
10 # 10False
> (‘å‚«‚¢)”’l > ”’lƒu[ƒ‹11 > 10True
10 > 11False
< (¬‚³‚¢)”’l < ”’lƒu[ƒ‹10 < 11True
11 < 10False
>= (ˆÈã)”’l >= ”’lƒu[ƒ‹11 >= 10True
10 >= 11False
<= (ˆÈ‰º)”’l <= ”’lƒu[ƒ‹10 <= 11True
11 <= 10False

“ú•t”äŠr

‰‰ŽZŽqƒVƒ“ƒ^ƒbƒNƒX–ß‚è’l—ጋ‰Ê
= (“™‚µ‚¢)“ú•t = “ú•tƒu[ƒ‹!1/1/97! =!1/1/97!True
!1/20/97! =!1/1/97!False
# (ˆÙ‚È‚é)“ú•t # “ú•tƒu[ƒ‹!1/20/97! # !1/1/97!True
!1/1/97! # !1/1/97!False
> (‘å‚«‚¢)“ú•t > “ú•tƒu[ƒ‹!1/20/97! > !1/1/97!True
!1/1/97! > !1/1/97!False
< (¬‚³‚¢)“ú•t < “ú•tƒu[ƒ‹!1/1/97! < !1/20/97!True
!1/1/97! < !1/1/97!False
>= (ˆÈã)“ú•t >= “ú•tƒu[ƒ‹!1/20/97! >=!1/1/97!True
!1/1/97!>=!1/20/97!False
<= (ˆÈ‰º)“ú•t <= “ú•tƒu[ƒ‹!1/1/97!<=!1/20/97!True
!1/20/97!<=!1/1/97!False

ŽžŠÔ”äŠr

‰‰ŽZŽqƒVƒ“ƒ^ƒbƒNƒX–ß‚è’l—ጋ‰Ê
= (“™‚µ‚¢)ŽžŠÔ = ŽžŠÔƒu[ƒ‹?01:02:03? = ?01:02:03?True
?01:02:03? = ?01:02:04?False
# (ˆÙ‚È‚é)ŽžŠÔ # ŽžŠÔƒu[ƒ‹?01:02:03? # ?01:02:04?True
?01:02:03? # ?01:02:03?False
> (‘å‚«‚¢)ŽžŠÔ > ŽžŠÔƒu[ƒ‹?01:02:04? > ?01:02:03?True
?01:02:03? > ?01:02:03?False
< (¬‚³‚¢)ŽžŠÔ < ŽžŠÔƒu[ƒ‹?01:02:03? < ?01:02:04?True
?01:02:03? < ?01:02:03?False
>= (ˆÈã)ŽžŠÔ >= ŽžŠÔƒu[ƒ‹?01:02:03? >=?01:02:03?True
?01:02:03? >=?01:02:04?False
<= (ˆÈ‰º)ŽžŠÔ <= ŽžŠÔƒu[ƒ‹?01:02:03? <=?01:02:03?True
?01:02:04? <=?01:02:03?False

ƒ|ƒCƒ“ƒ^”äŠr

•\’†‚Ì—á‚́AˆÈ‰º‚̂悤‚Ƀ|ƒCƒ“ƒ^‚ªÝ’肳‚ê‚Ä‚¢‚é‚à‚Ì‚Æ‚µ‚Ä•\‹L‚µ‚Ä‚¢‚Ü‚·:

      ` vPtrA ‚Æ vPtrB ‚Í“¯‚¶ƒIƒuƒWƒFƒNƒg‚ðŽw‚µ‚Ü‚·
   vPtrA:=->anObject
   vPtrB:=->anObject
      ` vPtrC ‚Í‘¼‚̃IƒuƒWƒFƒNƒg‚ðŽw‚µ‚Ü‚·
   vPtrC:=->anotherObject

‰‰ŽZŽqƒVƒ“ƒ^ƒbƒNƒX–ß‚è’l—ጋ‰Ê
= (“™‚µ‚¢)Pointer = Pointerƒu[ƒ‹vPtrA = vPtrBTrue
vPtrA = vPtrCFalse
# (ˆÙ‚È‚é)Pointer # Pointerƒu[ƒ‹vPtrA # vPtrCTrue
vPtrA # vPtrBFalse

•¶Žš—ñ”äŠr‚̏ڍ×

E•¶Žš—ñ‚Í•¶Žš‚²‚Æ‚É”äŠr‚³‚ê‚Ü‚· (Œãq‚̃L[ƒ[ƒh‚É‚æ‚錟õ‚̏ꍇ‚ðœ‚«‚Ü‚·)B

E•¶Žš—ñ‚ª”äŠr‚³‚ê‚é‚Æ‚«•¶Žš‚̑召•¶Žš‚Í–³Ž‹‚³‚ê‚Ü‚·B‚µ‚½‚ª‚Á‚āA"a"="A"‚ÍTRUE‚ð•Ô‚µ‚Ü‚·B‘啶Žš‚Ə¬•¶Žš‚ð‹æ•Ê‚µ‚Ä”äŠr‚·‚é‚ɂ́A•¶ŽšƒR[ƒh‚Å”äŠr‚µ‚Ä‚­‚¾‚³‚¢B—Ⴆ‚ÎŽŸ‚ÌŽ®‚ÍFALSE‚Å‚·:

   Character code("A") = Character code("a") ` because 65 is not equal to 97

E•¶Žš—ñ‚ª”äŠr‚³‚ê‚éê‡A•¶Žš‚ÍŽg—p‚·‚éƒRƒ“ƒsƒ…[ƒ^‚̃VƒXƒeƒ€•¶Žš”äŠrƒe[ƒuƒ‹‚ðŽg—p‚µ‚Ä”äŠr‚³‚ê‚Ü‚·B—Ⴆ‚΁AˆÈ‰º‚ÌŽ®‚Í“ú–{ŒêƒVƒXƒeƒ€‚Å‚ÍTRUE‚ð•Ô‚µ‚Ü‚·:

   "‚ " = "ƒA"
   "ƒA" = "±"
   "‚P"="1"

E‘¼‚Ì•¶Žš—ñ”äŠr‚ƈقȂèAƒL[ƒ[ƒh‚É‚æ‚錟õ‚̓eƒLƒXƒg’†‚Ì’PŒê‚ðŒŸõ‚µ‚Ü‚·: ’PŒê‚͌X‚É‚©‚‚»‚ꂪ‘S‘Ì‚Æ‚µ‚Ĉµ‚í‚ê‚Ü‚·B•¡”‚Ì’PŒê‚ðŒŸõ‚µ‚½‚èA‰¹ß‚È‚Ç’PŒê‚̈ꕔ‚ðŒŸõ‚·‚é‚悤‚ȏꍇA% ‰‰ŽZŽq‚͏í‚ÉFalse‚ð•Ô‚µ‚Ü‚·B’PŒê‚Ì”»•Ê‚ÍICUƒ‰ƒCƒuƒ‰ƒŠ‚ðŽg—p‚µ‚čs‚í‚ê‚Ü‚·BgToday'sh‚̂悤‚ɃAƒ|ƒXƒgƒƒtƒB‚ðŠÜ‚Þ’PŒê‚́A‚»‚ê‚ðŠÜ‚ß1‚‚̒PŒê‚Æ‚µ‚Ĉµ‚í‚ê‚Ü‚·B”Žš‚àŒŸõ‚Å‚«‚Ü‚·B¬”“_‚à”Žš‚̈ꕔA‚·‚È‚í‚¿’PŒê‚Æ‚µ‚Ĉµ‚í‚ê‚Ü‚·B‚½‚¾‚µ’ʉ݋L†‚≷“x‹L†‚È‚Ç‚Ì‹L†‚Í–³Ž‹‚³‚ê‚Ü‚·B

   "Alpha Bravo Charlie" % "Bravo" ` Returns True
   "Alpha Bravo Charlie" % "vo" ` Returns False
   "Alpha Bravo Charlie" % "Alpha Bravo" ` Returns False
   "Alpha,Bravo,Charlie" % "Alpha" ` Returns True
   "Software and Computers" % "comput@" ` Returns True

Note: ƒL[ƒ[ƒh‚ª‚ǂ̂悤‚ɍl—¶‚³‚ê‚é‚©‚ÉŠÖ‚·‚éÚ×‚ȏî•ñ‚́AˆÈ‰º‚̃AƒhƒŒƒX‚ðŽQÆ‚µ‚Ä‚­‚¾‚³‚¢: http://www.unicode.org/unicode/reports/tr29/#Word_Boundaries.

EƒƒCƒ‹ƒhƒJ[ƒh‹L† (@) ‚́A‚·‚ׂĂ̕¶Žš—ñ‚Ì”äŠr‚ÉŽg—p‚·‚邱‚Æ‚ª‚Å‚«‚Ü‚·B‚±‚ê‚Í”CˆÓ‚̐”‚Ì•¶Žš‚ð”äŠr‚µ‚Ü‚·B‚µ‚½‚ª‚Á‚āAŽŸ‚ÌŽ®‚ÍTRUE‚É‚È‚è‚Ü‚·:

   "abcdefghij" = "abc@" 

”CˆÓ‚̐”‚Ì•¶Žš‚ð”äŠr‚·‚é–Ú“I‚̃ƒCƒ‹ƒhƒJ[ƒh‹L†‚́A2”Ԗڂ̃Iƒyƒ‰ƒ“ƒh (”äŠr‰‰ŽZŽq‚̉E‘¤‚ÌŽ®) ‚ÅŽg—p‚µ‚È‚¯‚ê‚΂Ȃè‚Ü‚¹‚ñBÅ‰‚̃Iƒyƒ‰ƒ“ƒh‚ł́g@h‚Í’P‚È‚é1•¶Žš‚Å‚ ‚é‚ƉðŽß‚³‚ê‚邽‚߁AŽŸ‚ÌŽ®‚ÍFALSE‚Å‚·:

   "abc@" = "abcdefghij"

ƒƒCƒ‹ƒhƒJ[ƒh‚Í g0•¶ŽšˆÈãh‚ðˆÓ–¡‚µ‚Ü‚·BˆÈ‰º‚ÌŽ®‚ÍTRUE‚Å‚·:

   "abcdefghij" = "abcdefghij@"
   "abcdefghij" = "@abcdefghij"
   "abcdefghij" = "abcd@efghij"
   "abcdefghij" = "@abcdefghij@"
   "abcdefghij" = "@abcde@fghij@"

ˆê•ûA‚ǂ̂悤‚ȏꍇ‚Å‚àAƒƒCƒ‹ƒhƒJ[ƒh‚ð2‚˜A‘±‚µ‚ÄŽg—p‚µ‚½•¶Žš—ñ”äŠr‚͏í‚ÉFALSE‚ð•Ô‚µ‚Ü‚·BŽŸ‚ÌŽ®‚ÍFALSE‚É‚È‚è‚Ü‚·:

   "abcdefghij" = "abc@@fg" 

”äŠr‰‰ŽZŽq‚ª < ‚Ü‚½‚Í > ‹L†‚Å‚ ‚éA‚ ‚é‚¢‚Í‚±‚ê‚ç‚ðŠÜ‚ޏꍇA‘æ2ƒIƒyƒ‰ƒ“ƒh‚̏I‚è‚É’u‚©‚ꂽ1‚‚̃ƒCƒ‹ƒhƒJ[ƒh‚Ì‚Ý‚ªƒTƒ|[ƒg‚³‚ê‚Ü‚·:

   "abcd" <= "abc@" `—LŒø‚È”äŠr
   "abcd" <= "abc@ef" `—LŒø‚Å‚È‚¢”äŠr

Tip

•¶Žš—ñ‚Ì”äŠr‚Ü‚½‚ÍŒŸõ‚É‚¨‚¢‚āA@‚ðƒƒCƒ‹ƒhƒJ[ƒh‚Å‚Í‚È‚­ˆê”Ê‚Ì•¶Žš‚Æ‚µ‚Ĉµ‚¢‚½‚¢ê‡A‚Q‚‚̕û–@‚ª‚ ‚è‚Ü‚·:

ECharacter code (At sign) ŽwŽ¦‚ðŽg—p‚·‚é

—Ⴆ‚Ε¶Žš—ñ‚ª @ •¶Žš‚ŏI‚í‚Á‚Ä‚¢‚é‚©‚Ç‚¤‚©‚ð’m‚肽‚¢‚Æ‚µ‚Ü‚·B

- ˆÈ‰º‚ÌŽ®‚Í ($vsValue ‚ª‹ó‚Å‚È‚¯‚ê‚Î) í‚ÉTRUE‚Å‚·:

   ($vsValue [[Length($vsValue)]] ="@")

- ˆÈ‰º‚ÌŽ®‚͐³‚µ‚­•]‰¿‚³‚ê‚Ü‚·:

   (Character code($vsValue[[Length($vsValue)]])#64)

EŠÂ‹«Ý’èƒ_ƒCƒAƒƒOƒ{ƒbƒNƒX‚Ì"ƒNƒGƒŠ/•À‚Ñ‘Ö‚¦‚Łu@v‚𕶎š‚Æ‚Ý‚È‚·"‚ðƒ`ƒFƒbƒN‚µ‚Ü‚·B

‚±‚̃IƒvƒVƒ‡ƒ“‚́A•¶Žš—ñ‚É@‚ªŠÜ‚Ü‚ê‚Ä‚¢‚é‚Æ‚«A@•¶Žš‚ª‚Ç‚¤‰ðŽß‚³‚ê‚é‚©‚ð’è‹`‚µ‚Ü‚·B‚·‚È‚í‚¿ƒNƒGƒŠ‚Æ•À‚Ñ‘Ö‚¦‚ŁA@‚ð‚ǂ̂悤‚Ɉµ‚¤‚©‚ɉe‹¿‚ð—^‚¦‚Ü‚·B Ú‚µ‚­‚́A4D Design Referenceƒ}ƒjƒ…ƒAƒ‹‚ðŽQÆ‚µ‚Ä‚­‚¾‚³‚¢B

ŽQÆ

ƒrƒbƒgƒƒCƒY‰‰ŽZŽq, ƒsƒNƒ`ƒƒ‰‰ŽZŽq, ‰‰ŽZŽq, ŽžŠÔ‰‰ŽZŽq, ”’l‰‰ŽZŽq, “ú•t‰‰ŽZŽq, ˜_—‰‰ŽZŽq.


4D - Documentation   French   English   German   Spanish   “ú–{Œê   4D v11 SQLƒRƒ}ƒ“ƒhƒe[ƒ}ƒŠƒXƒg   4D v11 SQLƒCƒ“ƒfƒbƒNƒX   4D v11 SQL’萔ƒe[ƒ}ƒŠƒXƒg   –ß‚é   ‘O   ŽŸ