| |
| |
|
| - Page 1 - |
|
Dietmar
Horn | Hello together,
today contact I time with a SQL-trouble order selected Hilfestellung on The SQL-Experten under you.
I work z.Z. with XProfan 11 in a komplexeren proposition. its already right far gediehen. The yet einzigste, but crucial Problempunkt is for me The on- or. Integration the RDBS Firebird (Freeware or. Open-Source) or. Interbase (the kostenpflichtige Gegenstück of Borland To Firebird - like the Relationship between MS Office and Open-Office).
yet had to I yet never big with SQL keep busy, except that I me always times the XProfan-Help to that SQL-Topic reingezogen and the everything as right logical felt having. still How often, lying the dog certainly only in a tiny detail bury, I not know, or in a Error, whom I made or overlooking have.
Firebird and Interbase knew I To to 4 weeks not yet time of names since, because I something like yet never needed having - but now is it so far.
ODBC-driver and Firebird are installs.
first of all goes it therefore, a link produce. under windows 2000 (in unserem Vereins-cabinet) works The Initialisierung with SQLInit meanwhile.
The Initialisierung supply under W 2000 How desired the lever back:
under Windows XP yields the however yet always 0 (means failed), and in the Contrast To W 2000 appear there before not yet time the dialog to that prompt of Username, PWD, etc.
before this Completed: the produce the link not resolved is, need I none big go on.
Literatur over Firebird have I meanwhile tonnenweise, still before I not create, on all windows-Systemen ex 2000 up a reliable link produce, nützt me the everything unfortunately not too plenty.
can me Perhaps someone help, the itself already time something hither so engage has?
The next steps, So the Neuanlegen of/ one data base, or the Edit / Reading of/ one vorhandenen DB and the Weiterverarbeiten the data in the actual Program might then solely another pure Fleiß- and Logik-work his.
the sheer z.B. on dBase isn't possible, because dBase dbzgl. not over The for this proposition erforderlichen Feautures verfügt.
who can evtl. help on?
I suspect time, if the program sometime with Firebird runs, then should the program too with Interbase functions - or?
Greeting and thanks beforehand
Dietmar |
 |
| |
| Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...]  Windows 95 bis Windows 7 Profan² 6.6 bis XProfan X2 mit XPSE Das große XProfan-Lehrbuch: [...] | 01/11/09 ▲ |
|
| |
|
| |
| |
| - Page 4 - |
|
|
Dietmar
Horn | @Roland: thanks for code! i'll it try, soon first time in my proposition incorporate. as compromise-Solution should the first of all wealthy, still on duration taugt the presumably not too plenty, because it vorgesehen is, prospective FB/IB-Databases with BLOB-Feldern of others Programs auszulesen and them data to exchange.
somehow must with the whom real BLOB-Feldern functions, because any me known competition-programs can the finally ditto. still into me available stehenden Help Files find I utterly none Info hereon.
@Peter: With the whom BLOB-Subtypen know I meanwhile - so far i was already. still nirgendwo finds one one word above, or a commands, How the goes.
Greeting
Dietmar |
|
| |
| Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...] Windows 95 bis Windows 7 Profan² 6.6 bis XProfan X2 mit XPSE Das große XProfan-Lehrbuch: [...] | 02/23/09 ▲ |
|
| |
|
|
Uwe
''Pascal''
Niemeier | Hi Dietmar!
How stehts because with my long Strings-routine? [...]
where there so which Problems?
SeeYou
Pascal |
|
| |
| |
| |
|
|
E.T. |
...long Strings-routine?...
I Have The experience made, the, if The Strings To long go, FB whom kompletten Befehlsstring not undertaking. this is with the Message Unerwartetes String-end (or so similar) receipting and the SQL-commands not carryed out.
whether the cut off now with FB or with the Übergabe by XProfan happens, must I try... |
|
| |
| 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... | 02/23/09 ▲ |
|
| |
|
|
RGH | Uwe Pascal Niemeier
Hi Dietmar! How stehts because with my long Strings-routine? [...] where there so which Problems? SeeYou Pascal
Firebird/Interbase supported of my Wissens VarChars only To 32 kB, means remaining my Solution or objectively BLOBs. i'm bislang but not clear, How I by ODBC/SQL on BLOBs grab can. to the ODBC-Treibern for Interbase/Firebird there so well How no Documentation.
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 | 02/23/09 ▲ |
|
| |
|
|
Dietmar
Horn | Hello Uwe,
I faith not, that the thing with the long Strings The final Solution the Problems darstellt.
with whom VARCHAR-Textfeldern shining it no Problems To give, but the grasp unfortunately only maximum 32 KB. In of my data base are however by a long shot more Datenmengen To Save (and How supra already described, because of the compatibility with others IB/FB-Datenbanksystemen in real BLOB-Feldern). the can next to kleinerem Kleckerkram something more RTFs with pictures, eingescannte Texts as JPG or quite Videos his.
Greeting
Dietmar |
|
| |
| Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...] Windows 95 bis Windows 7 Profan² 6.6 bis XProfan X2 mit XPSE Das große XProfan-Lehrbuch: [...] | 02/23/09 ▲ |
|
| |
|
|
Dietmar
Horn | @Roland: I had there in irgendwelchen Tutorials already something To IB/FB-BLOBS in Delphi and / or C++ found.
I must time search, Perhaps find I The Codes To friday again. Delphi and C++ is by me however already zuviele years ago, as that I so yourself big what with XProfan begin could.
or Thomas Z. finds the faster again, because it I had so already longer with my Bloberei genervt.
Greeting
Dietmar |
|
| |
| Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...] Windows 95 bis Windows 7 Profan² 6.6 bis XProfan X2 mit XPSE Das große XProfan-Lehrbuch: [...] | 02/23/09 ▲ |
|
| |
|
|
Uwe
''Pascal''
Niemeier | Hi people!
I had MEMO or. VARCHAR uses, because the The biggest boxes were (termless), The The me available dbs To afford had. IMHO ought to it too with each others Feldformat in others dbs klappen.
the write by profanem SQLEXEC klappte with More as 500 KB; though coming it with reinen Binärdaten To Fehlern or crash. whether the of FeldTyp depending, of driver or of SQLEXEC can I (yet) not say.
at that Reading ought to the FeldTyp anyway from the API-routine automatically recognized go.
what very happens because, if your attempts, a BLOB To describe or. auszulesen? (though would I no Images take, separate a artificially begot eindeutigen String)
SeeYou
Pascal |
|
| |
| |
| |
|
|
Thomas
Freier | Perhaps on this place: [...] time something buddeln or Help erbitten?
or, you have already everything active, The Freewareversion:
EMS SQL manager for InterBase/Firebird Freeware is a Free collection of Werkzeugen, which a affordable “alles-in-einem“ Solution for producing InterBase/Firebird Datenbankverwaltung supply. SQL manager Freeware supported The last InterBase and Firebird versions and allows it, The DBA and Entwickleraufgaben To vereinfachen.
of [...] tested? |
|
| |
| Gruß Thomas
Windows XP SP2, XProfan X2 | 02/23/09 ▲ |
|
| |
|
|
Dietmar
Horn | Hello Thomas,
this SQL-manager know I already. time foreseen of it, that the part a unmögliche Bedienerführung has, is the only a 30-days-Trial, The by me already run down is. too in unserem PC-cabinet there not any more many computer, where it not yet draufgewesen was.
me goes not therefore, something with irgendeinem external Tool into data base To stuff (the Tool could one itself then Yes if need be buy), separate the must coercive of XProfan-Program from occur (see supra). and of course not only the Hineinstopfen, separate too the Reading and the Updaten the BLOBS.
I faith, i'll slow really soon beBLOBbt. 
Greeting
Dietmar |
|
| |
| Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...] Windows 95 bis Windows 7 Profan² 6.6 bis XProfan X2 mit XPSE Das große XProfan-Lehrbuch: [...] | 02/23/09 ▲ |
|
| |
|
|
Thomas
Freier | | Hello Dietmar, even if your the already tested have, can whom Kaufanwendungen by SQL on The Blob-boxes grab? if so, must it still a lane over XProfan give. where go The data the Blob-boxes eingefügt? How with Access into Datentabelle or How with FoxPro or dBase V in a separated scheduler? |
|
| |
| Gruß Thomas
Windows XP SP2, XProfan X2 | 02/23/09 ▲ |
|
| |
|
|
Dietmar
Horn | into BLOB-area becomes of my Wissens to with IB/FB solely one Verweis hereon eingefügt, where very (on which address, or so) in the pertinent data base (not scheduler) the data or. Files find. means like with whom dBase-Memo-Feldern. only with the Difference, that itself (How with dBase) The thousands of of Files not external Files bustling, separate somewhere solid into DB on- or reingeklatscht go - however not any (visible) tables.
Greeting
Dietmar |
|
| |
| Multimedia für Jugendliche und junge Erwachsene - MMJ Hoyerswerda e.V. [...] Windows 95 bis Windows 7 Profan² 6.6 bis XProfan X2 mit XPSE Das große XProfan-Lehrbuch: [...] | 02/23/09 ▲ |
|
| |
|
|
Thomas
Freier | | Dietmar, I wisely not whether you the attachment moreover helps. have another 30days dbaseplus2.2 (80mb) found. be self not deeper boarded. |
|
| |
| Gruß Thomas
Windows XP SP2, XProfan X2 | 02/23/09 ▲ |
|
| |
|
(447)
Deutsch
English
Français
Español
Italia
