XProfan

- Page 1 -

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!

probe.zip	962 kB

Kurzbeschreibung:	View source, Inc-, EXE- and DLL-File

Hochgeladen:	01/11/16

Downloadcounter:
		Download

XProfan X3
Win10 16 GB RAM

XProfan X2
WinXP, SP3, Core(TM) i7-3770 @ 3.40GHz

Hi,

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

Compile Mark Separation

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.

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

XProfan X2
WinXP, SP3, Core(TM) i7-3770 @ 3.40GHz

Läufts with FreeProfan [...]

with you through?

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

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 ▲

- Page 2 -

Christof
Neuß

Yes. with Firebird have so did i already a little bit probiert. would be me even yet rather fallen as SQLite, if I then not again so many Files in the Programmverzeichnis need would. If I what with Firebird make, need I at least 4 DLLs, 1 MSG-File, my Program, The Datenbankdatei and the Quelldaten. i want in the Optimalfall only 3 Files in the Programmverzeichnis having. Program, Datenbankprogramm, Quelldaten. As I said, I experimentiere momentarily another bisschen rum. fundamentally kriegt one that sure too with the DLLs of Firebird there (to assimilate my I), but I find the something costly.

tempo is naturally too one Topic. at that reading and evaluate. it remaining neither with of/ one Quelldatei, there come hereafter yet further moreover. we talk over 50.000 - 300.000 Datensätze.
nevertheless there good Reasons, this still in a einfachen, local, simply kopierbaren data base To Edit.

others ideas... ?

XProfan X3
Win10 16 GB RAM

01/13/16 ▲

XProfan X2
WinXP, SP3, Core(TM) i7-3770 @ 3.40GHz

The Exe could simply The DLL from itself out to system32 copy, about if The DLL not loaded go could. simply Franks Datengenerator for take. over appdata/ could one naturally too cogitate.

01/13/16 ▲