| |
| |
|
| - Page 1 - |
|
Christof
Neuß | Hello people,
have a Access-data base in the grabbed. Klappt lovely.
only: the Memo won't correctly. or. verkürzt read. in the Memo have I a (modified) RTF-File stored. These is too entire there. the can I over MS-Access see. The INSERT-INTO-commands has means functions.
with
SQLEXEC "Select RTF_Text from RTF_Texte",2
standing in the SQL.Dat only one part the Field.
too with
SQLEXEC "Select RTF_Text from RTF_Texte",1
sustain I in the Listbox only the first ??? characters.
gives it here a Begrenzung? How can I The bypass? i want not The ca. 15 RTF-Files with in that directory copy. sees simply unschön from and the management in the DB find I well.
Thank you! |
|
| |
| |
| |
|
 |
« this Posting watts as Solution marked. » |
|
RGH | Hi,
The length, The by SQL a Memo read becomes, can with @Set("SQLWidth", n) tuned go. Möglicherweise reicht in Your drop The voreingestellte length not from.
Greeting
Roland |
|
| |
| Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4 | 01/03/11 ▲ |
|
| |
|
|
|
 | first of all: in a.
Wieviele characters go because zurückgegeben?
If you "Sonderzeichen" mitnutzt then helps z.B. encode64(. |
|
| |
| |
| |
|
|
Christof
Neuß | Tja. it come well 1024 characters rüber. not any more. I have now time everything omitted, what with RTF To do has. simply About Access Text into Memo-area written. The display in my Program is neither the trouble. The SQLEXEC supply simply not the whole Memo-area back.
I have in the XProfan-Help yet under "Behobene Bugs" found, that the Reading Text-Blobs yet not functions has. Should but still then fixed his, or? or depends it so none together.
I make the in the momentum so:
SQL_Befehl$="Select RTF_Text from RTF_Texte where Aufgabe='"+Re_Position$+"'"
SQLEXEC SQL_Befehl$,1
Re_Text$=$ ListBox("Ergebnis",1)
Re_Text$=Decode64(Re_Text$)
SetText Re_AGK_01&,Re_Text$
SQLEXEC SQL_Befehl$,2
this is naturally only one neckline and serves too go ahead Testzwecken, so I sowohl The effects with the Listbox as well as with the Dateiausgabe testing can. and in both Make is the Text simply cut.
If any cords rip, I will whom Text einfachl in Lines divide and then in the data base zerstückelt Save. the wars I then Yes again zusammengesetzt.
Perhaps white Yes of/ one yet what. |
|
| |
| |
| |
|
|
Thomas
Freier | write You the in a Listbox or one Listiew? Frank having its ListView.dll for such Datenmengen extra with SetItemTextEx(H,T,s,L,A) extended.
with Blobs and dbIII having "Pascal" itself engage. time here search. |
|
| |
| Gruß Thomas
Windows XP SP2, XProfan X2 | 01/03/11 ▲ |
|
| |
|
|
Christof
Neuß | Hello Thomas,
It's all right not around the display. I write the Result into Richedit. The "Knoten" sits already former. I get from the data base not whom whole Text out. |
|
| |
| |
| |
|
|
RGH | Hi,
The length, The by SQL a Memo read becomes, can with @Set("SQLWidth", n) tuned go. Möglicherweise reicht in Your drop The voreingestellte length not from.
Greeting
Roland |
|
| |
| Intel Duo E8400 3,0 GHz / 4 GB RAM / 1000 GB HDD - ATI Radeon HD 4770 512 MB - Windows 7 Home Premium 32Bit - XProfan X4 | 01/03/11 ▲ |
|
| |
|
|
Christof
Neuß | Hello Roland.
THANK YOU!!!!!
the was the crucial Tipp. now functions it. again what learnt.
BTW: If I the Result into Listboxliste ausgebe, then can the entry max. 32.000 (and a couple Zerquetschte) characters long his, or? I werd's probably not need, it interested me only. then would it Yes nothing help, The SQLWidth on 65.535 To settle. Should then over The SQL.DAT weg, what? |
|
| |
| |
| |
|
|
| by me XP can I even explicit longer Strings as ListBoxEinträge insert:
var list&=create("list",0)
addString(list&,mkstr$("A",32768))
addString(list&,mkstr$("A",65536))
addString(list&,mkstr$("A",16777216))
print len(getString$(list&,0))
print len(getString$(list&,1))
print len(getString$(list&,2))
waitInput
end
gives at me tidy:
32768 65536 16777216 
from.
really too hardly verwunderlich, memory can indeed (too) "beliebig" big his and such ListBoxEintrag is (in the meantime) intern among other things one Speicherzeiger. |
|
| |
| |
| |
|
|
E.T. | RGH (03.01.11)
Hi,
The length, The by SQL a Memo read becomes, can with @Set("SQLWidth", n) tuned go. Möglicherweise reicht in Your drop The voreingestellte length not from.
time so as Zwischenfrage: how much is because voreingestellt ?? Konnt's nirgends find.. |
|
| |
| Grüße aus Sachsen... Mario  WinXP, Win7 (64 Bit),Win8(.1),Win10, Win 11, Profan 6 - X4, XPSE, und 'nen schwarzes, blinkendes Dingens, wo ich das alles reinschütte... | 01/04/11 ▲ |
|
| |
|
|
Christof
Neuß | @iF: having already so geliebäugelt, that The boundary evlt. already with Version 11.X aufgehoben is. Umso rather. then might I here Yes quite no Problems get. thanks for Test 
@Mario: M.E. are 1.024 characters tuned. I had nothing changed and it get always Lengths of 992 - 1024 gemeldet. Kürzere came through different Encodierungen zustande. More than 1.024 have I never get. i'm off too there and set to the reading the value on 65.535 and hereafter again on 1.024. |
|
| |
| |
| |
|
(788)
Deutsch
English
Français
Español
Italia