| |
|
|
- Page 1 - |
|
 RGH | Getestet with Profan2cpp 1.6b:
If with InStr() one dritter Parameter (Offset) with indicated becomes, becomes this evident circa 1 wrong interprets. The following Testprogramm power it explicit:
declare split%, pos%, set$, Text$
text$ = Hugo what hier. Hugo what hier.
print instr(Hugo, Text$) In XProfan and Prf2Cpp same: 1 - 1
print instr(Hugo, Text$,1) In XProfan and Prf2Cpp same: 1 - 1
print instr(Hugo, Text$,16) In XProfan and Prf2Cpp same: 16 - 16
print instr(Hugo, Text$,17) In XProfan and Prf2Cpp UNgleich: 0 - 16
waitinput
end
In XProfan supply The latest row Correctly the value 0, there ex position 17 (the u in the 2. Hugo) the sought String Hugo Yes not any more vorkommt. Prf2Cpp supply against the value 16, the definitiv to the place lying, ex the sought becomes.
Greeting Roland (otherwise of Profan2CPP keen, there itself so without each hoisted almost any programs by Knopfdruck explicit speed let) |
|
|
| 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 | 12/18/07 ▲ |
|
|
|
|
| |
|
- Page 1 - |
|
 RGH | Sebastian king
To its Erscheinungstermin can I unfortunately yet nothing say
there's no hurry. If one it time rausgefunden has can The request properly modify. If the Result of Instr() larger as The length the Strings is, is it even as 0 To werten.
though is me today (I speed in the firm straight one of me in XProfan geschriebenes Statistik-Program, that over 23 millions Datensätze from beinahe 3000 Text files einliest, machine and a MySQL-data base the Rechenzentrums writes) another Another Error noticed:
2006-12-18 > 2005-07-16 13:34:26 yields 0 (wrong), though the Stringvergleich 1 (true) yield should. If I the first String now circa 9 space on The same length the second Strings bring, is correct the Result the Vergleichs.
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 | 12/18/07 ▲ |
|
|
|
|
 Sebastian König | RGH
there's no hurry. If one it time rausgefunden has can The request properly modify. If the Result of Instr() larger as The length the Strings is, is it even as 0 To werten.
not integrally: its in the momentum rather so, that (Startposition - 1) zurückgegeben becomes, if the String not found becomes. i don't know, Why and when I this Error installed have... probably is it yet not noticed, there the Default for Startposition simply 1 is and then correctly 1 - 1 = 0 zurückgegeben becomes...
RGH
though is me today (I speed in the firm straight one of me in XProfan geschriebenes Statistik-Program, that over 23 millions Datensätze from beinahe 3000 Text files einliest, machine and a MySQL-data base the Rechenzentrums writes) another Another Error noticed:
2006-12-18 > 2005-07-16 13:34:26 yields 0 (wrong), though the Stringvergleich 1 (true) yield should. If I the first String now circa 9 space on The same length the second Strings bring, is correct the Result the Vergleichs.
Hmm. here have I evident the behaviour the Stringsvergleich in XProfan evident not very enough analysiert... the code, the with the >-operation letztlich called becomes, sees in the momentum so from (from pstring.h):
D.h. to the lexikographischen comparison becomes first examined, whether not the a already longer or kürzer as the others is. If the in XProfan not so is, must I the well Change... I login me expected tommorrow time with of/ one new Version 
MfG
Sebastian |
|
|
| Windows XP, XProfan/Profan² 4.5 bis 11 Profan2Cpp-Homepage: [...]  Alte Profan²-Seite: [...]  | 12/18/07 ▲ |
|
|
|
|
 RGH | Sebastian king
to the lexikographischen comparison becomes first examined, whether not the a already longer or kürzer as the others is. If the in XProfan not so is, must I the well Change... I login me expected tommorrow time with of/ one new Version 
No, this is in XProfan (and Basic and Delphi ...) not so. The length the Strings does nothing to thing. One Leerstring is the Kleinstmögliche String, otherwise count only The Ansicodes the characters. < chr$(0) < chr$(1) ... < ... Text < text1 ... aber text > texa1
concise: i think, you mußt The Längenüberprüfung simply omit.
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 | 12/18/07 ▲ |
|
|
|
|
 Sebastian König | RGH
concise: i think, you mußt The Längenüberprüfung simply omit.
Yes, so make I it now - only for drop, that of/ one the both Strings empty, had I another amendment-request install.
an corrected version goes same by Email on you out .
MfG
Sebastian |
|
|
| Windows XP, XProfan/Profan² 4.5 bis 11 Profan2Cpp-Homepage: [...]  Alte Profan²-Seite: [...]  | 12/19/07 ▲ |
|
|
|
|
 RGH | Sebastian king
an corrected version goes same by Email on you out  .
super! thanks!
The both Problems are lane. but i'm on one further punched: Embedded SQL shining not To functions. (can it his, that it defaultmäßig off is?)
if prav_db% = 1
sql$ = insert into prav values (:id_db$,:timestamp_db$,:datum_db$,:berater_db$,:kunde_db$,:sek_db$,:modul_db$,:aktion_db$,:online_db$,:dauer_db&,:moddauer_db&,:berdauer_db&)
sqlexec sql$, 2
else
sql$ = insert into fim values (:id_db$,:timestamp_db$,:datum_db$,:berater_db$,:kunde_db$,:sek_db$,:modul_db$,:aktion_db$,:online_db$,:dauer_db&,:moddauer_db&,:berdauer_db&)
sqlexec sql$, 2
endif
here reports itself the ODBC-driver with the Message, that The SQL-syntax near values (:id_db$;:time... not Order is. the might with eingeschaltetem embedded SQL so never at ODBC-driver arrive.
Greeting Roland
(Sorry, I this Thread for Message missbrauche, but of job can/can I,may I no private eMails ship.) |
|
|
| 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 | 12/20/07 ▲ |
|
|
|
|
 Sebastian König | RGH
super! thanks!
The both Problems are lane.
Ah, super - this is Schonmal well! 
RGH
but i'm on one further punched: Embedded SQL shining not To functions. (can it his, that it defaultmäßig off is?)
if prav_db% = 1
sql$ = insert into prav values (:id_db$,:timestamp_db$,:datum_db$,:berater_db$,:kunde_db$,:sek_db$,:modul_db$,:aktion_db$,:online_db$,:dauer_db&,:moddauer_db&,:berdauer_db&)
sqlexec sql$, 2
else
sql$ = insert into fim values (:id_db$,:timestamp_db$,:datum_db$,:berater_db$,:kunde_db$,:sek_db$,:modul_db$,:aktion_db$,:online_db$,:dauer_db&,:moddauer_db&,:berdauer_db&)
sqlexec sql$, 2
endif
here reports itself the ODBC-driver with the Message, that The SQL-syntax near values (:id_db$;:time... not Order is. the might with eingeschaltetem embedded SQL so never at ODBC-driver arrive.
really ought to it eingeschaltet his, if it not explizit with the Kommandozeilen-option -noemsql deaktiviert becomes. I see time to, what there schiefläuft and login me again.
MfG
Sebastian |
|
|
| Windows XP, XProfan/Profan² 4.5 bis 11 Profan2Cpp-Homepage: [...]  Alte Profan²-Seite: [...]  | 12/20/07 ▲ |
|
|
|
|
 Sebastian König | OK, The cause the Problems was right quick found: Profan2Cpp berücksichtigt embedded SQL only directly in SQLEXEC-command! i was of it gone out, that the too in XProfan so is...
is it objectively so, that it in XProfan with beliebigen Literalen functions?
MfG
Sebastian
Nachtrag: i see too The Help so, that it only SQLEXEC functions:
XProfan Help
with SQLEXEC can ex XProfan 9 directly variables, How in embedded SQL at C++ or. Java, inserted go. simply a colon to The Variable: (...)
my supposition (or. Befürchtung) is, that XProfan whom String dynamic investigating and ggf. The Variablennamen supplant. In Profan2Cpp goes this unfortunately konzeptionell not - the String must to that Time the Translation aufgelöst go.... |
|
|
| Windows XP, XProfan/Profan² 4.5 bis 11 Profan2Cpp-Homepage: [...]  Alte Profan²-Seite: [...]  | 12/20/07 ▲ |
|
|
|
|
 RGH | Hello Sebastian,
embedded SQL fubktioniert in the doing only SQLEXEC and not beliebigen Literalen.
(I had in the doing too with the Version for arbitrary Literale experimentiert, for but because of the einfachen Hochkommas, The a Stringwert einschließen, no sinnvolle application found.)
at that obigen example functions the intern means so: in the String SQL$ standing means always the, what in Program standing, means z.B. where id = :id$. first the SQLEXEC-commands self investigating whom it übergebenen String on eingebettete Variables and supplant these then through ihren Content. would be in id$ means z.B. the worth session5A6BC95601 stand, would from :id$ then means where id = session5A6BC95601 go. The dissolution can naturally first to Laufzeit happen, too in the Runtime.
OK, I know, that the The thing for you not plainer power. Möglicherweise must You embedded SQL objectively the direct Literal behind SQLEXEC limit. but unfortunately functions the presently neither. If I with the whom obigen SQL$-Strings make ...
if prav_db% = 1
sqlexec insert into prav values (:id_db$,:timestamp_db$,:datum_db$,:berater_db$,:kunde_db$,:sek_db$,:modul_db$,:aktion_db$,:online_db$,:dauer_db&,:moddauer_db&,:berdauer_db&), 2
else
sqlexec insert into fim values (:id_db$,:timestamp_db$,:datum_db$,:berater_db$,:kunde_db$,:sek_db$,:modul_db$,:aktion_db$,:online_db$,:dauer_db&,:moddauer_db&,:berdauer_db&), 2
endif
... crashes the Prof2CPP with of/ one Schutzverletzung ex. (with kürzeren Lines runs it but through.)
but Please now no Hektik, Sebastian. I have my Program now rewritten and on embedded SQL waived (there see The Lines hold then something komplizierter from: ... values ( + id$ + + ...) and it shining now To functions. from the mehrtägigen Statistikjob is now hopefully again a thing become, The over night durchläuft. (one can Vorgesetzte hold "And long Waiting ... ;) )
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 | 12/20/07 ▲ |
|
|
|
| |
|
- Page 2 - |
|
|
 | I faith Sebastians mögliches trouble in the reference on The making selbiger Funktionalität has sooner The cause the it with lists works should circa on Variableninhalte grab to which the function self not at all famous his can. The Source becomes hierbei Yes not interprets and the variables are in the prf2cpp-drop Yes real variables. what however one plainer Workaround for Sebastian his could is the paraphrase such Literale through its Precompiler into not-embed-Variante ala +vari$+. |
|
|
| |
|
|
|
 RGH | iF
what however one plainer Workaround for Sebastian his could is the paraphrase such Literale through its Precompiler into not-embed-Variante ala +vari$+.
what but, if in the string objectively such a thing How :hugo$ stand should and it not for SQLEXEC virtual is? (Zugegeben: its sooner unwahrscheinlich, but even not unmöglich.)
i think, it speaks nothing against it, To say: Prf2CPP can embedded SQL only, if, if it as Literal behind SQLEXEC standing. then can itself the geneigte Programmer dananch richten.
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 | 12/20/07 ▲ |
|
|
|
|
 | RGH
what but, if in the string objectively such a thing How :hugo$ stand should and it not for SQLEXEC virtual is? (Zugegeben: its sooner unwahrscheinlich, but even not unmöglich.)
ought to one therefore not vorsorglich The Inputs dahingehend to check on? I faith I have the XProfansche SQLEmbedded therefore not yet integrally kappiert - the should here but not the Topic his.
what I tried To say is the it even the Sebastian not possible is to Laufzeit on the Content of/ one variables access its name too first to Laufzeit determined/created becomes without on z.B. lists How Special assoziative Arrays grab To must. therefore my suggestion the Umschreibens by the Präkompi. How it the resolve becomes it but naturally self best know - I Have Yes only gestochert.  |
|
|
| |
|
|
|
 Sebastian König | iF has the trouble very correctly. described... this is the, I with the String must to that Time the Translation aufgelöst go something unpräzise framed have.
as Notlösung hovers me in the momentum to, a Possibility incorporate, the embedded SQL temporär too for arbitrary Literale einzuschalten, best with the equal concept over Special comments, How I it already for Call() and External() in the Context with the Multithread-Problematik installed have (see point 3 under other Features in the Profan2Cpp-Help). the had whom benefit, that one The Codes with good reason geringem hoisted at the same time To XProfan and Profan2Cpp compatible can make.
around the others angesprochene trouble trouble I with opportunity - evtl. on the weekend, I tommorrow first of all yet on the Uni and then whom whole afternoon in the train will be... to that Happiness eilt it Yes not 
MfG
Sebastian |
|
|
| Windows XP, XProfan/Profan² 4.5 bis 11 Profan2Cpp-Homepage: [...]  Alte Profan²-Seite: [...]  | 12/20/07 ▲ |
|
|
|