Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: Fw: Is there a function in InstantDB??


Tera

You can add you own "Right" function or you can use the existing "Substr"
function.

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Scott Pirie <scott.pirie@lutris.com>
To: Peter Hearty <peter.hearty@lutris.com>
Date: 30 May 2000 20:12
Subject: Fw: Is there a function in InstantDB??


>
>----- Original Message -----
>From: <willer@hongkong.com>
>To: <bugs@enhydra.org>
>Sent: Friday, May 26, 2000 2:37 AM
>Subject: Is there a function in InstantDB??
>
>
>Hi,
>
>We have used InstantDB as the DB of one of our major products.  Since there
>is actually no UI for it to retrieve data for our debugging, we also make
us
>of ACCESS in the debugging phase.
>
>We find it our that when calling some DB build-in functions from our Java
>code, the following keywords does not work at all.
>
>LIKE "A%" IGNORE CASE - InstantDB
>LIKE 'A*' - ACCESS
>
>So that we must use the alternative
>(ACCESS)
>"INSTR(1,field,data,1)<>0";
>(InstantDB)
>"CONTAINS("field,data")=1";
>
>However, when it come the case of
>LIKE "%A" IGNORE CASE
>
>In ACCESS, we can still use
>"Right("sField,data.length()) = value;
>
>BUT how about InstantDB, is there any equivalent functions?
>
>And I am really puzzled, why the LIKE keywords cannot be used???
>
>Thanks & Best Regards,
>Tera
>
>----------------------------------------------
>歡迎使用 hongkong.com 電子郵件系統
>Thank you for using hongkong.com Email system
>
>
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.