XProfan

- Page 2 -

RGH

alas Yes:

naturally can too whom SQL-course from the XProfan-Help with FireBird absolvieren.

moreover have I with the VERY empfehlenswerten (and free) SQL manager 2008 Lite for InterBase and Firebird (whom there here: [...]

) The data base KURSDB.GDB prepares and in the ODBC-manager eingebunden.

The Creation the scheduler varies something, there InterBase none Datentyp NUMBER knows, separate instead whom type NUMERIC. so can The scheduler books now prepares go:
Compile Mark Separation

declare db&
cls
db& = sqlinit(DSN=KursDB;UID=SYSDBA;PWD=masterkey;DBNAME=D:\Dokumente\FireBird\KURSDB.GDB)

If db& > 0

    Tabelle löschen, wenn schon vorhanden
    Set(Errorlevel,0)
    SQLExec DROP TABLE buecher,0
    Set(Errorlevel,1)
    Tabelle neu erzeugen
    SQLExec CREATE TABLE buecher (titel CHAR(40), autor CHAR(40), preis NUMERIC(20,5)),0
    SQLDone

Else

    Print Datenbank konnte nicht geöffnet werden!

Endif

waitinput
end

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

Dietmar
Horn

thanks, Roland!

To hierhin works it now too by me. On The story with the driver would I yourself presumably never come.

with my further ask login I then later again. by then must I first yourself yet something experiment.

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: [...]

Dietmar
Horn

Hello Roland,

could You time Please The vain KURSDB.FDB here append. The concise 30 MB for SQL-manager are my modem To dwell To big. I can the program first on the friday by DSL fetch.

know You, whether The Dateiformate *.GDB (Interbase) and *.FDB (Firebird) hundertprozentig identical are?

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: [...]

RGH

Hello Dietmar,

I suspect time, that the two Formate identical are. The SQL-manager comes with both clear. I slopes here time my KURSDB.GDB (gezipt) on. The two datensätze from the 2. Kursteil are already drin.

Greeting
Roland

KURSDB.ZIP	39 kB

Kurzbeschreibung:	KURSDB.GDB (with 2 Datensätzen from the 2. Kursteil)

Hochgeladen:	01/13/09

Downloadcounter:
		Download

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

Dietmar
Horn

Hello Roland,

yet works the everything wonderful. The remainder might now stupide Fleißarbeit and the Herumschlagen with the korrekten Syntax go.

an grundsätzliche question have I yet:

an data base exists from tables, and eachone scheduler find the Datensätze. with dBase exists The data base a or several DBF-Files, and each DBF-File is a scheduler, in the The suitable Datensätze include are. with Firebird / Interbase against it is all tables in a File. I hope, I have the so correctly. understood.

is it now too somehow possible, in tables against Untertabellen anzulegen?

Simple example:

data base: Adressen (1. Variante)
tables: Hoyerswerda, Berlin
scheduler Hoyerswerda: Untertabelle manly, Untertabelle feminine
scheduler Berlin: Untertabelle manly, Untertabelle feminine
In eachone Untertabelle stand then naturally The Datensätze with name, First name, etc.

or can I the only so set up:

data base: Adressen (2. Variante)
tables: Hoyerswerda_Männlich, Hoyerswerda_Weiblich, Berlin_Männlich, Berlin_Weiblich
In eachone scheduler then naturally The Datensätze with name, First name, etc.

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: [...]

Dietmar horn

is it now too somehow possible, in tables against Untertabellen anzulegen?

not really and not really necessary or helpful.

NeTabelle:UID;Name;Vorname;Adresse;Geschlecht;HYFlag,DabeiSeid...

If you only any HYer filtern want, then still simply over The inquire on The jeweilige DB - z.B. select uid from NeTabelle where HYFlag = 1 order by DabeiSeid desc.

You can but (naturally) many tables in addition in the DB having, Community z.B. has a scheduler for User, for Threads, for Postings, for Smilies...

Thomas
Freier

not really and not really necessary or helpful

RICHTIG!
because Dietmar, The boxes do you need too in your Hauptdatei, in them then the suitable key-key his must, circa in the others File The data to find. In such Make a request-Query To write is damn mühsahm. Ausgelagert his could Vorwahlen, PLZ, BLZ, etc. . means data, on The several Datensätze back grab.

Gruß Thomas
Windows XP SP2, XProfan X2

Dietmar
Horn

Yes this is me already clear, that to the too with such Filtern solve can. if need be I will the too vaguely so make must.

The data base of my Projektes is integral komplexer aufgebaut - with the whom Adressen HY / Berlin ought to only as Minibeispiel to explanation serve, I very my.

the Organigramm (or. the structure) exists from 4 tables, with apiece 2 Untertabellen and these against with apiece 4 under-Untertabellen. altogether means at least 32 tables, plus evtl. another slightly what on Reserven for Nebensächlichkeiten and later extensions. it would not so bad, if with the whom Untertabellen so went, How I me the vorstellte - the would a crowd Logik-circa-The-corner-Denkerei save ...

the Whole should no Mini-Adressenverwaltung o.ä. go, separate one commercial Program (what it in this shape not yet gives) for a Special group of Arztpraxen, of them it nationwide 20000 potential customers gives. because of the interface(n) To others Branchen-Programs be I there coercive on Interbase / Firebird dependent.

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: [...]

Michael
Wodrich

but not Untertabellen uses one Relationen. Redundanzen should possible vermieden go, but:
apiece less Redundanzen, so komplizierter.

Tutorial [...]

data base-Designer [...]

map and create of/ one data base (Although another data base-Engine, but
one can something to the Relationen from it learn: simply time durchklicken and reading)
[...]

Best wishes
Michael Wodrich

Programmieren, das spannendste Detektivspiel der Welt.

Dietmar
Horn

thanks, Mischa!

on the friday I will me the everything naturally by DSL-access in my gray boxes reinsaugen and abspeichern, etc. Redundanzen, Relationen etc. are me already since my Ma-/Ph-studies to -zig years no Fremdwörter.

tommorrow (wednesday) I will first time in Berlin on the way his, circa with the proposition-Mitstreitern on unserem Firebird-proposition further particular konkreter abzustimmen. From Medizin, Arztpraxen, etc. have I yet naturally exakt so much Idea, How z.B. a cow of Stabhochsprung.

meanwhile have I as XProfan-Programmer for good (really already since middle december 2008) whom Zuschlag for this proposition get.

high lebe XProfan!

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: [...]

Dietmar
Horn

... what about me ex ca. 16.00 watch To ca. 23.00 watch (open end) in Adlershof / Adlergestell ...

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/14/09 ▲

Dietmar
Horn

Hi,

the Save, change and Delete of Datensätzen works now.

now have I another further trouble, which I for my proposition absolutely solve must:

How can a arbitrary File (z.B. Test.rtf) in a scheduler Save, supplant, delete and again read. I suspect time, the Reading results over the extract the gespeicherten File in one temporäres directory, from the from one The File then through ShellExec, WinExec, etc. aufruft.

still How wars I by SQL The File in The scheduler mere and again out?

might me there Perhaps time one SQL-Profi one demonstration with the obigen KUESDB.GDB write, in the a arbitrary File stored and again read becomes? whether KURSDB.GDB or KURSDB.FDB is alike, because to my recent Tests are The Dateiformate of Interbase (*.GDB) and Firebird (*.FDB) apparently identical.

thanks and 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/09/09 ▲