English
Forum

SQLite;Text with More as 5 characters not working

 

Christof
Neuß
Hi,
I experimentiere now already a couple hours with SQLite rum. have me The actually SQLite.dll provides and here from the Forum The SQLite3.INC moreover gepackt. in the principle funktioniert's too well, but if I a Text into area pack, the longer as 5 characters is smears me the program ex.

have naturally already a little bit geforscht. The data come already in the scheduler on. the can I with the SQLite-Konsole to check on. About Feldlängen and -types power itself SQLite well neither so really thoughts... shining sooner on the function "SQLite.Value()" To lying. Ggf. too on the ?_UTF8toASCII (INC-File) or so. but of it understand I To little.

I slopes my small Probierprogramm and the INC-File at times.

has someone a idea, Why it lying could?

MERCI and greetings

Christof

2 kB
Kurzbeschreibung: Testprogramm
Hochgeladen:01/10/16
Downloadcounter197
Download
770 kB
Version:Aktuelle DLL
Hochgeladen:01/10/16
Downloadcounter207
Download
10 kB
Kurzbeschreibung: INC-File here from the Forum
Hochgeladen:01/10/16
Downloadcounter168
Download
 
Win10 16 GB RAM
01/10/16  
 




ByteAttack
Win 7 - 64bit / XProfanX3
No Problems ???

 
XProfan X3
Website:  [...] 
Facebook:  [...] 
01/10/16  
 




Christof
Neuß
Tja, what should I like this hold?
now have I the time of my Dienstrechner on my private Laptop copies and... functions.

thanks for Denkanstoß...

Perhaps find I Yes with opportunity something... comic.
 
XProfan X3
Win10 16 GB RAM
01/10/16  
 




Christof
Neuß
To early gefreut...

with More and longer data jumping me the program again from the track ("XProfan not working More...").

I read really a right large CSV-File one. the functions too. As I said, with the SQLite-Konsole can I one Select * from ... put down and get any data correctly displayed. it must means with the Reading concern.

in a, Why the lying can...
 
XProfan X3
Win10 16 GB RAM
01/10/16  
 




Christof
Neuß
I krieg's simply not there.

Hab' here once more one relatively simple Program appended.
be still the opinion, that The function ?_Value() or The therein genutzte function ?_Utf8ToAscii a Error having. but - How said - there be I do not firm enough, around the award can.

it functions always then not, if More as 5 characters in the area are.

Wär' already class, wenn's someone find would...

THANK YOU!

962 kB
Kurzbeschreibung: View source, Inc-, EXE- and DLL-File
Hochgeladen:01/11/16
Downloadcounter52
Download
 
XProfan X3
Win10 16 GB RAM
01/11/16  
 



Hi,

supplant time function ?_Value from the sqlite3.inc in these:
Proc ?_Value

    Declare val&

    With ?_TableMap#

        If .RowPos& > 0 And .RowPos& <= .Rows& And .ColPos& > 0 And .ColPos& <= .Cols&

            val& = LONG(.Table&, (.ColPos& - 1 + (.RowPos& * .Cols&)) * 4)

            If val&

                //?_UTF8ToAscii(val&)
                Return string $(val&, 0)//< new

            EndIf

        EndIf

    EndWith

    Return ""

ENDPROC


and teste times the probe.prf.

by me runs so then with FreeProfan through.
 
01/11/16  
 




Christof
Neuß
JA!!!
Sorry, having even not yet really on the new ?_Value umgestellt.

the shining so To functions. d
THANK YOU!!!

I Try another bisschen moreover... but now sieht's well from.
 
Win10 16 GB RAM
01/11/16  
 



Läufts with FreeProfan  [...]  with you through?
 
01/11/16  
 




Christof
Neuß
FreeProfan? Why FreeProfan? have I by me none installs. ought to I? be simply with the X3-Version on the way. on the private PC incidentally with windows 10.

so läuft's now. Sowohl in the Interpreter as well as in the EXE-Version. The only "Hürde" is, I The Ergebnisstrings with UTF8Decode() treat must, so The Umlaute etc. functions. at that Reinschreiben go The Yes into UTF8-stature transfer, if I the right understood have.
but this is Yes no wirkliches trouble.
 
XProfan X3
Win10 16 GB RAM
01/11/16  
 




Christof
Neuß
what remaining, is the question, Why ?_UTF8ToAscii not functions.

now be I but my target already one good Piece hither come.

further Construction site in this Context is it, The SQLite3.DLL into Own EXE To to assimilate. moreover Try I with the Datengenerator, MemoryModulen and MMTool rum. fundamentally functions the too, but since must I another little with keep busy. is it so, I then The previous SQLite3.INC with the therein abgelegten ?_... - Procedures so not need can or paraphrase must?
 
XProfan X3
Win10 16 GB RAM
01/12/16  
 




Georg
Teles
Hello,

The SQLite3.INC must You then but properly adjust, speak The Prozessadressen at loading the DLL detect and the Procedures therefore paraphrase. Since there it one small example with whom MemoryModulen if I me not täusche  [...] 
 
XProfan X3
TC-Programming [...] 
XProfan 8.0 - 10.0 - X2 - X3 - X4

01/12/16  
 




Michael
W.
Hm, had You really already time Firebird tested? the there as embedded Version for XProfan.

look in the Help under 16.5. - Firebird embedded

there's too German Hilfestellung on the FireBird-pages:  [...] 

These data base can More, has right String- and Int-boxes (too Blob's) and if the proposition To big becomes - then position one simply on The large Server-Version circa.
 
XProfan X3
System: Windows 8/10, XProfan X4
Programmieren, das spannendste Detektivspiel der Welt.
01/12/16  
 




Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

15.794 Views

Untitledvor 0 min.
rquindt01/28/22
rafl12/16/20
p.specht11/28/18
Christof Neuß11/19/17
More...

Themeninformationen



Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie