473,407 Members | 2,312 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

How to emulate WRITETEXT / Writing to LONG fields

I am working on porting a Delphi / SQL Server application to Oracle
8i.

In one instance of the program we have a RTF Memo field and we save
its lines property directly to a TEXT field using WRITETEXT.

What SQL statement could I use under ORACLE that would provide me with
the same results?

Thanks... Jeff

//Sample DELPHI code underneath. Need to translate SQL statement for
Oracle.

StrStrm := TStringStream.Create('');
Text.SaveToStream(StrStrm); //this is actually the memo.lines

CommandExec('DECLARE @ptrval varbinary(16) '+
'SELECT @ptrval = TEXTPTR(['+FieldName+'])'+
' FROM '+TableName+
' WHERE '+WhereClause+
' WRITETEXT '+TableName+'.'+FieldName+' @ptrval
'''+PChar(StrStrm.DataString)+'''')
Jul 19 '05 #1
0 1983

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Iain Porter | last post by:
Hi, I'm trying to store large strings to a database, so am using the text field type (LongText). I have used this before when storing the html of a webpage, and was able to store more than 255...
2
by: Michelle | last post by:
Hi all I have used knowledge base article 112747 to improve my subforms performance. I am using Access 97. I have a main form where i put an extra textbox which concatenated TeamID WeekNum...
5
by: Jeong-Gun Lee | last post by:
I'm writing a code of writing a value to a specific memory address. ================================================================= #include <stdio.h> int main() { long air; long...
61
by: /* frank */ | last post by:
I have to do a homework: make a CPU simulator using C language. I have a set of asm instructions so I have to write a program that should: - load .asm file - view .asm file - do a step by step...
2
by: Mike | last post by:
I need to POST some hidden fields to a page, which i need to load in the browser window.. i've tryed writting out the hidden fields and doing a response.redirect/response.transfer but these don't...
7
by: C a r l o s A n t o n i o | last post by:
Hello, I have to submit a file via HyperTerminal using my PC's internal modem on a daily basis. Does anybodoy know how to accomplish this in VS2005? Any language is good, VB preferred. ...
5
by: Zamdrist | last post by:
I need to update/change the text in a table column of data type TEXT. It's a smaller set of records (72) where I need to append onto the end a string of text, the same for all records. I don't...
0
by: Jeff Lambert | last post by:
I am working on porting a Delphi / SQL Server application to Oracle 8i. In one instance of the program we have a RTF Memo field and we save its lines property directly to a TEXT field using...
14
by: Eugeny Myunster | last post by:
Hello all, How can i emulate sizeof() only for integers?
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.