Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 9 of 9 total |
XML |
Tue, Jun 10 2008 6:11 PM | Permanent Link |
"Jerry Hayes" | With v 2.0 have any XML capabalities?
If not, what would be the best path to add some custom functions? Some basic xpath queries and updates, don't mind assuming MS DOM availability. Thanks all. |
Tue, Jun 10 2008 9:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jerry,
<< With v 2.0 have any XML capabalities? >> Yes, but not initially. << If not, what would be the best path to add some custom functions? Some basic xpath queries and updates, don't mind assuming MS DOM availability. >> Do you want to manipulate XML stored in the database tables, like in CLOB columns ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 11 2008 12:49 AM | Permanent Link |
"Jerry Hayes" | > Do you want to manipulate XML stored in the database tables, like in CLOB
> columns ? Yes. I'd like to create a few functions, (operating on the memo field), one to return the value of an XPath and one to set a value. |
Wed, Jun 11 2008 7:07 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jerry,
<< Yes. I'd like to create a few functions, (operating on the memo field), one to return the value of an XPath and one to set a value.>> Sure, you can do that in EDB. You can either try to do it using straight SQL/PSM (might be a bit dicey) or do it using native DLL in an external module. If you want to proceed with the native Delphi, just let me know and I'll give you the steps on how to create one and install it. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 11 2008 1:21 PM | Permanent Link |
"Jerry Hayes" | > << Yes. I'd like to create a few functions, (operating on the memo
> field), one to return the value of an XPath and one to set a value.>> > > Sure, you can do that in EDB. You can either try to do it using straight > SQL/PSM (might be a bit dicey) or do it using native DLL in an external > module. If you want to proceed with the native Delphi, just let me know > and I'll give you the steps on how to create one and install it. Tim, RE: Native Delphi...yes, I'd like some pointers here. I know in DBISAM you had the 'customfunction' event, I guess since EDB is more formal, that's no longer hooked, right? If it can be done by compiling a special server, that would be fine, since I could put some other code in there too and it would make deployment and licensing easier for me. BTW, hello from beautiful Apopka Florida Did you know that 'Post Lake' apartments aren't called that anymore? The lake looks good right now, plenty of water. Anyway, thanks for the whatever info; I do *not* mind pointers being specific to 2.x. Jerry |
Wed, Jun 11 2008 4:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jerry,
<< RE: Native Delphi...yes, I'd like some pointers here. I know in DBISAM you had the 'customfunction' event, I guess since EDB is more formal, that's no longer hooked, right? >> Correct. << If it can be done by compiling a special server, that would be fine, since I could put some other code in there too and it would make deployment and licensing easier for me. >> No need - everything is done external to the server. ================== You can define a stored procedure as external: http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=10&topic=162 The EXTERNAL NAME clause specifies that you want to use an external module instead of an SQL/PSM body, and the name is the same as an existing external module: http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=0&topic=13 You can create an external module very easily by doing the following in Delphi 5-7 (2005+ is a little different because they moved the object repository): File/New Select the ElevateDB tab Double-click on the ElevateDB External Module icon This will generate an empty template application for creating an external module that can contain any number of external procedures. And, this is all native Delphi code instead of SQL/PSM, which is ideal for situations where you need to interface with external hardware or libraries. ================== << BTW, hello from beautiful Apopka Florida Did you know that 'Post Lake' apartments aren't called that anymore? The lake looks good right now, plenty of water. >> Wow, that lake was almost bone-dry when we left Orlando in 1998. What are the Post Lake apartments called now ? We actually really like living there way back when - they really ran the place very well and it was a great place to live in the late 80's/early 90's. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 11 2008 5:26 PM | Permanent Link |
"Jerry Hayes" | [snip]
> << If it can be done by compiling a special server, that would be fine, > since I could put some other code in there too and it would make > deployment and licensing easier for me. >> > > No need - everything is done external to the server. Thanks for the references. Just curious, *CAN* the code be added easily for a custom embedded server, or must it be external? [much snipping] > Wow, that lake was almost bone-dry when we left Orlando in 1998. What are > the Post Lake apartments called now ? We actually really like living > there way back when - they really ran the place very well and it was a > great place to live in the late 80's/early 90's. http://zomrent.com/barringtonatmirrorlake/main-page.asp |
Wed, Jun 11 2008 6:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jerry,
<< Just curious, *CAN* the code be added easily for a custom embedded server, or must it be external? >> Not at this point, no. However, Oliver Bock requested this, and it's still on the list. << http://zomrent.com/barringtonatmirrorlake/main-page.asp >> Wow, still looks pretty nice. Did they change all of the Post* apartment complexes to something else, or just Post Lake ? Also, it's funny that the address is still 700 Post Lake Place. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 11 2008 6:17 PM | Permanent Link |
"Jerry Hayes" | > << Just curious, *CAN* the code be added easily for a custom embedded
> server, or must it be external? >> > > Not at this point, no. However, Oliver Bock requested this, and it's > still on the list. Thanks, Tim. Put me at +1 on this. |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |